Basics of Database Management System (DBMS) | Set 1
1. The following term applies to a collection of
related records in a database
Correct : A. File
2. This set of related data items is known as a
Correct : B. Record
3. The framework for storing records in database is a
Correct : C. Query
4. The following command is used to search the record that satisfies the specified criteria
Correct : A. FOUND
5. The data in a record is of the following types
Correct : B. two integer fields and five text fields
6. A treelike structure of records in a database.
Select the best fit for answer
Correct : A. Hierarchical database structure
7. The following language used by most of the DBMSs for helping their users to access data
Correct : A. High level language
8. What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.
Correct : D. Database
9. Which command is used to replace ?
Correct : C. Add record from edit menu
10. The following part of a database that holds only one type of information
Correct : D. Field
11. All of the following terms are related to computerized databases except which one?
Correct : A. Search
12. Need to see all the information from two tables on one form. Insert
Correct : B. A subform
13. What is the primary difference between a pivot table report and a cross tab query?
Correct : B. You can’t pivot a cross tab query
14. The largest unit of a database is
Correct : B. A field
15. What’s the best Access object for an invoice you’ll mail to customers?
Correct : A. A report
16. What is a Grouped Report?
Correct : C. A report that displays data grouped by fields you specify
17. Which field allow to select items from drop down list?
Correct : C. A lookup Field
18. What did the first Table Analyzer do?
Correct : A. Analyze the data in a set of flat files and automatically create a relational database system from that information
19. Pivot Table reports are good for
Correct : A. Analyzing large amounts of data
20. Which of the following are common ways to enforce data validation when entering data into an Access form?
Correct : C. A and B
21. The purpose of the Add-in Manager is to
Correct : C. Add or remove templates, macros, and wizards
22. Sub-schema can be used to
Correct : D. All of the above
23. If you are entering data in a form, a quick way to cpy a value from the previous record is to press
Correct : A. Ctrl+’
24. DBMS is
Correct : D. All of the above
25. COPY STRUCTURE command is used to
Correct : D. Copy structure of an active database to a new file
26. COUNT command is used to
Correct : D. Count the number of records in an active database file
27. What is the term to ask the computer to pt information in order numerically or alphabetically ?
Correct : C. Sort
28. The raw facts are called
Correct : A. Data
29. The term refers to a collection of related information
Correct : C. Outline
30. A form that is used to collect data in a structured manner for entry to a database is called a
Correct : C. Data capture form
31. The following command is used for inserting records
Correct : A. INSERT
32. The Query is a statement requesting for
Correct : D. Retrieval of information
33. The activity of a file
Correct : A. Is a low percentages of number of records added or deleted from a file
34. The following statement is not valid about indexing
Correct : D. it duplicate the database file
35. The following devices can be used to input data into a database
Correct : C. Mouse, keyboard, touch screen
36. The following command is used for sorting
Correct : C. index
37. List command is used to get
Correct : A. List of database contents
38. A field that uniquely identifies a record is called a
Correct : C. Key field
39. Corrupted index file is corrected using
Correct : C. Reindex
40. The navigation buttons enable you to
Correct : C. (A) and (B) both
41. Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by
Correct : A. Password
42. You can switch back and forth between
design and datasheet view by clicking the
Correct : C. view button
43. The table wizard
Correct : D. Automatically edits your data as you enter it
44. The names, address, and account balance of all of your customers, select the best fit for answer
Correct : D. key field
45. An integrated collection of all of the data about your customers. Select the best fit for answer
Correct : B. File
46. An identification field in a record. Select the best fit for answer
Correct : D. Key field
47. What is part of database that holds all of the information about one item or subject?
Correct : A. Record
48. What is a stored question about information in a database?
Correct : D. Query
49. RDBMS stands for
Correct : A. Relational Database Management System
50. Pack command is used to
Correct : A. Remove records permanently
51. Modules are
Correct : A. selection of commands used to automate repetitive tasks
52. APPEND command is used to
Correct : A. Add record to the end of active database file and starts full screen data entry
53. Append from command is used to
Correct : A. Add records from information in an array
54. Examples of centralized multi-user databases are
Correct : C. Airline reservations and other national global booking systems
55. New record is added using
Correct : A. Append record from browse menu
56. When a customer makes an online hotel booking, the database is updated in
Correct : B. Pseudo real-time
57. A database that contains tables linked by common fields is called a
Correct : C. Relational database
58. The use of integrated collections of database records and files for data storage and processing. The best fit for answer:
Correct : D. Query language
59. DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer
Correct : D. Query language
60. A specialist in charge of the database of an
organization select the best fit for answer
Correct : B. DBMS uses
61. This DBMS feature allows users to easily interrogate a database. Select the best fit for answer
Correct : C. Database administrator
62. The ….. presents data in a way similar to an excel spreadsheet
Correct : C. Print preview
63. It Is used to build and modify database objects and also to create new queries
Correct : C. Print preview
64. It shows the appearance and layout of a report, table or form in order to confirm what will be printed.
Correct : B. Design view
65. It examines a small portion or sample of your data in a report before printing it.
Correct : D. Layout preview
66. A report form
Correct : B. Is used during report generation to format data
67. Which of the following columns can not be found in the macro design window?
Correct : B. Comment column
68. The ascending order of a data hierarchy ios:
Correct : D. Byte, bit, record, field, file, database
69. A good query system
Correct : B. Allows non-programmers to access information stored in a database
70. How do you freeze a field a column or field in Microsoft Access?
Correct : D. Right click the column and select freeze columns from the shortcut menu
71. Within Table Datasheet view, how can you display associated records from another table?
Correct : A. Click the expand indicator (+) next to a record
72. Which of the following is not a command to find specific word or phrases in a database?
Correct : B. Click the find button on the record navigation button area
73. One of the type libraries that you can use to programmatically connect to Microsoft Access data is
Correct : B. ActiveX Data Objects
74. The data in a Pivot Table report is categorized using
Correct : B. Items from the Pivot Table field list
75. Records are deleted using
Correct : A. DELETE command followed by pack
76. You can enter data in a table in
Correct : C. format view
77. Creating a data file means
Correct : A. Designing base and defining the structure of the database
78. In a large DBMS
Correct : A. each user can “see” only a small part of the entire database
79. 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
Correct : C. Access
80. Each individual data items of record is called a
Correct : B. Data type
81. A large collections of files are called
Correct : B. Records
82. Memo field in database file is used to
Correct : D. Store long textual information
83. Applications that rely on databases are
Correct : A. Supermarket stock control, theater bookings and payroll
84. Which of the following is not a Access database object ?
Correct : D. datasheet
85. Data owners must protect their data against corruption or loss. One sensible method to achieving this is to
Correct : A. Take regular backups
86. Facilities offered by databases are
Correct : A. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
87. Users who store data about real people for marketing purposes must register the data and its potential use with
Correct : B. The data protection controller
88. When you double click a query object, you open
Correct : B. The object in print preview
89. Checks that are added to databases to detect unsuitable data on inpt are called
Correct : A. validation
90. Auto Report allows you to
Correct : B. Create a simple report
91. Auto Form allows you to
Correct : B. Create a simple report
92. The asterisk (*) is sometimes used in database queries. This character is then called a
Correct : A. Wildcard
93. When performing a look-up operation using a form
Correct : D. All of the above
94. Which custom date format displays the numeric day of the year when a date is entered?
Correct : C. Y
95. When you save an Access project, what file
format do you use?
Correct : A. .adp
96. Which of the following criterion would find records whose personality field does not equal “Nice”?
Correct : C. <>”Nice”
97. What is the maximum character field size you can set for a field that has a text data type?
Correct : B. 255
98. Which of the following fields would not make a suitable primary key ?
Correct : A. A date field
99. Auto reports can contain each of the following elements except
Correct : D. All of the above
100. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?