Database Management System (DBMS)

161. The heading of a relation is also referred to as ___________:

  1. Relation schema
  2. Intension
  3. Both
  4. None

Correct answer: (C)
Both

162. In relational model the body of the relation is referred to as ___________:

  1. Extension
  2. Criterion
  3. Relation
  4. None of these

Correct answer: (A)
Extension

163. Which is the set of defined atomic values for an attribute:

  1. Domain
  2. Data
  3. Register
  4. Models

Correct answer: (A)
Domain

164. Which is the name of role played by a domain in the relation:

  1. Relational schema
  2. Domain
  3. Attribute
  4. Relation

Correct answer: (C)
Attribute

165. Which is made up of relation name and a list of attributes:

  1. Relational schema
  2. Domain
  3. Attribute
  4. Relation

Correct answer: (A)
Relational schema

166. A ___________ is defined as the subset of the subset of the Cartesian product of domains:

  1. Extension
  2. Criterion
  3. Relation
  4. None of these

Correct answer: (C)
Relation

167. SQL schema is how many types of relation schema may be defined:

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

Correct answer: (A)
2

168. In a SQL schema may be defined as which types:

  1. VIEWS
  2. BASE RELATION
  3. BOTH
  4. NONE

Correct answer: (C)
BOTH

169. CAD stands for:

  1. Computer aided design
  2. Computer aided data
  3. Computer aided database
  4. None of these

Correct answer: (A)
Computer aided design

170. Which is refers to knowledge about the meaning of data:

  1. Data types
  2. Base relation
  3. Semantic knowledge
  4. All of these

Correct answer: (C)
Semantic knowledge

Page 17 of 45