DBMS Important Questions and Answers Set - 10
11. Pivot table report data must meet which of the following criteria ?
A. It must be in tabular form , have unique column labels , and each row must
represent a unique piece of data
B. Any dates should be formatted with the data format and blank rows or
columns should be removed
C. It must be in tabular form , have unique column labels and all rows must
be sorted
D. Both A and B
Ans-D. Both A and B
12. Customers , orders . What’s their best relationship ?
A. Many - to - many
B. One - to - one
C. One - to - many
D. All of the above
Ans- C. One - to - many
13. Which control does access use to link data access page components to
access data ?
A. Microsoft dynamic data control
B. Microsoft data connection control
C. Microsoft office data source control
D. None of the above
Ans- C. Microsoft office data source control
14. Which program do you use to edit code for data access pages ?
A. Microsoft script editor
B. Microsoft code editor
C. Microsoft data access pages editor
D. None of the above
Ans - A.Microsoft script editor
15. The way a particular application views the data from the database that
application uses is a
A. Module
B. Relational model
C. Schema
D. Sub - schema
Ans-D. Sub - schema
16. Which of the following is a database management system ?
A. Ms - word
B. Lotus 1-2-3
C. Oracle
D. None of the above
Ans- C. Oracle
17. What is the corresponding text for the <#1/1/95# validation rule setting ?
A. Enter a value less or more than 1,195
B. Value must be less than 95 characters
C. Enter a code before 1995
D. All of the above
Ans- A. Enter a value less or more than 1,195
18. 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 ?
A. Object viewer
B. Object browser
C. Type library spy
D. None of the above
Ans- B. Object browser
19. A computer language for informing the DBMS regarding the data structure
used is
A. PASCAL
B. DDL
C. PROLOG
D. FORTRAN
Ans- B.DDL
20. Which of the following is not a data type ?
A. Picture / graphic
B. Data /time
C. Text
D. Number
Ans- A. Picture / graphic
