DBMS Important Questions and Answers Set - 1
1. The following term applies to a collection of related records in a database
A. File
B. Layout
C. File
D. Field
Ans- A. File
2. This set of related data items is known as
A. File
B. Record
C. Table
D. None of the above
Ans- B.Record
3. The framework for storing records in database is a
A. Form
B. Report
C. Query
D. Table
Ans- C.Query
4. The following command is used to search the record that satisfies the
specified criteria
A. FOUND
B. SEARCH
C. GET
D. LOCATE
Ans- A.FOUND
5. The data in a record is of the following types
A. Four text fields and three numeric fields
B. Two integer fields and five text fields
C. Three text fields and four numeric fields
D. None of the above
Ans-B. Two integer fields and five text fields
6. A treelike structure of records in a database. Select the best fit for answer
A. Hierarchical database structure
B. Relational database structure
C. Multidimensional database structure
D. Sequential database structure
Ans- A.Hierarchical database structure
7. The following language used by most of the DBMSs for helping their users
to access data
A. High level language
B. Query language
C. SQL
D. 4GL
Ans-A. High level language
8. What is a largest collection of data stored in a computer ? You might use
this type of program to keep a record of all the friends in your address book.
A. Information processing
B. Spreadsheet
C. Operating system
D. Database
Ans- D.Database
9. Which command is used to replace ?
A. REPLACE
B. REPLACE ALL
C. Add record from edit menu
D. All of the above
Ans- C.Add record from edit menu
10. The following part of a database that holds only one type of information
A. Report
B. Query
C. Record
D. Filed
Ans- D.Filed
