DBMS Important Questions and Answers Set - 4
31. The following command is used for inserting records
A. INSERT
B. ADD
C. Both of the above
D. None of the above
Ans- A.INSERT
32. The Query is a statement requesting for
A. Insertion of information
B. Deletion of information
C. Update of information
D. Retrieval of information
Ans- D.Retrieval of information
33. The activity of a file
A. Is a low percentages of number of records added or deleted from a file
B. If high , reduces processing efficiency for sequential and non sequential
files
C. Is a measure of the percentage of existing records updated during a run
D. Refers to how closely the files fit into the allocated
Ans- A.Is a low percentages of number of records added or deleted from
a file
34. The following statement is not valid about indexing
A. It stores the index fields
B. It stores the corresponding record number
C. It maintains the alphabetically order
D. It duplicate the database file
Ans- D.It duplicate the database file
35. The following devices can be used to input data into a database
A. Keyboard , fax roller ball
B. Mouse , keyboard , monitor
C. Mouse , keyboard , touch screen
D. None of the above
Ans- C.Mouse , keyboard , touch screen
36. The following command is used for sorting
A. List
B. Browse
C. Index
D. Sort
Ans- C.Index
37. List command used to get
A. List of database contents
B. List of database contents
C. List of variables used in database file
D. None of the above
Ans- A.List of database contents
38. A field that uniquely identifies a record is called a
A. Main field
B. Header
C. Key field
D. None of the above
Ans- C.Key field
39. Corrupted index file is corrected using
A. Modify index
B. Recreate index
C. Reindex
D. None of the above
Ans- C.Reindex
40. The navigation buttons enables you to
A. Move from record to record in a table or form
B. Move from page to page in report
C. A and B both
D. None of the above
Ans- C. A and B both
