Database Questions

Q:

A ternary relationship involves how many entities?

A) 3 or less B) 3
C) More than 3 D) 3 or more
 
Answer & Explanation Answer: B) 3

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5485
Q:

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A) Minimum cardinality B) Maximum cardinality
C) ERD D) Greater Entity Count (GEC)
 
Answer & Explanation Answer: B) Maximum cardinality

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 5307
Q:

 In the relational model, relationships between relations or tables are created by using:

A) composite keys. B) determinants.
C) candidate keys. D) foreign keys.
 
Answer & Explanation Answer: D) foreign keys.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 5261
Q:

SQL Server program code that is executed instead of an SQL command that needs to be processed is called

A) INSTEAD OF trigger. B) BEFORE trigger.
C) AFTER trigger. D) BEGIN trigger.
 
Answer & Explanation Answer: A) INSTEAD OF trigger.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5163
Q:

 If a table has been normalized so that all determinants are candidate keys, then that table is in:

A) 1NF B) 2NF
C) 3NF D) BCNF
 
Answer & Explanation Answer: D) BCNF

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 5118
Q:

A collection of interrelated records is called a

A) Datasheet B) Spreadsheet
C) Database D) Utility File
 
Answer & Explanation Answer: C) Database

Explanation:
Report Error

View Answer Report Error Discuss

5 5045
Q:

 Legacy data is which of the following?

A) Data contained in a newly-installed system B) Data rejected during the installation of a new system
C) Data contained in a file system D) Data contained by a system used prior to the installation of a new system
 
Answer & Explanation Answer: D) Data contained by a system used prior to the installation of a new system

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 5041
Q:

 A proxy server is used for which of the following?

A) To provide security against unauthorized users B) To process client requests for Web pages
C) To process client requests for database access D) To provide TCP/IP
 
Answer & Explanation Answer: A) To provide security against unauthorized users

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

5 5002