Bus 101 Chapter 5

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Texas Statutes and Rules Pertinent to Life Insurance Only

View Set

Chapter 41: The Child With Gastrointestinal Dysfunction

View Set

ch 20 textbook practice One of the major functions of the lymphatic system is quiz

View Set

3.05 Lesson Assessment: The Movement

View Set