Searching for "at"

Q:

 To drop a column that is used as a foreign key, first:

A) drop the primary key. B) drop the table containing the foreign key..
C) drop the foreign key constraint. D) All of the above must be done.
 
Answer & Explanation Answer: C) drop the foreign key constraint.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The process of reading a database schema and producing a data model from that schema is known as:

A) data modeling. B) database design.
C) reverse engineering. D) None of the above is correct.
 
Answer & Explanation Answer: C) reverse engineering.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 In a 1:N relationship, the foreign key is placed in:

A) the parent table. B) the child table.
C) either table without specifying parent and child tables. D) either the parent table or the child table.
 
Answer & Explanation Answer: B) the child table.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

A) Two B) Three
C) Four D) Six
 
Answer & Explanation Answer: D) Six

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

A) first step. B) second step.
C) third step. D) fourth step.
 
Answer & Explanation Answer: C) third step.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

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

Q:

 To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

A) ONLY B) DISTINCT
C) UNIQUE D) SINGLE
 
Answer & Explanation Answer: B) DISTINCT

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 ON UPDATE CASCADE ensures which of the following?

A) Normalization B) Data Integrity
C) Materialized Views D) All of the above.
 
Answer & Explanation Answer: B) Data Integrity

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database