17. In ________ , data is stored in a single table. Usually such types of files are suitable for less amount of data.
a. Flat File
b. Relational File
c. Both (a) and (b)
d. None of these
Answer: a. Flat File
18. In ________ , data is stored in multiple tables and the tables are linked using a common field. It is suitable for medium to large amount of data.
a. Flat File
b. Relational File
c. Both (a) and (b)
d. None of these
Answer: b. Relational File
19. __________ are dedicated computers that hold the actual databases and run only the DBMS and related software.
a. Database
b. Database client
c. Database servers
d. Server
Answer: c. Database servers
20. Databases available on the database servers are accessed through command line or graphic user interface tools referred to as ___________.
a. Frontends
b. Backends
c. Server
d. Client
Answer: a. Frontends
21. Database servers are referred to as ___________.
a. Frontends
b. Backends
c. Client
d. Application Software
Answer: b. Backends
22. A model, in which data is stored on Server, and it accessed by client using frontends application, called ________.
a. Client-Server Model
b. Server-Client Model
c. Server Architecture Model
d. Client Model
Answer: a. Client-Server Model
23. Storage of same data in multiple files, called _______________.
a. Data Integrity
b. Data Security
c. Data Redundancy
d. Data Consistency
Answer: c. Data Redundancy
24. __________ means that the data is accurate and consistent in the database..
a. Data Integrity
b. Data Security
c. Data Redundancy
d. Data Consistency
Answer: a. Data Integrity
25. ____________ means there should be multiple mismatching copies of the same data.
a. Data Integrity
b. Data Security
c. Data Redundancy
d. Data Inconsistency
Answer: d. Data Inconsistency
26. Which of the following is not an advantage of DBMS?
a. Reduce Data Redundancy
b. Data Integrity
c. Sharing of Data
d. Data Insecurity
Answer: d. Data Insecurity
27. Which of the following is not an advantage of DBMS?
a. Privacy
b. Data Security
c. Backup and Recovery
d. Data Consistency
e. None of these
Answer: e. None of these
28. A _______ is a set of information (made up of fields) stored in your database about one of the items.
a. Field
b. Record
c. Column
d. Data item
Answer: b. Record
29. Collection of similar records creates a _______.
a. Tuple
b. Records
c. Fields
d. Table
Answer: d. Table
30. A _________ represents one type of information.
a. Data item
b. Field
c. Data Element
d. All of these
Answer: All of these
31. When data is to be stored, maintained, and retrieved from multiple tables then special database software are required known as ________________.
a. DBMS
b. RDBMS
c. ODBMS
d. SDBMS
Answer: b. RDBMS
