Question 1

To insert a new field in a table, which keyword should be used with the ALTER TABLE command?

Accepted Answer

A)  INSERT 
B)  ADD 
C)  INCLUDE 
D)  ALTER 
A)  INSERT 
B)  ADD 
C)  INCLUDE 
D)  ALTER

Question 2

To create the primary key clause for the Customer table on the CustomerNum field, which statement should you use?

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 3

What value can you set a field to that 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 4

Indexes can increase the efficiency with which data is retrieved from the database.

Accepted Answer

A) True 
 B)False

Question 5

What is the difference between entity integrity and referential integrity?

Accepted Answer

Entity integrity is the rule that no fie

Question 6

You can change the structure of a table using the CREATE VIEW command.

Accepted Answer

A) True 
 B)False

Question 7

In SQL, you use the VERIFY clause to enforce legal-values integrity.

Accepted Answer

A) True 
 B)False

Question 8

A trigger is stored and compiled on the client computer.

Accepted Answer

A) True 
 B)False

Question 9

Using Access, which command will create a new table named NewClients from an existing table named Clients?

Accepted Answer

A)  CREATE NewClients FROM Clients; 
B)  SELECT * FROM Clients CREATE NewClients; 
C)  SELECT * INTO NewClients FROM Clients; 
D)  SELECT * MAKE NewClients FROM Clients; 
A)  CREATE NewClients FROM Clients; 
B)  SELECT * FROM Clients CREATE NewClients; 
C)  SELECT * INTO NewClients FROM Clients; 
D)  SELECT * MAKE NewClients FROM Clients;

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Discuss validation rules and validation text.

Accepted Answer

In Access, you can restrict the legal va

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

One disadvantage of using views is that they are data dependent so that if the database structure changes in any way, the view can no longer be used.

Accepted Answer

A) True 
 B)False

Question 15

Explain what is meant by a null value. Is a null value the same as a value of zero?

Accepted Answer

Essentially, setting the value in a give

Question 16

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order, which command should you use?

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 17

Describe a client/server system and how it applies to stored procedures.

Accepted Answer

In a client/server system, the database

Question 18

What database rule states that no field that is part of the primary key may accept null values?

Accepted Answer

A)  legal-values integrity 
B)  structural integrity 
C)  referential integrity 
D)  entity integrity 
A)  legal-values integrity 
B)  structural integrity 
C)  referential integrity 
D)  entity integrity

Question 19

Which of the following is a disadvantage of using an index?

Accepted Answer

A)  You can only add an index when the table is created. 
B)  You can't use indexes with foreign keys. 
C)  Record retrieval is less efficient. 
D)  The index must be updated whenever the data in the database changes. 
A)  You can only add an index when the table is created. 
B)  You can't use indexes with foreign keys. 
C)  Record retrieval is less efficient. 
D)  The index must be updated whenever the data in the database changes.

Question 20

What SQL feature can you use if you want to create a view that combines data from more than one table?

Accepted Answer

A)  a join 
B)  a trigger 
C)  an index 
D)  a catalog 
A)  a join 
B)  a trigger 
C)  an index 
D)  a catalog

To insert a new field in a table, which keyword should be used with the ALTER TABLE command?

To create the primary key clause for the Customer table on the CustomerNum field, which statement should you use?

What value can you set a field to that is similar to not entering a value in it at all?

Indexes can increase the efficiency with which data is retrieved from the database.

What is the difference between entity integrity and referential integrity?

You can change the structure of a table using the CREATE VIEW command.

In SQL, you use the VERIFY clause to enforce legal-values integrity.

A trigger is stored and compiled on the client computer.

Using Access, which command will create a new table named NewClients from an existing table named Clients?

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

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

Discuss validation rules and validation text.

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

One disadvantage of using views is that they are data dependent so that if the database structure changes in any way, the view can no longer be used.

Explain what is meant by a null value. Is a null value the same as a value of zero?

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order, which command should you use?

Describe a client/server system and how it applies to stored procedures.

What database rule states that no field that is part of the primary key may accept null values?

Which of the following is a disadvantage of using an index?

What SQL feature can you use if you want to create a view that combines data from more than one table?

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 insert a new field in a table, which keyword should be used with the ALTER TABLE command?

To create the primary key clause for the Customer table on the CustomerNum field, which statement should you use?

What value can you set a field to that is similar to not entering a value in it at all?

Indexes can increase the efficiency with which data is retrieved from the database.

What is the difference between entity integrity and referential integrity?

You can change the structure of a table using the CREATE VIEW command.

In SQL, you use the VERIFY clause to enforce legal-values integrity.

A trigger is stored and compiled on the client computer.

Using Access, which command will create a new table named NewClients from an existing table named Clients?

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

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

Discuss validation rules and validation text.

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

One disadvantage of using views is that they are data dependent so that if the database structure changes in any way, the view can no longer be used.

Explain what is meant by a null value. Is a null value the same as a value of zero?

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order, which command should you use?

Describe a client/server system and how it applies to stored procedures.

What database rule states that no field that is part of the primary key may accept null values?

Which of the following is a disadvantage of using an index?

What SQL feature can you use if you want to create a view that combines data from more than one table?

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