Data Base Management System (DBMS) MCQ Quiz Hub

1. The following term applies to a collection ofrelated records in a database
File
Layout
File
Field

2. This set of related data items is known as a
File
Record
Table
None of the above

3. The framework for storing records in database is a
Form
Report
Query
Table

4. The following command is used to search the record that satisfies the specified criteria
FOUND
SEARCH
GET
LOCATE

5. The data in a record is of the following types
four text fields and three numeric fields
two integer fields and five text fields
three text fields and four numeric fields
none of the above

6. A treelike structure of records in a database.Select the best fit for answer
Hierarchical database structure
Relational database structure
Multidimensional database structure
Sequential database access

7. The following language used by most of the DBMSs for helping their users to access data
High level language
Query language
SQL
4GL

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.
Information Processing
Spreadsheet
Operating system
Database

9. Which command is used to replace ?
REPLACE
REPLACE ALL
Add record from edit menu
None of the above

10. The following part of a database that holds only one type of information
Report
Query
Record
Field

11. All of the following terms are related to computerized databases except which one?
Search
Sort
Field names
Record grab

12. Need to see all the information from two tables on one form. Insert
A page break
A subform
A linked command button
None of the above

13. What is the primary difference between a pivot table report and a cross tab query?
A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
You can’t pivot a cross tab query
A cross tab query lets you group similar items. A pitot table report does not
None of the above

14. The largest unit of a database is
A record
A field
A subfield
None of the above

15. What’s the best Access object for an invoice you’ll mail to customers?
A report
A form
A table
All of the above

16. What is a Grouped Report?
A type of report that can be generated by the Report Wizard
A report that displays data that has been sorted in ascending or descending order
A report that displays data grouped by fields you specify
None of the above

17. What is a Grouped Report?
type of report that can be generated by the Report Wizard
A report that displays data that has been sorted in ascending or descending order C.
A report that displays data grouped by fields you specify
None of These

18. What did the first Table Analyzer do?
Analyze the data in a set of flat files and automatically create a relational database system from that information
Provide a graphic way to design relational databases
Automate process of connecting tables to SQL Server
None

19. Pivot Table reports are good for
Analyzing large amounts of data
Turning tables upside down
Breaking spreadsheet data into multiple worksheet
None of above

20. Which of the following are common ways to enforce data validation when entering data into an Access form?
Create an input mask to restrict the kind of value that can be entered in positions across the field.
Define a validation rule for that field
A and B
none of the above

21. Sub-schema can be used to
Create very different, personalized views of the same data
Present information in different formats
Hide sensitive information by omitting fields from the subschema’s description
All of the above

22. If you are entering data in a form, a quick way to cpy a value from the previous record is to press
Ctrl+’
F6
Ctrl+D
None of the above

23. DBMS is
Collection of data
Set of programs to access those data
Set of programs to update those data
All of the above

24. COPY STRUCTURE command is used to
Copy contents of an active database to a new file
Copy all records of an active database to disk
Copy contents of an active database to disk
Copy structure of an active database to a new file

25. COUNT command is used to
Count the number of data fields in an active database file
Count the number of data files which are active
Count the records which are updated
Count the number of records in an active database file

26. What is the term to ask the computer to pt information in order numerically or alphabetically ?
Crop
Report
Sort
Organize

27. What is the term to ask the computer to pt information in order numerically or alphabetically ?
Crop
Report
Sort
Organize

28. The raw facts are called
Data
Programs
Commands
Responses

29. The term refers to a collection of related information
Database
List
Outline
Record

30. A form that is used to collect data in a structured manner for entry to a database is called a
Database deign form
Systems flowchart
Data capture form
None of above

31. The following command is used for inserting records
INSERT
ADD
Both of the above
None of the above

32. The Query is a statement requesting for
Insertion of information
Deletion of information
Update of information
Retrieval of information

33. The activity of a file A.
Is a low percentages of number of records added or deleted from a file
If high, reduces processing efficiency for sequential and non sequential files
Is a measure of the percentage of existing records updated during a run
Refers to how closely the files fit into the allocated

34. The following statement is not valid about indexing
it stores the index fields
it stores the corresponding record number
it maintains the alphabetically order
it duplicate the database file

35. The following devices can be used to input data into a database
Keyboard, fax roller ball
Mouse, keyboard, monitor
Mouse, keyboard, touch screen
None of the above

36. The following command is used for sorting
list
browse
index
Sort

37. List command is used to get
List of database contents
List of database contents
List of variables used in database file
None of the above

38. A field that uniquely identifies a record is called a
Main field
Header
Key field
None of above

39. Corrupted index file is corrected using
Modifyindex
Recreateindex
Reindex
None of the above

40. The navigation buttons enable you to
move from record to record in a table or form
move from page to page in report
(A) and (B) both
None of the above

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
Password
User id’s
Status
None of the above

42. You can switch back and forth betweendesign and datasheet view by clicking the
queries object tab
switch command on the view menu
view button
select query title bar

43. The table wizard
Quickly creates a default report
Displays a subset of the data in a database
Contains sample tables and fields you can use to create a table
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
record
file
database
key field

45. An integrated collection of all of the data about your customers. Select the best fit for answer
Record
File
Database
Key field

46. An identification field in a record. Select the best fit for answer
Record
File
Database
Key field

47. What is part of database that holds all of the information about one item or subject?
Record
File
Query
Chart

48. What is a stored question about information in a database?
Record
Field
Report
Query

49. RDBMS stands for
Relational Database Management System
Relation Data Module System
Right Data Base Management System
None of the above

50. Pack command is used to
Remove records permanently
Remove records temporarily
Restore records permanently
Restore records temporarily

51. Modules are
selection of commands used to automate repetitive tasks
programs written in Visual C++
Object tabs
Group of records

52. APPEND command is used to
Add record to the end of active database file and starts full screen data entry
Add Record to the start of active database file
Add record to the start of active database file and starts full screen data entry
Add record to the end of database file

53. Append from command is used to
Add records from information in an array
Adds records from a file
Add records from a variable
Add records from stock

54. New record is added using
Append record from browse menu
Append record into from browse menu
Add record from edit menu
All of the above

55. When a customer makes an online hotel booking, the database is updated in
Batch mode
Pseudo real-time
One month
All of above

56. A database that contains tables linked by common fields is called a
Centralized database
Flat file database
Relational database
None of the above

57. The use of integrated collections of database records and files for data storage and processing. The best fit for answer:
Database management approach
DBMS uses
Database administrator
Query language

58. A specialist in charge of the database of anorganization select the best fit for answer
Database management approach
DBMS uses
Database administrator
Query language

59. The ….. presents data in a way similar to an excel spreadsheet
Datasheet view
Design view
Print preview
Layout preview

60. It Is used to build and modify database objects and also to create new queries
Datasheet view
Design view
Print preview
Layout preview