Question 1

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 2

In Access,a(n)____________________ enables you to add logic to table events such as adding,changing,or deleting data​

Accepted Answer

The answer of In Access,a(n)____________________ enables you to add logic...

Question 3

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 4

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 5

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 6

____________________ is the prevention of unauthorized access to the database.​

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

database a

Question 10

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 11

One advantage of using views is that they provide data dependence.​

Accepted Answer

A) True 
 B)False

Question 12

A(n)____________________ index is an index with more than one key field.​

Accepted Answer

multiple-field
multi

Question 13

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 14

To insert a new field in a table,the ____ 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 15

The CHECK clause can be included in the ____ command.​

Accepted Answer

A)  SELECT TABLE​ 
B)  ​ALTER TABLE 
C)  ​DROP TABLE 
D)  ​DELETE TABLE 
A)  SELECT TABLE​ 
B)  ​ALTER TABLE 
C)  ​DROP TABLE 
D)  ​DELETE TABLE

Question 16

In a client/server system,users access the database through ____.​

Accepted Answer

A)  ​triggers 
B)  ​documenters 
C)  ​servers 
D)  ​clients 
A)  ​triggers 
B)  ​documenters 
C)  ​servers 
D)  ​clients

Question 17

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 given

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The SQL command for deleting the Storehouse field from the Item table is ____.​

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 20

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

Accepted Answer

This practice has two advantages.First,b

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.

In Access,a(n)____________________ enables you to add logic to table events such as adding,changing,or deleting data

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 a system catalog,the ____________________ table contains information about the tables known to SQL.

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

____________________ is the prevention of unauthorized access to the database.

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

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

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

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

One advantage of using views is that they provide data dependence.

A(n)____________________ index is an index with more than one key field.

A trigger is stored and compiled on the ____.

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

The CHECK clause can be included in the ____ command.

In a client/server system,users access the database through ____.

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

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

The SQL command for deleting the Storehouse field from the Item table is ____.

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

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 4: The Relational : Advanced Topics

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.​

In Access,a(n)____________________ enables you to add logic to table events such as adding,changing,or deleting data​

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 a system catalog,the ____________________ table contains information about the tables known to SQL.​

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

____________________ is the prevention of unauthorized access to the database.​

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

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

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

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

One advantage of using views is that they provide data dependence.​

A(n)____________________ index is an index with more than one key field.​

A trigger is stored and compiled on the ____.​

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

The CHECK clause can be included in the ____ command.​

In a client/server system,users access the database through ____.​

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

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

The SQL command for deleting the Storehouse field from the Item table is ____.​

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

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

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.

In Access,a(n)____________________ enables you to add logic to table events such as adding,changing,or deleting data

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 a system catalog,the ____________________ table contains information about the tables known to SQL.

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

____________________ is the prevention of unauthorized access to the database.

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

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

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

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

One advantage of using views is that they provide data dependence.

A(n)____________________ index is an index with more than one key field.

A trigger is stored and compiled on the ____.

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

The CHECK clause can be included in the ____ command.

In a client/server system,users access the database through ____.

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

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

The SQL command for deleting the Storehouse field from the Item table is ____.

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