Database Management System and Design MCQ Test 02 Online for Preparation Shani Malik — December 11, 2017 in Computer Science Test • add comment Database Management System and Design MCQ Test 02 Online for Preparation 1. Which of the following fields in a student file can be used as a primary key ?A. Social Security Number B. class C. MajorD. GPA Loading... 2. A transparent DBMS ?A. can not hide sensitive information from users B. keeps its logical structure hidden from users C. both b and c D. keeps its physical structure hidden from users Loading... 3. In the DBMS approach, application programs perform the ?A. processing functions B. all of the aboveC. storage function D. access control Loading... 4. A record management system ?A. always uses a list as its model B. can be used to extract information stored in a computer file C. both a and b D. can handle many files of information at a time Loading... 5. Which of the following is not an advantage of the database approach ?A. program/data independence B. Elimination of data redundancy C. all of the aboveD. Ability of associate deleted data Loading... 6. Which is the make given to the database management system which is able to handle full text data, image data, audio and video ?A. graphics media B. hypertext C. full media D. multimedia Loading... 7. A file produced by a spreadsheet ?A. both a and b B. none of the aboveC. can be used as is by the DBMS D. is generally stored on disk in an ASCII text format Loading... 8. A command that lets you change one or more fields in a record is ?A. lookup B. none of above C. modify D. insert Loading... 9. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time ?A. query language B. transaction logC. data manipulation language D. report writer Loading... 10. A set of programs that handle a firm's database responsibilities is called ?A. database management system (DBMS) B. database processing system (DBPS) C. all of aboveD. data management system (DMS) Loading... Loading... Related NTS Results Post:Urogenital System Test 05 Preparation OnlineBank System Test 01 Preparation OnlineBank System Test 06 Preparation OnlineBank System Test 02 Preparation OnlineUrogenital System Test 07 Preparation OnlineUrogenital System Test 03 Preparation OnlineBank System Test 03 Preparation OnlineBank System Test 04 Preparation Online
