Database Questions

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 Workspace Report Error Discuss

Filed Under: Database

13 8297
Q:

 A goal of data mining includes which of the following?

A) To explain some observed event or condition B) To analyze data for expected relationships
C) To confirm that data exists D) To create a new data warehouse
 
Answer & Explanation Answer: A) To explain some observed event or condition

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

12 7310
Q:

 A DBMS that combines a DBMS and an application generator is ________ .

A) Microsoft's SQL Server B) Microsoft's Access
C) IBM's DB2 D) Oracle Corporation's Oracle
 
Answer & Explanation Answer: B) Microsoft's Access

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

8 4899
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:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

6 3773
Q:

 The different classes of relations created by the technique for preventing modification anomalies are called:

A) normal forms. B) functional dependencies.
C) referential integrity constraints. D) None of the above is correct.
 
Answer & Explanation Answer: A) normal forms.

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

6 2958