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