CS-403 Final Term Exams Preparation Virtual University With Answers

CS-403 Final Term Exams Preparation Virtual University

Sr. # Questions Answers Choice
1 Which of the following is an example of volatile memory? RAM ROM Flash memory CPU
2 Which of the following is not true about input forms? Provide an easy, effective, efficient way to enter data into a table Especially useful when the person entering the data is not familiar with the inner workings Provide different controls to add data into the tables One input forms can populate one table at a time
3 Consider a transaction which includes following operations Z= Z + 10 Write Z ... Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be What does Z reflects in the above entry? Object being updated Identity of the transaction Object value Identity of the next transaction to be executed
4 Which of the following statements creates a database named COMPANY. CREATE DATABASE company CREATE DB company ADD DATABASE copmany CREATE company DATABASE
5 Which of the following is one of the purposes of using DDL commands? inserting records into databases updating records into databases manipulating databases creating and destroying databases
6 Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies. FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo FD3 : StaffNo, InterviewDate -> RoomNo Which of the following is correct? The relation Interview is in 3NF The relation Interview is in BCNF The FD3 violates 3NF. The FD2 violates 2NF.
7 Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 columns in TABLE2; what is the size of the Cartesian product incase of CROSS JOIN between these two tables? 24 54 6 1
8 Which of the following statements are Data Definition Language command? INSERT UPDATE GRANT TRUNCATE
9 Which of the following is NOT one of the ways of resolving deadlocks? Undoing all the updates made by the particular transaction which is the cause of deadlock. A message is passed to the victim and depending on the system the transaction may or may not be started again automatically Picking a list of all previously completed transactions and undoing all the updates. Rollback `victim' transaction and restart it
10 A ____ relationship exists when an association is maintained within a single entity. unary ternary binary weak
Download This Set

Is this page helpful?