Technical 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

19 13988
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

16 12196
Q:

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

A) First normal form B) Second normal form
C) Third normal form D) Fourth normal form
 
Answer & Explanation Answer: B) Second normal form

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

6 10444
Q:

 For what purposes are views used?

A) To hide rows only B) To hide columns only
C) To hide complicated SQL statements only D) All of the above are uses for SQL views.
 
Answer & Explanation Answer: D) All of the above are uses for SQL views.

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

4 10231
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

14 10157
Q:

Explain Belady's Anomaly?

Answer

Also called FIFO anomaly. Usually, on increasing the number of frames allocated to a process virtual memory, the process execution is faster, because fewer page faults occur. Sometimes, the reverse happens, i.e., the execution time increases even when more frames are allocated to the process. This is Belady's Anomaly. This is true for certain page reference patterns.

Report Error

View answer Workspace Report Error Discuss

12 9750
Q:

What is page cannibalizing?

Answer

Page swapping or page replacements are called page cannibalizing.

Report Error

View answer Workspace Report Error Discuss

17 7643
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

9 6600