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 
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 ; 
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) 
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 
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)) 
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 
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

A) True 
 B)False

Which command will create an application program's or individual user's picture of the database?

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

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

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

Which statement will take away user privileges to the database?

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

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

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

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

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

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

Which command will create an application program's or individual user's picture of the database?

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

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

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

Which statement will take away user privileges to the database?

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

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

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

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

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

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