DBMS Important Questions and Answers Set - 8
31. Within table datasheet view , how can you display associated records
from another table ?
A. Click the expand indicator (+) next to a record
B. Double click the record
C. Apply the filter by form command
D. None of the above
Ans- A. Click the expand indicator (+) next to a record
32. Which of the following is not a command to find specific word or phrases in a database ?
A. Click the find button on the toolbar
B. Click the find button on the record navigation button area
C. Press Ctrl + F
D. Select edit > find from the menu
Ans- B. Click the find button on the record navigation button area
33. One of the type libraries that you can use to pro grammatically connect to
Microsoft Access data is
A. Collaborative Data objects
B. Active data objects
C. Dynamic data interfaces
D. None of the above
Ans- B. Active data objects
34. The data in a pivot table report is categorized using
A. Column headings
B. Items from the pivot table field list
C. Header rows
D. All of the above
Ans- B. Items from the pivot table field list
35. Records are deleted using
A. DELETE command followed by pack
B. DELETE command without pack
C. DELETE command followed by zap
D. DELETE command without zap
Ans- A.DELETE command followed by pack
36. You can enter data in a table in
A. Design view
B. Datasheet view
C. Format view
D. None of the above
Ans- C.Format view
37. Creating a data file means
A. Designing base and defining the structure of the database
B. Getting the information about database
C. Selecting data from database
D. Deleting data from database
Ans- A. Designing base and defining the structure of the database
38. In a large DBMS
A. Each user can “see” only a small part of the entire database
B. Each user can access every subschema
C. Each subschema contains every field in the logical schema
D. None of the above is true
Ans- A.Each user can “see” only a small part of the entire database
39. 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
A. Excel
B. Powerpoint
C. Access
D. Word
Ans- C.Access
40. Each individual data items of record is called a
A. Filed
B. Data type
C. Comment
D. All of the above
Ans- B.Data type
