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

Filed Under: Database

43 22297
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.


 


What_is_the_cause_of_thrashing_How_does_the_system_detect_thrashing_Once_it_detects_thrashing,_what_can_the_system_do_to_eliminate_this_problem1557490890.jpg image

Report Error

View answer Workspace Report Error Discuss

31 23293
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

25 17114
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 Report Error Discuss

Filed Under: Database

24 18276
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 Report Error Discuss

Filed Under: Database

23 15822
Q:

________ is an open source DBMS product that runs on UNIX, Linux and Windows.

A) MySQL B) JSP/SQL
C) JDBC/SQL D) Sun ACCESS
 
Answer & Explanation Answer: A) MySQL

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

21 12348
Q:

What is page cannibalizing?

Answer

Page swapping or page replacements are called page cannibalizing.

Report Error

View answer Workspace Report Error Discuss

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

20 8258