Searching for "he"

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:

 When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

A) LIKE only. B) IN only.
C) NOT IN only. D) Both IN and NOT IN.
 
Answer & Explanation Answer: D) Both IN and NOT IN.

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:

 The HAVING clause does which of the following?

A) Acts like a WHERE clause but is used for groups rather than rows. B) Acts like a WHERE clause but is used for rows rather than columns.
C) Acts like a WHERE clause but is used for columns rather than groups. D) Acts EXACTLY like a WHERE clause.
 
Answer & Explanation Answer: A) Acts like a WHERE clause but is used for groups rather than rows.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database