Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
BIS 2
| Question | Answer |
|---|---|
| In a relational database, a unique identifier is known as a | primary key |
| In a relational database, a field that references a unique identifies in a related table is known as a | foreign key |
| A ____ or row in a table is a set of fields that all pertain to the same thing | record |
| A ____ or column in a table represents some characteristic of the thing contained within a table | field |
| Which of the following is not a disadvantage of using a spreadsheet over a database? | ease of use |
| How does a DBMS (database management system) typically manage a database? | by providing the means for creating, maintaining, and using databases |
| Stephanie has put together a list of guests as well as the gifts each guest brought to both her wedding shower and wedding. What is the best method for her to store this data? | database |
| For large and complex amounts of information, storing the information is best achieved by using what? | a database |
| For the purpose of displaying and analyzing information, a ____ is often the most effective solution | spreadsheet |
| When working on a small database for your office what would the easiest DBMS choice be? | microsoft access |
| What is a disadvantage of unnecessary redundancy? | Redundancy can lead to inconsistencies |
| The key component of a relational database is establishing a relationship or cross referencing tables. How is this task accomplished? | establishing a foreign key |
| When ensuring data consistency by eliminating data redundancy, you are following a set of rules known as what? | normal form |
| Netflix has countless copies of the newest movies released, as well as countless members that are willing to rent the newest movie. What type of relationship would this example mostly likely be? | many to many |
| The town of Mamou has two judges that hear all of the traffic violations from the previous week. Each judge can only preside over one violation at any given time. What type of relationship exists between these tables? | one to many |
| Your technology firm has been contacted by a local accounting firm about designing a database to organize clients and workload. The managing parter has described the way they angle business and you have decided that the best method of a diagram would be? | an entity relationship diagram |
| Why is the entity relationship diagram or database schema necessary, even if you never design or build a database? | to understand the structure of the database |
| You have finally decided to open your widget store in your hometown and now have to choose a location for your new business. Which of the following online databases would be the most effective source of information? | United States Census Bureau |
| An online database serves a different purpose than a typical relational database. Which of the following best describes the purpose that online databases serve? | points to source of information |
| If a table contains the primary keys from two separate but related tables, what would these keys be called? | foreign keys |
| You are entering your last year of college and are interest in finding information about which particular industry to enter upon graduation. Which of the following online databases would be the most effective source of information? | United States Bureau of Labor Statistics |
| You are entering your last year of college and are interested in finding info about the companies you have interviews lined up with. Which of the following online databases would be the most effective source of info? | The Business and Company Resource Center |
| You are asked to gather historic financial info about competitive firms to be used in forecasting future performance. Which of the following online databases would be the most effective source of info? | compustat |
| Which of the following is least likely to utilize a database? | home inventory list |
| ___ handle the processing of data in a multi-tiered architecture | applications |
| what are databases good at, as compared to spreadsheets? | storing and organizing information |
| A table in a database contains information about Employees. The portion of the table that would contain the Employee First Name for all Employees would be known as what? | field |
| A table in a database contains info about Employees. The portion of the table that would all of the information about one Employee would be known as what? | record |
| A table in a database contains information about Employees. The Employee ID uniquely identifies each entry in the table. What is this known as? | primary key |
| A table in a database contains info about Employees. The DeptNum repeats itself multiple times in this table but links each employee to another table that contains the information about that particular department. What is DeptNum known as? | foreign key |
| In a relational database, the link between two tables by a primary key and a foreign key is known as what> | a relationship |
| In a relational database, a primary key is sometimes made up of multiple fields. What is this known as ? | foreign key |
| When a many-to-many relationship is found in a relational database it is necessary to create a new table to link these together to eliminate the many-to-many relationship. What is the newly created table called? | an intersection table |
| At Joe's Outdoor Supply Shop, each customer has an account. The customer info and the account info are storesd in separate tables. Wha type of relationship would this example most likely be? | one to one |
| Database tables are made up of what? | records and fields |
| What term describes a simple choice among alternatives? | decision |
| The more _____ a decision, the more ____ one must be in order to make an effective decision | complex, skilled |
| Information and decision making are inextricably | linked |
| _____, _____, or untimely information can have impacts on decision making | insufficient, inaccurate |
| What type of decision is routine and repetitive and often has well-defined procedures for dealing with them? | structured |
| Every day when Brandon arrives at work he must decide to either take the stairs or use the elevator to get to his office on the third floor. What type of decision is this? | structured |
| What type of decisions are novel and do not have agreed upon procedures for making the decisions? | unstructured |
| What type of control makes sure that the tasks of the organization are being conducted efficiently and effectively? | operational |
| Semi-structured decisions can be supported through systems that allow ____ information retrieval | flexible |
| Strategic planning often involves ______ decisions because it is very difficult to anticipate the information needs of managers involved in strategic planning | unstructured |
| As the amount of structure in a decision _____, the need for flexibility ))))) | decreases, increases |
| What involves sensing conditions and predicting what conditions will require actions? | intelligence |
| What is the second phase of Simon's Information Systems and Decision model which requires developing alternative approaches to bringing about the required change? | design |
| What is the most critical phase in the detailed decision making process? | identity and clearly define the problem |
| What do you call conditions that any acceptable solution must provide? | requirements |
| Stephanie is looking to replace her coffee maker that only makes four pots of coffee. She wants a coffee maker that procedures more, but has very little space in her kitchen. which solution describes a requirement when Steph purchases her coffee maker? | size of the coffee maker |
| ___ are used to determine how well each alternative meets a particular goal or requirement | criteria |
| When considering decision making techniques/tools, which tool requires you to evaluate each alternative against all other alternatives? | paired comparison |
| The ____ uses a grid that lists all of the alternatives in the first column, and all of the criteria in the first row | decision matrix |
| Which technique is widely used in business for choosing among projects or products? | decision making |
| When verifying that the solution solves the problem at hand, you must be sure that the alternative meets all ___ and best meets the _____ | requirements, goals |
| Informational retrieval tools include database management systems, reporting tools, and _____ tools | document management |
| As a manager at your University Bookstore, u often run weekly inventory reports that give u lists of inventory on hand as well as inventory sold over the past week. The reports are run from data stored within DBMS. What type of info retrial tool? | reporting tools |
| Your national office of your student organization has established a portal for you to track news, memos, and download forms. What kind of system does this most closely describe? | document management tools |
| Before Valerie begins looking at houses, she has chosen to review her budget, and has decided on a very specific number that she is comfortable with for her monthly mortgage payment. What kind of analysis has Valerie done? | goal seeking analysis |
| The research department at your university gathers data on nearly everything on campus. What type of tools does the Institutional Research department likely need? | dedicated statistical software |
| After reviewing table after table of data for your marketing research project, you can no longer make much sense of most of the information. What type of tool would be able to help you uncover trends in the data? | Data visualization software |
| What type of control involves ensuring the efficient, effective use of resource in achieving the objectives laid out in strategic planning? | managerial |
| TPS can make decisions using predetermined rules and processes. This is an example of a _____ decision of an _____ control. | structured, operational |
| What technique is recommended to help get to the core of the problem a company is facing? | 5-whys |
| What is the primary benefit of having well-defined requirements? | they help you eliminate infusible alternatives early in the decision making process |
| In the decision making promises ____ can be thought of as "must haves," and ____ can be thought of as "likes to haves" | requirements, goals |
| As part of the process of identifying alternatives, a company may utilize a structured method for reaching consensus within a group while encouraging input from all group members. This method is known as what? | nominal group technique |
| A ____ helps users locate and retrieve information stored in documents, such as memos and policy documents | document management system |
| Which of the following is not a dedicated statistical software tool? | spreadsheet |
| What is known as a collective of interconnected devices that allow users and systems to communicate and share resources? | network |
| A _____ is an intelligent device that controls the flow or transmissions in and out of a network? | router |
| What device forwards transmission only to ports that are involved in the communications, based on the device's address? | switch |
| A ____ provides a physical address to a device because it has a unique ID written on a chip that is mounted in the card | network interface card |
| Your PC at your office is connected over wired communications. Your PC has a network cable that is plugged into your _____ so that your PC can be part of the network | network interface card |
| What type of device would you use to retransmit a signal that it receives, regretting it for strength? | repeater |
| The fasters transmission speeds on cables for a wired network are ____, while _____ are the slowest. | fiber, copper |
| When using your cell phone, what type of transmission are you using? | radio |
| One way to classify networks is by baseband or broadband. This is determined by the _____, _____ and bandwidth of the network. | speed, frequency |
| What does LAN stand for? | local area network |
| What type of network connects devices in a limited geographical area? | LAN |
| Many cities across the United States are considering fiber networks that would connect commercial and residential areas to a single network. This would be what kind of network? | WAN |
| Each computer attached to a network the Internet has a unique address called an | IP address |
| In February of 2011 the Internet Assigned Number Authority assigned the last block of IPv4 addresses. What is the new address standard? | IPv6 |
| What organization started the project that came to be known as the Internet? | Defense Advanced Research Projects Agency |
| What is one of the core characteristics of the Internet that has contributed to its rapid growth? | Interoperability |
| When you click on a _____ on your university's homepage, your browser sends a request to the Web server that houses the requested page | hyperlink |
| ur IT department has provided a secure channel that uses encryption another security features for u to access ur office network while u are traveling. What type of access is this? | Virtual Private Network |
| The committee's first priority is wireless access on your campus. The committee chair keeps discussing increasing enrollment numbers. What principle of architecture is the chair most likely alluding to? | scalability |
| ____ are processes that request services from servers | clients |
| ____ provide services to clients by responding to their requests | servers |
| When registering online for your classes you log onto to a website provided by your university. The computer and web browser that you are using acts as a _____, while the university computer acts as a ______ | client, server |
| What type of architecture can be used in different systems with different technology platforms? | Service Oriented Architecture |
| Your Information Systems group has decided to use Google Docs to work on your semester project. What type of architecture is your group using? | Cloud computing |
| Cloud computing allows organizations to rent computing resources form providers instead of having their own locally managed _____ and _____ | hardware, software |
| What allows one physical device such as a server or computer to operate as if it was several machines? | virtualization |
| What is the main difference between the initial set of web applications and Web 2.0? | Interactivity |
| at ur desk u notice that the voicemail light is blinking on ur phone, u have a new email, and u have a transcribed instant message on u computer screen in the form of an Instant Message. Your organization has most likely adopted what type of technology? | Unified Communications |
| Innovators are working on Web 3.0. What type of new technology is expected from Web 3.0? | semantics |
| A _____ is a form of repeater that has multiple ports to connect many devices together | hub |
| The _____ is a publicity accessible worldwide network of networks | internet |
| Which of the following is not a Web 2.0 technology? | |
| ____ refers to mass collaboration of information to solve a problem | crowdsourcing |
| What Web 2.0 technology refers to uses combining data or applications from several sources to create new ways to view data or create new aggregated results? | mashups |
| What web 2.0 technology allows several individuals to contribute to and share stored data and documents and includes controls to avoid two users from changing a document simultaneously? | collaborative content |
Created by:
leh467