VU CS-403 Online Test Preparation

CS-403 Final Term Exams Preparation Virtual University

Sr. #	Questions	Answers Choice
1	Which of the following is not a feature of TRANSACTION?	Users should be able to regard the execution of each transaction as atomic Each transaction, run by itself must preserve the consistency of the database dependant on other concurrent transactions
2	Which of the following will be deleted relating to a table if you use TRUNCATE command?	all rows in a table indexes table structure and its columns constraints
3	Which of the following is true about DELETE command?	is DDL Command Resets identity of the table cannot activate a trigger Can be Rolled back
4	How many clustered index(es) do each database table have?	2 3 4 1
5	Which of the following statements are Data Definition Language command?	INSERT UPDATE GRANT TRUNCATE
6	Which key word is available in SQL to enforce referential integrity?	Check Primary Key Set Default Unique
7	GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?	Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table. Grant permission to Hiruni in order to grant, select and update permission to Amali. Grant permission to Amali & Hiruni to update designation of employees in the Employee table Grant permission to Amali and Hiruni to update all data except designation in Employee table
8	Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of	Physical data independence. Concurrency control Logical data independence. Functional dependency
9	Which of the following is NOT a feature of a good interface?	Consistency Process based Data structure based User friendly
10	Which of the following concepts is applicable with respect to 3NF?	Full functional dependency Any kind of dependency Transitive dependency Partial functional dependency

Download This Set