VU CS-403 Online Test Preparation

CS-403 Final Term Exams Preparation Virtual University

Sr. #	Questions	Answers Choice
1	Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?	the number of columns in the first table multiplied by the number of columns in the second table. the number of columns in the first table multiplied by the number of rows in the second table the number of rows in the first table multiplied by the number of columns in the first table the number of rows in the first table multiplied by the number of rows in the second table
2	Which of the following is true about TRUNCATE?	Can be Rolled back. Activates Triggers is DML Command. Resets identity of the table
3	Which of the following statements is true about the views?	view is always a complete set of all the tables in a database View can not be used for retrieving data The results of using a view are not permanently stored in the database. Rows can not be updated or deleted in the view
4	Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?	User accessible catalog Data processing Authorization service Recovery service