Data Base Management System (DBMS) MCQ Quiz Hub

1. The number of logical records in a physical record is
group
blocking factor
sector
field

2. A top to bottom relationship among the items in a database is established by a
Hierarchical schema
Network Schema
Relational schema
All of the above

3. A command that lets you cange one or morefields in a record is
Insert
Modify
Look up
All of the above

4. A logical schema
Is the entire database
Describes how data is actually stored on disk
Is a standard way of organizing information into accessible parts
All of the above

5. What is the purpose of the page field on a pivot table report?
It creates a new page for each type of data
It allows the data within the the Pivot Table report to be filtered
It displays a title for the Pivot Table report
None of the above

6. What does the Special Effect button on the formatting toolbar do?
t lets you add animation to your forms and reports to make them more entertaining and amusing
It lets you select a transitional effect for how a form opens and closes
It applies a 30d effect to a selected control
None of the above

7. Pivot Table report data must meet which of the following criteria?
It must be in tabular form, have unique column labels, and each row must represent a unique piece of data
Any dates should be formatted with the data format and blank rows or columns should be removed
It must be in tabular form, have unique column lagels, and all rows must be sorted
Both (A) and (B)

8. Customers, Orders. What’s their best relationship?
Many-to-many
One-to-many
One-to-many
All of the above

9. Which control does access use to link data access page components to access data?
Microsoft Dynamic Data Control
Microsoft Data Connection Control
Microsoft Office Data Source Control
None of the above

10. Which of the following is a database management system?
Ms-Word
Lotus 1-2-3
Oracle
None of above

11. What is the corresponding text for the <#1/1/ 95# validation rule setting?
Neter a value less or more than 1,195
Value must be less than 95 characters
. Enter a date before 1995
All of above

12. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?
Object Viewer
Object Browser
Type Library Spy
None of the above

13. Which of the following is not a data type ?
Picture/graphic
Data/time
Texst
Number

14. The executive responsible for the data processing function in an organization is
PM
DBMS
DP
DPM

15. Which of the following is NOT a type of Microsoft Access database object?
Queries
Workbooks
Forms
Tables

16. The complete picture of data stored in database is known as
Record
Scheme
System flowchart
DBMS

17. A subset of characters within a data field is known as
Record
File
Data string
Byte

18. In a relational schema, each tuple is dividedinto fields called
Relations
Domains
Queries
All of the above

19. How do you filter by selection?
A. Right click the field value and select filter by selection from the shortcut menu
Find and double click the value on which you want to base the filter
Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
None of the above

20. What is a fast way to adjust the width of a column?
Right click the left side of the column heading
Double click the left side of the column heading
Double click the right side of the column heading
Select tools>adjust column width from the menu

21. If a piece of data is stored in two places in the database, then a
Storage space is wasted
Changing the data is one spot will cause data inconsistency
It can be more easily accessed
Both (A) and (B)

22. . What are the columns in a Microsoft Access table called?
Rows
Fields
Cells
Records

23. In access, the best types of queries to use for data analysis are:
Select querie
Parameter queries
Action queries
All of the above