Deck 1: Getting Started

Question 1

The purpose of a database is to help people keep track of things.

Answer 1

True

Question 2

A database is self-describing because the user maintains a record of the database structure outside the database itself.

Answer 2

False

Question 3

An advantage of keeping data in lists is that if you add a new row of data to the list,you will never have null values occurring for any data item in the row.

Answer 3

False

Question 4

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

Question 5

Referential integrity constraints must be enforced by the application program.

Question 6

One problem with storing duplicated data is the potential for inconsistent values.

Question 7

A relational database can be defined as a self-describing collection of related tables.

Question 8

A possible problem with keeping data in lists is that if you delete a row of data from a list,you may also delete some data items that you want to keep.

Question 9

SQL stands for Structural Question Language.

Question 10

Usually,a database table containing both rows and columns is designed to store data for exactly two themes.

Question 11

The DBMS receives data update requests from the application program.

Question 12

Most organizations create and use their own database management system (DBMS)products.

Question 13

Application programs are responsible for creating,maintaining,and supporting database backup and recovery systems.

Question 14

Although users use database systems,they are not considered part of a database system.

Question 15

The DBMS is used to create the database itself.

Question 16

Relational database tables are commonly combined,queried,and processed using Structured Query Language (SQL).

Question 17

By separating data into tables containing data on only one theme each,making changes to the data is simplified.

Question 18

Metadata is the user data stored in the database.

Question 19

An advantage of keeping data in lists is that if you update a data value in one row of data in a list,other occurrences of the same data item in other rows will be automatically updated as well.

Question 20

A relational database stores data in the form of lists.

Question 21

There is no reason for serious database developers to learn many aspects of database processing technology because DBMS products like Microsoft Access hide these aspects.

Question 22

Microsoft Access 2013 uses the AutoNumber data type to create surrogate keys.

Question 23

A relational database is:

A) a self-describing collection of related tables.
B) a collection of forms and reports that support a given purpose.
C) a library of queries and data files for querying.
D) a set of applications and the data sets for those applications.
E) a set of metadata.

Question 24

The component of a database that makes it self-describing is the:

A) related tables.
B) applications.
C) library.
D) data set.
E) metadata.

Question 25

Which of the following is not a basic component of a database system?

A) Database
B) User
C) ERD
D) DBMS
E) Data applications

Question 26

In the general division of labor between database applications and the DBMS,the application program formats the results of a query into a report.

Question 27

The Microsoft Access 2013 application generator provides the ability to create and store forms,reports,and queries.

Question 28

The statement SELECT STUDENT.StudentNumber,STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
Is an example of:

A) QBE.
B) SQL.
C) QLE.
D) C++.
E) Java.

Question 29

SQL stands for:

A) Standard Query Language.
B) Structural Question Language.
C) Structured Query Language.
D) Standard Question Language.
E) Structured Question Language.

Question 30

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?

A) Maintaining the data may require changing the same data value in many locations
B) Inconsistency when a data item is used multiple times
C) Inability to store partial data
D) Duplication of data items
E) All of the above

Question 31

A database may be used to help people:

A) track which student is assigned to a particular advisor.
B) know the current inventory levels of products their company sells.
C) check on the estimated arrival time of an incoming flight at an airport.
D) look up their checking account balance over the Internet.
E) All of the above

Question 32

In the general division of labor between database applications and the DBMS,the processing of forms is considered a DBMS task.

Question 33

Which of the following would not be an example of database metadata?

A) Names of tables in a database
B) Properties of tables in a database
C) Names of columns in a database and their associated tables
D) Properties of columns
E) Queries against records in the database tables

Question 34

Personal DBMS products,such as Microsoft Access,create a clear distinction between the DBMS and the database application.

Question 35

Today almost every commercial database is based on:

A) lists.
B) the hierarchical model.
C) the linked-list model.
D) the relational model.
E) the object-oriented model.

Question 36

Microsoft Access 2013 databases are stored using the file extension .accdb.

