Question 1

The ____ command will create an application program's or individual user's picture of the database.​

Accepted Answer

A)  ​CREATE INDEX 
B)  ​SELECT INDEX 
C)  ​SELECT VIEW 
D)  ​CREATE VIEW 
A)  ​CREATE INDEX 
B)  ​SELECT INDEX 
C)  ​SELECT VIEW 
D)  ​CREATE VIEW D

Question 2

Access supports stored procedures.​

Accepted Answer

A) True 
 B)False  False

Question 3

Referential integrity is specified using the FOREIGN KEY clause in the SELECT command.​

Accepted Answer

A) True 
 B)False  False

Question 4

​To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields,the correct statement is ____.

Accepted Answer

A)  ​PRIMARY KEY (OrderLine, OrderNum, ItemNum) 
B)  ​KEY (OrderNum, ItemNum) 
C)  ​PRIMARY KEY (OrderNum, ItemNum) 
D)  ​PRIMARY (OrderNum, ItemNum) 
A)  ​PRIMARY KEY (OrderLine, OrderNum, ItemNum) 
B)  ​KEY (OrderNum, ItemNum) 
C)  ​PRIMARY KEY (OrderNum, ItemNum) 
D)  ​PRIMARY (OrderNum, ItemNum)

Question 5

A(n)____ is an action that occurs automatically in response to an associated database operation such as an INSERT,UPDATE,or DELETE command.​

Accepted Answer

A)  ​stored procedure 
B)  ​trigger 
C)  ​view 
D)  ​index 
A)  ​stored procedure 
B)  ​trigger 
C)  ​view 
D)  ​index

Question 6

The statement,____,removes the table Smaller from a DBMS.​

Accepted Answer

A)  ​DELETE TABLE Smaller ; 
B)  ​DROP TABLE Smaller ; 
C)  ​REMOVE TABLE Smaller ; 
D)  ​RID TABLE Smaller ; 
A)  ​DELETE TABLE Smaller ; 
B)  ​DROP TABLE Smaller ; 
C)  ​REMOVE TABLE Smaller ; 
D)  ​RID TABLE Smaller ;

Question 7

In Access,a key symbol appears in the row selector of the field that is the ____ key.​

Accepted Answer

A)  ​index 
B)  ​catalog 
C)  ​Foreign 
D)  ​Primary 
A)  ​index 
B)  ​catalog 
C)  ​Foreign 
D)  ​Primary

Question 8

A(n)____ is a computer that is connected to a network and has access through the server to the database.​

Accepted Answer

A)  ​client 
B)  ​view 
C)  ​index 
D)  ​trigger 
A)  ​client 
B)  ​view 
C)  ​index 
D)  ​trigger

Question 9

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.​

Accepted Answer

A)  ​CREATE INDEX RepBal ON Customer (RepNum, Balance) ; 
B)  ​CREATE INDEX RepBal Customer (RepNum DES
C)  ; 
C)  ​CREATE INDEX ON Customer (RepNum, Balance AS
C)  ; 
D)  ​CREATE INDEX RepBal ON Customer (RepNum, Balance DES
C)  ; 
A)  ​CREATE INDEX RepBal ON Customer (RepNum, Balance) ; 
B)  ​CREATE INDEX RepBal Customer (RepNum DES
C)  ; 
C)  ​CREATE INDEX ON Customer (RepNum, Balance AS
C)  ; 
D)  ​CREATE INDEX RepBal ON Customer (RepNum, Balance DES
C)  ;

Question 10

Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.​

Accepted Answer

A)  ​N/A 
B)  ​nil 
C)  ​null 
D)  ​0 
A)  ​N/A 
B)  ​nil 
C)  ​null 
D)  ​0

Question 11

Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.​

Accepted Answer

The answer of Within relational model systems on both mainframes...

Question 12

​To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.

Accepted Answer

A)  ​PRIMARY KEY (CustomerNum) 
B)  ​PRIMARY KEY (Customer, CustomerNum) 
C)  ​KEY (CustomerNum) 
D)  ​PRIMARY (CustomerNum) 
A)  ​PRIMARY KEY (CustomerNum) 
B)  ​PRIMARY KEY (Customer, CustomerNum) 
C)  ​KEY (CustomerNum) 
D)  ​PRIMARY (CustomerNum)

