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

33 20009
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

22 15136
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

22 16451
Q:

What is page cannibalizing?

Answer

Page swapping or page replacements are called page cannibalizing.

Report Error

View answer Workspace Report Error Discuss

20 10613
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

20 14500
Q:

What are the disadvantages of context switching?

Answer

Time taken for switching from one process to other is pure over head. Because the system does no useful work while switching. So one of the solutions is to go for threading when ever possible.

Report Error

View answer Workspace Report Error Discuss

18 6897
Q:

What is the cause of thrashing? How does the system detect thrashing? Once it detects thrashing, what can the system do to eliminate this problem?

Answer

Thrashing is caused by under allocation of the minimum number of pages required by a process, forcing it to continuously page fault. The system can detect thrashing by evaluating the level of CPU utilization as compared to the level of multiprogramming. It can be eliminated by reducing the level of multiprogramming.

Report Error

View answer Workspace Report Error Discuss

18 15211
Q:

What are the stipulations of C2 level security?

Answer

C2 level security provides for:


 


1.Discretionary Access Control


2.Identification and Authentication


3.Auditing


4.Resource reuse

Report Error

View answer Workspace Report Error Discuss

16 5788