1) The purpose of a database is to ________. |
store lists of data involving multiple themes |
Databases are required to keep track of lists with multiple themes. (T/F) |
True |
4) A ________ is a self-describing collection of integrated records. |
database |
5) Which of the following best describes a byte in a database? |
It is a character of data. |
6) In a database, bytes are grouped into ________. |
columns |
7) In a database, columns are also called ________. |
fields |
8) In a database, rows are also called ________. |
records |
9) In a database, the collection of data for all columns is called a ________. |
record |
10) In a database, a group of similar rows is called a ________. |
table |
11) In a database, a table is also called a ________. |
file |
13) In a database, a column or group of columns that identifies a unique row in a table is known as a ________. |
key |
14) In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys. |
foreign |
15) Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases. |
relational |
16) In a database, a table is formally referred to as a ________. |
relation |
17) Data that describe the data contained in a database are called ________. |
metadata |
A database is a self-describing collection of integrated records. (T/F) |
True |
Bytes, which are characters of data, are grouped into rows in a database. (T/F) |
False |
In a database, columns are also called records. (T/F) |
False |
In a database, a key is a column or group of columns that identifies a unique row in a table. |
True |
Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases. (T/F) |
False |
To find out what a database contains, one can look at the metadata inside the database. (T/F) |
True |
30) A(n) ________ is a program that is used to create, process, and administer a collection of self-describing integrated records. |
database management system (DBMS) |
Which of the following is a database management system (DBMS) product from Microsoft? |
B) SQL Server |
________ is a popular enterprise database management system (DBMS) product from IBM. |
A) DB2 |
Which of the following is a function of the database management system (DBMS)? |
D) processing a database by inserting or modifying data |
The database management system (DBMS) provides applications for processing operations such as ________. |
C) inserting or deleting information |
SQL stands for ________. |
C) Structured Query Language |
________ is an international standard language that is used for processing a database. |
C) Structured Query Language |
One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________. |
C) administering the database |
Which of the following is considered an administrative function of the database management system (DBMS)? |
A) adding structures to improve the performance of database applications |
Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________. |
D) administration |
Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________. |
B) administration |
Most organizations develop their own database management systems. (T/F) |
False |
HyperText Markup Language is an international standard language for processing a database. (T/F) |
False |
A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. |
A) database application |
Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data? |
D) forms |
Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations? |
C) reports |
Which of the following elements of a database application provides security, data consistency, and special-purpose processing? |
B) application programs |
Traditional database application programs are written in object-oriented languages like ________. |
B) Visual Basic |
Browser-based database applications differ from traditional applications in that they ________. |
C) are usually open to the public |
Which of the following is a major drawback of multi-user processing of a database? |
C) lost-update problem |
Reports in database applications provide security, data consistency, and special-purpose processing. (T/F) |
False |
All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS) server computer. (T/F) |
False |
Traditional database application programs are written in object-oriented languages such as C++. (T/F) |
True |
Security requirements are more stringent for traditional applications than for browser-based ones. (T/F) |
False |
Which of the following is a drawback of the relational database processing model? |
C) It was never a natural fit with business documents. |
Which of the following is true of the relational database processing model? |
D) It represents relationships with the help of foreign keys. |
Which of the following is a nonrelational data store developed by Amazon.com? |
B) Dynamo |
76) ________ refers to software products that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud. |
A) NoSQL DBMS |