Question 13

When you create an index whose key has a single field,you have created what is called a single-column index.​

Accepted Answer

A) True 
 B)False

Question 14

The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer Jones ;​

Accepted Answer

A) True 
 B)False

Question 15

​In a client/server system,the database resides on a computer called the ____.

Accepted Answer

A)  ​index 
B)  ​documenter 
C)  ​server 
D)  ​client 
A)  ​index 
B)  ​documenter 
C)  ​server 
D)  ​client

Question 16

​What is the difference between entity integrity and referential integrity?

Accepted Answer

Entity integrity is the rule that no fie

Question 17

One advantage of a view is that different users can view the same data in different ways.​

Accepted Answer

A) True 
 B)False

Question 18

The type of field for which you should never allow nulls is the ____________________.​

Accepted Answer

The answer of The type of field for which you...

Question 19

Views cannot be used to examine table data.​

Accepted Answer

A) True 
 B)False

Question 20

The field or combination of fields on which an index is built is called the ____________________ key.​

Accepted Answer

The answer of The field or combination of fields on...

The ____ command will create an application program's or individual user's picture of the database.

Access supports stored procedures.

Referential integrity is specified using the FOREIGN KEY clause in the SELECT command.

To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields,the correct statement is ____.

A(n)____ is an action that occurs automatically in response to an associated database operation such as an INSERT,UPDATE,or DELETE command.

The statement,____,removes the table Smaller from a DBMS.

In Access,a key symbol appears in the row selector of the field that is the ____ key.

A(n)____ is a computer that is connected to a network and has access through the server to the database.

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.

Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.

Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.

To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.

When you create an index whose key has a single field,you have created what is called a single-column index.

The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer Jones ;

In a client/server system,the database resides on a computer called the ____.

What is the difference between entity integrity and referential integrity?

One advantage of a view is that different users can view the same data in different ways.

The type of field for which you should never allow nulls is the ____________________.

Views cannot be used to examine table data.

The field or combination of fields on which an index is built is called the ____________________ key.

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 4: The Relational : Advanced Topics

The ____ command will create an application program's or individual user's picture of the database.​

Access supports stored procedures.​

Referential integrity is specified using the FOREIGN KEY clause in the SELECT command.​

​To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields,the correct statement is ____.

A(n)____ is an action that occurs automatically in response to an associated database operation such as an INSERT,UPDATE,or DELETE command.​

The statement,____,removes the table Smaller from a DBMS.​

In Access,a key symbol appears in the row selector of the field that is the ____ key.​

A(n)____ is a computer that is connected to a network and has access through the server to the database.​

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.​

Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.​

Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.​

​To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.

When you create an index whose key has a single field,you have created what is called a single-column index.​

The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer Jones ;​

​In a client/server system,the database resides on a computer called the ____.

​What is the difference between entity integrity and referential integrity?

One advantage of a view is that different users can view the same data in different ways.​

The type of field for which you should never allow nulls is the ____________________.​

Views cannot be used to examine table data.​

The field or combination of fields on which an index is built is called the ____________________ key.​

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

The ____ command will create an application program's or individual user's picture of the database.

Access supports stored procedures.

Referential integrity is specified using the FOREIGN KEY clause in the SELECT command.

To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields,the correct statement is ____.

A(n)____ is an action that occurs automatically in response to an associated database operation such as an INSERT,UPDATE,or DELETE command.

The statement,____,removes the table Smaller from a DBMS.

In Access,a key symbol appears in the row selector of the field that is the ____ key.

A(n)____ is a computer that is connected to a network and has access through the server to the database.

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.

Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.

Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.

To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.

When you create an index whose key has a single field,you have created what is called a single-column index.

The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer Jones ;

In a client/server system,the database resides on a computer called the ____.

What is the difference between entity integrity and referential integrity?

One advantage of a view is that different users can view the same data in different ways.

The type of field for which you should never allow nulls is the ____________________.

Views cannot be used to examine table data.

The field or combination of fields on which an index is built is called the ____________________ key.