CS-403 Final Term Exams Preparation Virtual University With Answers

image
image
image

CS-403 Final Term Exams Preparation Virtual University

Sr. # Questions Answers Choice
1 Which of the following constraints enforces entity integrity? PRIMARY KEY FOREIGN KEY CHECK NOT NULL
2 Which of the following most certainly implies the need for an entire table to implement? A binary relationship A ternary relationship A recursive relationship An identifying relationship
3 Which of the following is true for the relational model? Degree of a relation is the number of rows in a relation Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is unknown Complex key is a key consisting of more than one attribute. Constraint is a rule that restricts the values in a database.
4 Which of the following is NOT a feature of Context DFD? one process (which represents the entire system) all sources/sinks (external entities) data flows linking the process to the sources and sinks (external entities) sub-processes (which explain and decomposed the major process into small processes)
5 Which of the following statements are Data Manipulation Language command? INSERT GRANT TRUNCATE CREATE
6 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 Amali & Hiruni to retrieve data from Employee table Grant permission to Hiruni in order to grant, select and update permission to Amali. Grant permission to Amali and Hiruni to update all data except designation in Employee table
7 Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example o Physical data independence Concurrency control. Logical data independence. Functional dependency
8 Identify the advantage of DELETE command over TRUNCATE. Can be Rolled back is DDL Command. cannot activate a trigger. faster and uses fewer system
9 Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI? SELECT * FROM CUST WHERE last_name='ALI'; SELECT * FROM CUST WHERE last_name=ALI; SELECT * FROM CUSTOMER WHERE name=ALI; SELECT * FROM CUSTOMER WHERE last_name=ALI;
10 Which of the following concept is applicable with respect to 2NF? Non-transitive dependency Full functional dependency Partial dependency Transitive dependency
Download This Set
×