Database Management System (DBMS)

181. In relation algebra a new term was defined by codd as ___________:

  1. Relation
  2. Relation completeness
  3. Relation operation
  4. Relation selection

Correct answer: (B)
Relation completeness

182. How many primitive operators of relation algebra as proposed by codd:

  1. 2
  2. 3
  3. 4
  4. 6

Correct answer: (D)
6

183. Which is a unary operation:

  1. Selection operation
  2. Primitive operation
  3. Projection operation
  4. Generalized selection

Correct answer: (D)
Generalized selection

184. Relational calculus can be divided into how many calculi:

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

Correct answer: (B)
3

185. Which is relation calculus:

  1. Tuple relation calculus
  2. Domain relational calculus
  3. Both
  4. None

Correct answer: (C)
Both

186. Which calculus is based on specifying a number of tuple variables:

  1. Tuple relation calculus
  2. Domain relational calculus
  3. Both
  4. None

Correct answer: (A)
Tuple relation calculus

187. SQL is used for interacting with ___________:

  1. DBMS
  2. RDBMS
  3. DDL
  4. SDL

Correct answer: (B)
RDBMS

188. SQL is a ___________ languages:

  1. Database languages
  2. Declarative languages
  3. Both
  4. None

Correct answer: (B)
Declarative languages

189. ISO stands for:

  1. Input standards organization
  2. Interrupt standard organization
  3. International standards organization
  4. None of these

Correct answer: (C)
International standards organization

190. Which is a collection of a defined group of database object like tables, indexes, tablespace:

  1. Database
  2. Record
  3. Memory
  4. All of these

Correct answer: (A)
Database

Page 19 of 45