Question 1

To change the field names in a view include the AS clause in the CREATE VIEW command.

Accepted Answer

A) True 
 B)False

Question 2

Within an organization,the ____________________ determines the types of access various users can have to the database.

Accepted Answer

database a

Question 3

In Access 2010,you can gain the same functionality as triggers by creating a(n) ____________________.

Accepted Answer

The answer of In Access 2010,you can gain the same...

Question 4

The SELECT command that creates the view,which is called the view query,indicates what to include in the view.

Accepted Answer

A) True 
 B)False

Question 5

Views cannot be used to examine table data.

Accepted Answer

A) True 
 B)False

Question 6

To create a view in Access,you simply create and then save a query.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) DELETE TABLE LargeCust ; 
B) DROP TABLE LargeCust ; 
C) REMOVE TABLE LargeCust ; 
D) RID TABLE LargeCust ; 
A) DELETE TABLE LargeCust ; 
B) DROP TABLE LargeCust ; 
C) REMOVE TABLE LargeCust ; 
D) RID TABLE LargeCust ;

Question 8

The command DELETE INDEX CustList; would remove the index named CustList.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Discuss what you can do if you need to change a table's structure in ways that are beyond the capabilities of your DBMS.

Accepted Answer

In some cases,you might need to change a

Question 11

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

Accepted Answer

A) CREATE SNAPSHOT 
B) SELECT SNAPSHOT 
C) SELECT VIEW 
D) CREATE VIEW 
A) CREATE SNAPSHOT 
B) SELECT SNAPSHOT 
C) SELECT VIEW 
D) CREATE VIEW

Question 12

Access has a tool called the ____________________,which allows you to easily print detailed documentation concerning any table,query,report,form,or other object in the database.

Accepted Answer

The answer of Access has a tool called the ____________________,which...

Question 13

In SQL,you specify referential integrity using a(n) ____________________ clause in either the CREATE TABLE or ALTER TABLE commands.

Accepted Answer

FOREIGN KE

Question 14

If you anticipate running a particular query often,you can improve overall performance by saving the query in a special file called a(n) ____.

Accepted Answer

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

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) PRIMARY KEY (Orders,OrderNum,PartNum) 
B) KEY (OrderNum,PartNum) 
C) PRIMARY KEY (OrderNum,PartNum) 
D) PRIMARY (OrderNum,PartNum) 
A) PRIMARY KEY (Orders,OrderNum,PartNum) 
B) KEY (OrderNum,PartNum) 
C) PRIMARY KEY (OrderNum,PartNum) 
D) PRIMARY (OrderNum,PartNum)

Question 18

____________________ is the prevention of unauthorized access to the database.

Accepted Answer

The answer of ____________________ is the prevention of unauthorized access...

Question 19

Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values.

Accepted Answer

A) True 
 B)False

Question 20

The following command will revoke the ability to retrieve Customer records from user Jones:
REVOKE GRANT ON Customer FROM Jones ;

Accepted Answer

A) True 
 B)False

To change the field names in a view include the AS clause in the CREATE VIEW command.

Within an organization,the ____________________ determines the types of access various users can have to the database.

In Access 2010,you can gain the same functionality as triggers by creating a(n) ____________________.

The SELECT command that creates the view,which is called the view query,indicates what to include in the view.

Views cannot be used to examine table data.

To create a view in Access,you simply create and then save a query.

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

The command DELETE INDEX CustList; would remove the index named CustList.

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

Discuss what you can do if you need to change a table's structure in ways that are beyond the capabilities of your DBMS.

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

Access has a tool called the ____________________,which allows you to easily print detailed documentation concerning any table,query,report,form,or other object in the database.

In SQL,you specify referential integrity using a(n) ____________________ clause in either the CREATE TABLE or ALTER TABLE commands.

If you anticipate running a particular query often,you can improve overall performance by saving the query in a special file called a(n) ____.

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

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

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

____________________ is the prevention of unauthorized access to the database.

Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values.

The following command will revoke the ability to retrieve Customer records from user Jones: REVOKE GRANT ON Customer FROM Jones ;

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 4: The Relational Model 3: Advanced Topics

To change the field names in a view include the AS clause in the CREATE VIEW command.

Within an organization,the ____________________ determines the types of access various users can have to the database.

In Access 2010,you can gain the same functionality as triggers by creating a(n) ____________________.

The SELECT command that creates the view,which is called the view query,indicates what to include in the view.

Views cannot be used to examine table data.

To create a view in Access,you simply create and then save a query.

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

The command DELETE INDEX CustList; would remove the index named CustList.

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

Discuss what you can do if you need to change a table's structure in ways that are beyond the capabilities of your DBMS.

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

Access has a tool called the ____________________,which allows you to easily print detailed documentation concerning any table,query,report,form,or other object in the database.

In SQL,you specify referential integrity using a(n) ____________________ clause in either the CREATE TABLE or ALTER TABLE commands.

If you anticipate running a particular query often,you can improve overall performance by saving the query in a special file called a(n) ____.

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

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

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

____________________ is the prevention of unauthorized access to the database.

Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values.

The following command will revoke the ability to retrieve Customer records from user Jones: REVOKE GRANT ON Customer FROM Jones ;

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters