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

11 4710
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

11 3975
Q:

What is page cannibalizing?

Answer

Page swapping or page replacements are called page cannibalizing.

Report Error

View answer Workspace Report Error Discuss

13 3570
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

5 3215
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

5 2643