DBMS Important Questions and Answers Set - 11
21. The executive responsible for the data processing function in an
organization is
A. PM
B. DBMS
C. DP
D. DPM
Ans-B. DBMS
22. Which of the following is NOT a type of Microsoft Access database object ?
A. Queries
B. Workbooks
C. Forms
D. Tables
Ans- B.Workbooks
23. A file containing relatively permanent data is
A. Random file
B. Transaction file
C. Master file
D. Sequential file
Ans- C.Master file
24. The complete picture of data stored in database is known as
A. Record
B. Scheme
C. System flowchart
D. DBMS
Ans- B.Scheme
25. A subset of characters within a data field is known as
A. Record
B. File
C. Data string
D. Byte
Ans- C.Data string
26. Data items grouped together for storage purposes are called a
A. Record
B. Title
C. List
D. String
Ans- A. Record
27. Which of the following terms does not describe a database structure used
by a DBMS to link data from several files ?
A. Relational
B. Structural
C. Network
D. All of the above
Ans- B. Structural
28. In a relational schema , each tuple is divided into fields called
A. Relations
B. Domains
C. Queries
D. All of the above
Ans- B. Domains
29. How do you filter by selection ?
A. Right click the field value and select filter by selection from the shortcut
menu
B. Find and double click the value on which you want to base the filter
C. Find and select the value on which you want to base the filter and select
tools > filter by selection from the menu
D. None of the above
Ans- A. Right click the field value and select filter by selection from the
shortcut menu
30. What is a fast way to adjust the width of a column ?
A. Right click the left side of the column heading
B. Double click the left side of the column heading
C. Double click the right side of the column heading
D. Select tools > adjust column width from the menu
Ans- C. Double click the right side of the column heading
