Page 191 - IT-802_class_12
P. 191
23 (a) Improved security (b) User friendly
(c) Reduced redundancy (d) Security and recovery overheads
Ans. (d) Security and recovery overheads
24. Consider a table Employee with fields Empid, Empname, DOB, DOJ, Salary, Designation and Phone, num. Every record must
have a non-repeated Empid. Identify the appropriate key that must be applied while creating the table. [2022]
(a) Default (b) Null
(c) Primary Key (d) Domain
Ans. (c) Primary Key
25. Consider a table Student with attributes AdmnNo. Rno. Sname, Class and Marks. The column AdmnNo is the Primary key.
Every student has a Identify set of attributes that cannot be a superkey in table Student: [2022]
(a) (AdmNo. Sname) (b) (AdmNo. Class, Marks)
(c) (Class Marks) (d) (AdmnNo. Marks)
Ans. (c) (Class Marks)
26. Consider the table Supplier: [2022]
S.D. Supp_name City Phoneno Company Status
S101 Jitesh Jaipur 9812131415 Jain & Co. Delivered
S102 Rohit Jodhpur 6958686868 Jumbo Electricals Pending
S103 Ramesh Bikaner 9565859565 J & K Collabs Delivered
S109 Rankat Jaipur 6598102030 Felian Company Delivered
S201 Dilshad Agra 6510205030 Reliant Transient Pending
S223 Jitesh Lucknow 6510204548 J & K Collabs Pending
Select the appropriate set of candidate keys:
(a) S_ID, Supp_name, Company (b) Supp_name, City, Phoneno
(c) S_ID, Supp_name, Phoneno (d) S-ID, Phoneno
Ans. (d) S-ID, Phoneno
27. Parinity wants to remove all the records from table “Customer” with fields(Cust_ID,C_name, Amount, Dues, Address) whose
dues status is ‘Clear’. Select the query that will solve the purpose: [2022]
(a) Delete from Customer where dues=’Clear’; (b) Remove from Customer where dues=’Clear’;
(c) Drop Customer where dues=’Clear’; (d) Delete from Customer where dues=’Clear’;
Ans. (d) Delete from Customer where dues=’Clear’;
28. Jagriti wants to display the list of all the students in relation ‘Student’ with fields (Admno, Name, DOB, DOJ, City, Class,
FatherName, MotherName) whose city name ends with letter ‘d’ in decending order of Admno. Identify the correct query
to do the same from the following: [2022]
(a) Select from Student where City like ‘%d’ order by Admno;
(b) Select from Student where City like “%d’ order by Admno.
(c) Select *from Student where City like ‘%d’ order by Admno desc;
(d) Select *from Student where City like ‘%d’ order by Admno desc.
Ans. (c) Select *from Student where City like ‘%d’ order by Admno desc;
29. Which of the following is incorrect with respect to the foreign key? [2022]
(a) Foreign key in one table is primary key of another table.
(b) Foreign key of a table must have same name as the associated primary key.
(c) A foreign key can have a NULL value.
(d) A foreign key can have duplicate value
Ans. (b) Foreign key of a table must have same name as the associated primary key.
Database Concepts—RDBMS Tool 189

