Question 1

Which 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

Question 2

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

Accepted Answer

The answer of In SQL, you can use the _______________...

Question 3

Which SQL command should you use to delete the Storehouse field from the Item table?

Accepted Answer

A)  ALTER TABLE Item DELETE Storehouse ; 
B)  ALTER TABLE Item DROP COLUMN Storehouse ; 
C)  ALTER Item DELETE Storehouse ; 
D)  ALTER TABLE DELETE Storehouse ;

Question 4

To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields, which statement should you use?

Accepted Answer

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

Question 5

Which statement will take away user privileges to the database?

Accepted Answer

A)  SELECT 
B)  INDEX 
C)  DEL 
D)  REVOKE

Question 6

Information about tables in the database is kept in the system catalog.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statement fragments will only allow a CreditLimit of $5,000, $7,500, or $15,000?

Accepted Answer

A)  (CreditLimit IN (5000, 7500, 15000)) 
B)  CHECK ((5000, 7500, 15000)) 
C)  CHECK (CreditLimit LIKE (5000, 7500, 15000)) 
D)  CHECK (CreditLimit IN (5000, 7500, 15000))

Question 8

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 9

What feature is available in Access 2016 that offers the functionality of a trigger?

Accepted Answer

A)  data macro 
B)  system catalog 
C)  index 
D)  view

Question 10

Stored procedures do not accept parameters, and must be queried in a manner similar to tables.

Accepted Answer