Question 37

In the general division of labor between database applications and the DBMS,the application program determines which tables need to be modified.

Question 38

A relational database stores data in the form of:

A) lists.
B) forms.
C) columns.
D) tables.
E) spreadsheets.

Question 39

Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.

Question 40

Microsoft Access 2013 is a personal database that combines a DBMS with an application generator.

Question 41

Which of the following is not a function of the database application in a database system?

A) Execute application logic
B) Control concurrency
C) Create and process forms
D) Create and transmit queries
E) Create and process reports

Question 42

The DBMS controls ________ by ensuring that one user's work does not inappropriately interfere with another user's work.

Question 43

Microsoft SQL Server is an example of a:

A) database.
B) database management system.
C) data manipulation system.
D) table.
E) list manager.

Question 44

The creation of a database and its tables is a function of which component of the database system?

A) Users
B) Application
C) DBMS
D) Database
E) Web server

Question 45

Microsoft Access is a personal database system,and a personal database system is characterized by:

A) the DBMS removing the metadata from the database.
B) the DBMS product taking the role of the DBMS and the database application generator.
C) the database being stored inside the DBMS.
D) the DBMS product being limited to a maximum of ten tables in any given database.
E) the DBMS not supporting indexes.

Question 46

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:

A) foreign key.
B) primary key.
C) surrogate key.
D) spare key.
E) secondary key.

Question 47

Which of the following is a function of the database application in a database system?

A) Create and transmit queries
B) Update database data
C) Maintain database structures
D) Create tables
E) Backup and restore data

Question 48

In a database system,the ________ creates and processes forms.

Question 49

________ constraints are rules that the DBMS enforces to ensure that data values in one table have corresponding values in another related table.

Question 50

Microsoft Access 2013 database files are stored using the file extension:

A) )adb.
B) )asp.
C) )accdb.
D) )mdb.
E) )sql.

Question 51

The Microsoft Access application generator is not responsible for:

A) creating forms.
B) creating reports.
C) creating queries.
D) creating tables.
E) storing queries.

Question 52

In relational databases,query requests use a language called ________.

Question 53

The purpose of the ________ in a database system is to receive requests from applications and to translate those requests into reads and writes on the database files.

Question 54

The default file format for Microsoft Access 2013 database files is the:

A) Access 2007 format.
B) Access 2003 format.
C) Access XP format.
D) SQL Server format.
E) XBD format.

Question 55

Data that the database keeps about its own structure is called ________.

Question 56

It is almost always best to design a table in a database so that it contains data on ________ theme.

Question 57

The purpose of a database is to help people ________.

Question 58

Which of the following is a function of the DBMS in a database system?

A) Create and transmit queries
B) Control applications
C) Create and process forms
D) Perform backup and recover
E) Process Web page requests

Question 59

A(n)________ is a set of one or more computer programs that serves as an intermediary between the user and the DBMS.

Question 60

A relational database stores data in the form of ________.

Question 61

Microsoft Access 2013 generates surrogate key values when the ________ data type is used.

Question 62

What problems with storing data on two themes in a list are addressed by database technology?

Question 63

What components are included in a database?

Question 64

Microsoft Access is a(n)________,which combines a DBMS and an application generator.

Question 65

What is "metadata," and how does it relate to the definition of a database?

Question 66

Briefly describe the function of an application program in a database system.

Question 67

What are "referential integrity constraints"? Give an example.

Question 68

The Microsoft Access application generator adds the ability to create and store ________,________,and ________.

Question 69

By default,Microsoft Access 2013 saves data files in the ________ file format.

Question 70

What Microsoft Access file format is used by default in Microsoft Access 2013?

Question 71

What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

Question 72

Briefly describe the function of the DBMS in a database system.

Question 73

Microsoft Access 2013 database files are stored using the ________ file extension.

Question 74

Microsoft Access is considered a "personal database" product.What is a personal database?

Question 75

Briefly describe the four components of a database system.

Question 76

What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?