Database Management System (DBMS)

241. In which year relational algebra became prominent after the relational model of database was published:

  1. 1969
  2. 1970
  3. 1971
  4. 1972

Correct answer: (B)
1970

242. Relational algebra became prominent after the relational model of database was published by:

  1. Codds
  2. F.F. codd
  3. E.E. codd
  4. None of these

Correct answer: (A)
Codds

243. Which is an ANSI standard and has many different versions:

  1. IBM
  2. SQL
  3. RDBMS
  4. ORACLE

Correct answer: (B)
SQL

244. Which is used for interfacing with RDBMS:

  1. IBM
  2. SQL
  3. ANSI
  4. ORACLE

Correct answer: (B)
SQL

245. Which is the basis for SQL and also for all other contemporary database system like MS SQL Server, IBM DB2, Oracle, My SQL and MICROSOFT Access:

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

Correct answer: (C)
RDBMS

246. Which is basically an RDBMS in which object oriented features are implemented:

  1. Java
  2. C++
  3. Oracle
  4. DBMS

Correct answer: (C)
Oracle

247. Which was the first commercial RDBMS:

  1. MS SQL
  2. DB2
  3. MY SQL
  4. ORACLE

Correct answer: (D)
ORACLE

248. In which year RSI introduced oracle V2:

  1. 1978
  2. 1979
  3. 1980
  4. 1981

Correct answer: (B)
1979

249. Which version of oracle, released in 1983:

  1. V1
  2. V2
  3. V3
  4. V4

Correct answer: (B)
V2

250. Which version of oracle supported multi-version read consistency:

  1. V1
  2. V2
  3. V3
  4. V4

Correct answer: (D)
V4

Page 25 of 45