Database Management System (DBMS)

1. ___________ refers to the basic facts and entities, such as names and numbers.

  1. Data
  2. Information
  3. Input
  4. Output

Correct answer: (B)
Information

2. Information is processed from ___________

  1. Output
  2. Data
  3. Memory
  4. None of these

Correct answer: (B)
Data

3. MIS stands for:

  1. Management Information Server
  2. Management Information Service
  3. Management Information System
  4. Master Information System

Correct answer: (C)
Management Information System

4. Which is the false statement:

  1. A database is ordered collection of data.
  2. A database is systematic compilation of records in a computer.
  3. DBMS manages the database
  4. Data helps in making decisions.

Correct answer: (D)
Data helps in making decisions.

5. Which is the data model

  1. Relational
  2. Object-Relational
  3. Network
  4. All of these

Correct answer: (D)
All of these

6. Which is not the feature of database:

  1. Data redundancy
  2. Independence
  3. Flexibility
  4. Data Integrity

Correct answer: (A)
Data redundancy

7. Which is the type of data independence:

  1. Physical data independence
  2. Logical data independence
  3. Both
  4. None of these

Correct answer: (C)
Both

8. Which is the feature of database:

  1. Query Language
  2. Multi user access
  3. Data Dictionary
  4. All of these

Correct answer: (B)
Multi user access

9. Which is the database language:

  1. C
  2. C++
  3. SQL
  4. None of these

Correct answer: (C)
SQL

10. Which person is responsible for overall activities for database:

  1. Database designer
  2. Database analyst
  3. Database Administrator
  4. Database manager

Correct answer: (C)
Database Administrator

Page 1 of 45