Database Management System (DBMS)

191. A ___________ is a single non-decomposable data element in a table:

  1. View
  2. Column
  3. Tablespace
  4. None of these

Correct answer: (B)
Column

192. SQL outputs a single table known as the ___________:

  1. View
  2. Column
  3. Tablespace
  4. Result set

Correct answer: (D)
Result set

193. How many forms of SQL:

  1. 2
  2. 4
  3. 6
  4. None of these

Correct answer: (A)
2

194. Which are form of SQL:

  1. Interactive
  2. Embedded
  3. Both
  4. None

Correct answer: (C)
Both

195. In SQL which operators on a data base to produce output for user demand:

  1. Interactive
  2. Embedded
  3. Both
  4. None

Correct answer: (A)
Interactive

196. In SQL which command can be put inside a program written in some other languages like C,C++:

  1. Interactive
  2. Embedded
  3. Both
  4. None

Correct answer: (B)
Embedded

197. Data is passed to a program environment through ___________:

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

Correct answer: (B)
SQL

198. DQL stands for:

  1. Data query line
  2. Data query languages
  3. Data query land
  4. Direct query languages

Correct answer: (B)
Data query languages

199. TCL stands for:

  1. Transaction control languages
  2. Transaction command languages
  3. Transaction connect languages
  4. None of these

Correct answer: (A)
Transaction control languages

200. Which is that part of SQL that allows a database user to create and restructure data base objects:

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

Correct answer: (C)
DDL

Page 20 of 45