Question 1

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

Accepted Answer

The answer of Microsoft Access 2013 generates surrogate key values...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

A database may be used to help people:

Accepted Answer

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 
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 4

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.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of The DBMS controls ________ by ensuring that...

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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.

Accepted Answer

The answer of The purpose of the ________ in a...

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

Metadata is data about the structure of

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The purpose of a database is to help people ________.

Accepted Answer

keep track

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

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

A database may be used to help people:

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.

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

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.

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

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.

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

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

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

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

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

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

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

The purpose of a database is to help people ________.

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 1: Getting Started

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

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

A database may be used to help people:

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.

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

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.

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

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.

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

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

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

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

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

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

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

The purpose of a database is to help people ________.

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters