B Search

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

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

Q:

Which of the following is the original purpose of SQL?

A) To specify the syntax and semantics of SQL data definition language	B) To specify the syntax and semantics of SQL manipulation language
C) To define the data structures	D) All of the above.

Answer & Explanation Answer: D) All of the above.

Explanation:

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

Searching for "B"

Quick Links