Question 1

In MySQL,you use the _____ command to produce a list of tables.

Accepted Answer

A) SYSTABLES 
B) SYSTEM TABLES 
C) SHOW TABLES 
D) CATALOG TABLES 
A) SYSTABLES 
B) SYSTEM TABLES 
C) SHOW TABLES 
D) CATALOG TABLES C

Question 2

Once you add an index to a database,you cannot delete it.

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

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

Question 4

The SQL command for deleting the Warehouse field from the Part table is ____.

Accepted Answer

A) ALTER TABLE Part DROP COLUMN Warehouse ; 
B) ALTER Part DROP Warehouse ; 
C) ALTER Part DELETE Warehouse ; 
D) ALTER TABLE DELETE Warehouse ; 
A) ALTER TABLE Part DROP COLUMN Warehouse ; 
B) ALTER Part DROP Warehouse ; 
C) ALTER Part DELETE Warehouse ; 
D) ALTER TABLE DELETE Warehouse ;

Question 5

Access 2010 supports data macros.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A stored procedure is placed on a client computer.

Accepted Answer

A) True 
 B)False

Question 9

What is the difference between entity integrity and referential integrity?

Accepted Answer

Entity integrity is the rule that no fie

Question 10

In SQL,you use the CHECK clause to enforce ____ integrity.

Accepted Answer

A) referential 
B) legal-values 
C) entity 
D) catalog 
A) referential 
B) legal-values 
C) entity 
D) catalog

Question 11

Under which conditions should you create an index on a field (or combination of fields)?

Accepted Answer

You should create an index on a field (o

Question 12

To create an index for the Customer table 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 13

The ____ 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 14

To use a stored procedure in MySQL,a user enters the word _____ followed by the procedure name.

Accepted Answer

A) USE 
B) DO 
C) RUN 
D) CALL 
A) USE 
B) DO 
C) RUN 
D) CALL

Question 15

A trigger is stored and compiled on the ____.

Accepted Answer

A) client 
B) Web 
C) index 
D) server 
A) client 
B) Web 
C) index 
D) server

Question 16

An individual can use a view to create reports,charts,and other objects that show database data.

Accepted Answer

A) True 
 B)False

Question 17

What are the advantages of having views only contain the fields required by a given user?

Accepted Answer

This practice has two advantages. First,

Question 18

In a system catalog,the ____________________ table contains information about the tables known to SQL.

Accepted Answer

The answer of In a system catalog,the ____________________ table contains...

Question 19

The semicolon at the end of a MySQL command is called a(n) ____________________.

Accepted Answer

The answer of The semicolon at the end of a...

Question 20

The SQL command used to delete an index that is no longer necessary is ____________________.

Accepted Answer

The answer of The SQL command used to delete an...

In MySQL,you use the _____ command to produce a list of tables.

Once you add an index to a database,you cannot delete it.

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

The SQL command for deleting the Warehouse field from the Part table is ____.

Access 2010 supports data macros.

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

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

A stored procedure is placed on a client computer.

What is the difference between entity integrity and referential integrity?

In SQL,you use the CHECK clause to enforce ____ integrity.

Under which conditions should you create an index on a field (or combination of fields)?

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

The ____ statement will take away user privileges to the database.

To use a stored procedure in MySQL,a user enters the word _____ followed by the procedure name.

A trigger is stored and compiled on the ____.

An individual can use a view to create reports,charts,and other objects that show database data.

What are the advantages of having views only contain the fields required by a given user?

In a system catalog,the ____________________ table contains information about the tables known to SQL.

The semicolon at the end of a MySQL command is called a(n) ____________________.

The SQL command used to delete an index that is no longer necessary is ____________________.

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

In MySQL,you use the _____ command to produce a list of tables.

Once you add an index to a database,you cannot delete it.

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

The SQL command for deleting the Warehouse field from the Part table is ____.

Access 2010 supports data macros.

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

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

A stored procedure is placed on a client computer.

What is the difference between entity integrity and referential integrity?

In SQL,you use the CHECK clause to enforce ____ integrity.

Under which conditions should you create an index on a field (or combination of fields)?

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

The ____ statement will take away user privileges to the database.

To use a stored procedure in MySQL,a user enters the word _____ followed by the procedure name.

A trigger is stored and compiled on the ____.

An individual can use a view to create reports,charts,and other objects that show database data.

What are the advantages of having views only contain the fields required by a given user?

In a system catalog,the ____________________ table contains information about the tables known to SQL.

The semicolon at the end of a MySQL command is called a(n) ____________________.

The SQL command used to delete an index that is no longer necessary is ____________________.

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