DBMS Important Questions and Answers Set - 16
31. What data type should you choose for a zip code field in a table ?
A. Text
B. Number
C. Memo
D. All of the above
Ans- A.Text
32. A list consists of last names , first names , address and pin codes if all
people in the list have the same last and the same pin code , a useful key
would be
A. The pin code
B. The last name
C. A compound key consisting of the first name and the last name
D. All of the above
Ans- C.A compound key consisting of the first name and the last name
33. What happens when you add the asterisk ( *) from any field list of a query
A. The table will not include any fields from the table
B. The query sorts the table’s record in the order you specify
C. the query will include every filed from the table
D. The query uses the record from the table without displaying them
Ans- C.the query will include every filed from the table
34. The modify operation is likely to be done after
A. Delete
B. Look up
C. Insert
D. All of the above
Ans- B.Look up
35. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper
A. Display records between the dates 1/2/99 and 1/1/00
B. Display records between the dates 1/1/99 and 12/31/99
C. Display records whose dates equaled 1/1/99 and 12/31/99
D. All of the above
Ans- B.Display records between the dates 1/1/99 and 12/31/99
36. DDP stands for
A. Distributed double processing
B. Double decimal processing
C. Distributed data programming
D. Distributed data processing
Ans- D.Distributed data processing
37. To see sales amount figures totaled , into which drop area would you drag
that field ?
A. Drop column fields here
B. Drop row fields here
C. Drop data items here
D. None of the above
Ans- C.Drop data items here
38. Which access feature do you use to develop applications that host access
data on the web ?
A. Dynamic web data
B. Data access pates
C. Html data pages
D. None of the above
Ans-B. Data access pates
39. What is the common name for a column of data within an Access table ?
A. Field
B. Record
C. Row
D. None of the above
Ans- A.Field
40. A data structure consisting of several fields , some or all of which are
instances of the same data structure is called
A. Field
B. Bead
C. Database
D. Data collection
Ans- B. Bead
