Data Base Management System (DBMS) MCQ Quiz Hub

Basics of Database Management System (DBMS) Set 2

Choose a topic to test your knowledge and improve your Data Base Management System (DBMS) skills

1. It Is used to build and modify database objects and also to create new queries B. C. D.




2. It shows the appearance and layout of a report, table or form in order to confirm what will be printed.




3. It examines a small portion or sample of your data in a report before printing it.




4. A report form




5. Which of the following columns can not be found in the macro design window?




6. The ascending order of a data hierarchy ios:




7. A good query system




8. How do you freeze a field a column or field in Microsoft Access?




9. Within Table Datasheet view, how can you display associated records from another table?




10. Which of the following is not a command to find specific word or phrases in a database?




11. One of the type libraries that you can use to programmatically connect to Microsoft Access data is




12. The data in a Pivot Table report is categorized using




13. Records are deleted using




14. You can enter data in a table in




15. Creating a data file means




16. You want to keep track of addresses, phone numbers, parent/guardian names as well as class attendance, average and grades. Every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information




17. Each individual data items of record is called a




18. A large collections of files are called




19. Memo field in database file is used to




20. Applications that rely on databases are




21. Which of the following is not a Access database object ?




22. Data owners must protect their data against corruption or loss. One sensible method to achieving this is to




23. Facilities offered by databases are




24. When you double click a query object, you open




25. Checks that are added to databases to detect unsuitable data on inpt are called




26. Auto Report allows you to




27. The asterisk (*) is sometimes used in database queries. This character is then called a




28. When performing a look-up operation using a form




29. Which custom date format displays the numeric day of the year when a date is entered?




30. When you save an Access project, what fileformat do you use?




31. Which of the following criterion would find records whose personality field does not equal “Nice”?




32. What is the maximum character field size you can set for a field that has a text data type?




33. Which of the following fields would not make a suitable primary key ?




34. Auto reports can contain each of the following elements except




35. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database? A. DASD B. FMS C. EMMS D. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?




36. A repository for data, usually covering some specific topic is called




37. A repository for data, usually covering some specific topic is called




38. A repository for data, usually covering some specific topic is called




39. A notation for defining the form and structure of data is known as




40. A data item, which is not broken down into smaller units, is




41. Which of the following terms refers to the degree to which data in database system are accurate and correct?




42. A repository for data, usually covering specific topic is




43. A set of programs that handle firm’s database responsibilities is called a




44. Which of the following is not a relational database?




45. Which is used to provide the sight information to the right person at the right time for proper decision making ?




46. Dbase-III was developed by




47. What data type should you choose for a zip code field in a table?




48. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be




49. What happens when you add the asterisk (() from any field list ot a query?




50. The modify operation is likely to be done after




51. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper




52. DDP stands for




53. To see sales amount figures totaled, into which drop area would you drag that field?




54. Which access feature do you use to develop applications that host access data on the web?




55. What is the common name for a column of data within an Access table?




56. A data structure consisting of several fields, some or all of which are instances of the same data structure, is called




57. A group of characters used to identiry a given low level instruction is




58. One or more characters used to identify a data field in a computer program is




59. In Form view, which command displays records alphabetically?




60. Where do report and forms get their information form?