1. It is better to use DBMS than a file when there are
a. Multiple users wish to access the data
b. Stringent real time requirements
c. Complex relationships among data
d. All of the above
ans => Multiple users wish to access the data
2. DBMS is type of ....................software.
a. Application software
b. System Software
c. General Software
d. Both a and c.
ans => System Software
3. To which of the following term DBA referred ?
a. Data bank administrator
b. Data Administrator
c. Database Administrator
d. None of the above
ans => Database Administrator
4. Duplication of data in database is known as
a. Data Integrity
b. Data redundancy
c. Data inconsistency
d. None of the above
ans => Data redundancy
5. Which of the following enables us to view data from a table based on a specific criterion?
a. Form
b. Macro
c. Query
d. Report
ans=> Query
6. Which of the following is used to establish an association between related tables?
a. Line
b. Primary Key
c. Relationship
d. Records
ans=> Relationship
7. Which key is used to uniquely identify each record in database?
a. Unique Key
b. Primary Key
c. Key Record
d. Field Name
ans=> Primary Key
8. Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
a. 1NF
b. 2NF
c. 3NF
d. All of the mentioned
ans=> 3NF
9. A database language concerned with the definition of the whole database structure and schema is
a. DCL(Data Control Language)
b. DML(Data Manipulation Language)
c. DDL(Data Definition Language)
d. All of the above
ans=> DDL(Data Definition Language)
10. Which of the following is not a database model?
a. Object Oriented Database Model
b. Network Database Model
c. Relational Database Model
d. Waterfall Database Model
ans=> Waterfall Database Model
11. The overall description of a database is called....................
a. Data Integrity
b. Database Schema
c. Data Definition
d. Data Manipulation
ans=>Database Schema
12. Which of the following is not a DDL statement?
a. CREATE
b. SELECT
c. ALTER
d. DROP
ans=> SELECT
13. Which of the following is not a DML statement?
a. CREATE
b. SELECT
c. INSERT
d. DELETE
ans=> CREATE
14. In a relational model, relations are termed as
a. Tuples
b. Attributes
c. Tables
d. Rows
ans=> Tables
15. In Hierarchical Model records are organized as
a. Table
b. List
c. Links
d. Tree
ans=> Tree
16. What is used for database security?
a. Data encryption
b. Password
c. Finger print
d. All of the above
ans=> All of the above
17. Prevention of access to the database by unauthorized.
a. Integrity
b. Security
c. Productivity
d. Reliability
ans=> Security
18. SQL stands for..............
a. Simple Query Language
b. Structured Quarter Language
c. Structure Question Language
d. Structured Query Language
ans=> Structured Query Language
19. Number of Tuples in Relation is called..............
a. Degree
b. Attribute
c. Cardinality
d. Vertex
ans=>Cardinality
20. What is the advantage of distributed database over centralized database?
a. Software cost
b. Software complexity
c. Slow response
d. Modular growth
ans=> Modular growth
21. Which one of the following refers to the copies of the same data occupying the memory space at multiple places.
a. Data Repository
b. Data Inconsistency
c. Data Mining
d. Data Redundancy
ans=> Data Redundancy
