Bus 101 Chapter 5
The universal standard language for processing queries and updates on a database is called _________. A. SQL B. DBMS C. DB2 D. HTML E. Java
A. SQL
Microsoft's most powerful DBMS is ________. A. SQL Server B. Oracle C. MySQL D. Excel E. DB2
A. SQL Server
The conversion of the existing traditional databases in organizations to NoSQL databases is ________. A. unnecessary when relational databases meet the needs of organizations B. highly efficient and is being practiced by many organizations C. highly recommended because it is user friendly D. very cost-effective but can be enormously disruptive
A. unnecessary when relational databases meet the needs of organizations
In a database of telephone customers in a large city, which would be a logical primary key? A. The area code B. The account number for each customer C. Customer's name D. Phone number's zip code E. Phone number's street address
B. The account number for each customer
Which of the following is an example of metadata? A. A cylindrical circle in a database diagram figure B. The data type of a field C. The value of a primary key D. A student's first and last name E. A DBMS
B. The data type of a field
What is the purpose of a DBMS? A. To provide a visual output of the company's data in a user-friendly manner to end users B. To create, process, and administer databases C. To provide forms and screen's to end users, enabling them to add to or modify the company's data in a user-friendly manner D. To control access to the storage media that holds a company's data E. To be the repository of a company's data
B. To create, process, and administer databases
Every table in a database must have a ________, which is a column or group of columns that identifies a unique record in the table. A. file B. key C. foreign key D. formula E. disk drive icon
B. key
Which of the following is a function of the database management system (DBMS)? A. implementing lean systems in workstations B. processing a database by inserting or modifying data C. eliminating bottlenecks in business processes D. automating workflows in the databases of companies
B. processing a database by inserting or modifying data
________ is an example of a NoSQL DBMS. A. DB2 B. C# C. MongoDB D. Access E. SQL Server
C. MongoDB
What is an advantage of NoSQL databases over relational databases? A. They are easier to design and use. B. They are typically developed by well-established database vendors such as Microsoft and Oracle, who already have relational DBMS products. C. They are better at processing images, audio, videos, and other large collections of bits that don't fit into relational structures. D. Companies are likely to convert from relational to NoSQL database systems very quickly. E. They are better at ensuring data integrity when the data is highly volatile (lots of updates).
C. They are better at processing images, audio, videos, and other large collections of bits that don't fit into relational structures.
Which of the following is true of browser-based database applications? A. The application, database management system (DBMS), and the database reside on the user's computer. B. They are written in object-oriented languages such as Structured Query Language. C. They are displayed and processed using html, html5, or css3. D. They use C++ as the standard language for user-side processing.
C. They are displayed and processed using html, html5, or css3.
Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________. A. creation B. modification C. administration D. processing
C. administration
In a database, a group of similar rows is called a ________. A. field B. record C. table D. matrix
C. table
Suppose you have table of employees, each with his or her own unique employee ID. Suppose you also have a table of departments for the company, each with a unique department ID. A department may have many employees, but each employee works for a single department. Which of the following is a true statement? A. The employee's primary key is the ID of the department in which s/he works. B. The employee ID will be a foreign key in the department table. C. The employee's primary key is the employee ID, and there is no foreign key in the employee table. D. The employee's primary key is the employee ID, and the employee table also has department ID as a foreign key E. The department's primary key consists of the department ID and the employee ID.
D. The employee's primary key is the employee ID, and the employee table also has department ID as a foreign key
What is the primary feature that distinguishes thin-client database applications from thick-client database applications? A. In thin-client applications, business rule logic takes place on the client but in thick-client applications, business rule logic takes place on the server. B. In thick-client applications, the database is stored on the client, whereas in thin-client applications, the data base is stored on the server. C. In thin-client applications, the program is usually written in a programming language such as Visual Basic or Java, and is installed on a user's desktop computer. D. Thin-client application programs run on the server whereas thick-client application programs run on the client. E. In thick-client applications, the user interface is done through a browser.
D. Thin-client application programs run on the server whereas thick-client application programs run on the client.
Generating reports and forms is done by ________. A. a DBMS B. SQL Server C. Oracle D. database applications E. MySQL
D. database applications
Databases that carry their data in the form of tables and that represent relationships using foreign keys are called ________. A. key databases B. relation databases C. distributed databases D. relational databases E. NoSQL databases
D. relational databases
The value of a database for a company with a very high visit rate by its customers is in its ________. A. margin analysis B. end-of-year profit statement C. estimated dollar value if it was to be sold to a direct competitor D. market share E. capability to quickly and accurately provide information regarding which customers fit specific profiles and then provide multiple ways to market services tailored to customers' needs
E. capability to quickly and accurately provide information regarding which customers fit specific profiles and then provide multiple ways to market services tailored to customers' needs
Generic attributes such as LastName, FirstName, and Student# are called ________. A. tables B. rows C. databases D. records E. columns
E. columns
The self-describing part of a database is called ________. A. column B. table C. row D. attribute E. metadata
E. metadata