Database Management System (DBMS)

91. Which are the not features of a DBMS which provide a number of advantages for data management:

  1. DML
  2. DDL
  3. SDL
  4. None of these

Correct answer: (D)
None of these

92. Minimal data redundancy means improved ___________:

  1. Data independence
  2. Data consistency
  3. Data integration
  4. Data sharing

Correct answer: (B)
Data consistency

93. Who access the database occasionally and have different needs each time:

  1. Naïve users
  2. Casual users
  3. Sophisticated user
  4. All of these

Correct answer: (B)
Casual users

94. Who interact with the system without writing a program:

  1. Naïve users
  2. Casual users
  3. Sophisticated user
  4. All of these

Correct answer: (C)
Sophisticated user

95. Who interact with the system by invoking one of the permanent application program:

  1. Naïve users
  2. Casual users
  3. Sophisticated user
  4. All of these

Correct answer: (A)
Naïve users

96. The main interface that a native user uses is a form interface using ___________:

  1. DDL
  2. GUI
  3. OLAP
  4. DML

Correct answer: (B)
GUI

97. The provision of ___________ is a major objective for database system:

  1. Data independence
  2. Data consistency
  3. Data integration
  4. Data sharing

Correct answer: (A)
Data independence

98. Who is requested to carry out various operation, such as insert, delete, update and retrieval vwiours on the database by the user:

  1. DBA
  2. DBMS
  3. DBS
  4. DDL

Correct answer: (B)
DBMS

99. ___________ is a translates into low-level instruction that a query processor understands:

  1. DBA
  2. DBMS
  3. DBS
  4. DDL

Correct answer: (D)
DDL

100. Retrieval of data is done by using a ___________:

  1. Stack
  2. Query
  3. Linked list
  4. All of these

Correct answer: (B)
Query

Page 10 of 45