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 enforces a relation into 1st normal form? The domain of attribute must include only atomic values. Every non-key attribute is fully functionally dependent on primary key non-key attribute is non-transitively dependent on primary key. Every non-key attribute is partially dependent on super key
2 Suppose there are 4 fields in a table named WORKER (Id, first_name, last_name, joining_year). Which of the following gives all the information of the workers who have joined after 1965? SELECT * FROM WORKER WHERE joining_Year>1965; SELECT * FROM WORKER WHERE joining_Year>'1965'; SELECT * FROM WORKER AND joining_Year>'1965'; SELECT * WHERE joining_Year>1965;
3 Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables? 24 32 12 16
4 Identify the constraint that limits the values that can be placed in a column. NOT NULL CHECK FOREIGN KEY UNIQUE
5 Which of the following SQL keywords is not used with DDL statements? Table Update Create Alter
6 A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. strong weak business relationship
7 A super key that does not contain a subset of attributes that is itself a super key is called a ____. candidate key primary key superkey secondary key
8 Who is responsible for authorizing access to the database, for coordinating and monitoring its use ? Database Designers Database Administrators End Users Application Programmers
9 Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order By CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where REGION = 'E' Order By CUSTOMER The above statement Has an error - the string should be in double quotes Has an error - ORDER BY clause. Does not have an error. Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
10 Which of the following is Advantage of Re-Hashing technique to handle the collisions? Collisions don’t use primary table space Unlimited number of elements Fast access through use of main table space Overhead of multiple linked lists
Download This Set
×