Database Management System (DBMS)

171. In which is do not fully support the domain concept:

  1. DBMS
  2. DBS
  3. RDBMS
  4. All of these

Correct answer: (C)
RDBMS

172. Which is used for searching and retrieving records from the database:

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

Correct answer: (D)
DML

173. How many types of data structures used in hierarchical model:

  1. 2
  2. 3
  3. 4
  4. 5

Correct answer: (A)
2

174. PCR stands for:

  1. Primary child relationship
  2. Parent child relationship
  3. Both
  4. None

Correct answer: (B)
Parent child relationship

175. Which types of data structures used in Hierarchical model:

  1. PCR
  2. Records
  3. Both
  4. None

Correct answer: (C)
Both

176. ___________ it is an1:N relationship between two different record types:

  1. DATA
  2. RELTION
  3. PCR
  4. All of these

Correct answer: (C)
PCR

177. Which is a database model used to represent objects and the relationship among these objects:

  1. Data model
  2. Relation model
  3. Hierarchical model
  4. Network model

Correct answer: (C)
Hierarchical model

178. RDBMS stands for:

  1. Relational database management system
  2. Relational database management structured
  3. Relational database management search
  4. None of above

Correct answer: (A)
Relational database management system

179. Which algebra is widely used in computer science:

  1. Arithmetic algebra
  2. Relational algebra
  3. Both
  4. None

Correct answer: (B)
Relational algebra

180. ___________ algebra has similar power of expression as relational calculus and first order logic:

  1. Arithmetic algebra
  2. Relational algebra
  3. Both
  4. None

Correct answer: (B)
Relational algebra

Page 18 of 45