Sunday, 18 March 2012

DBMS MCQ 07


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


a.       Java
b.      C++
c.       Oracle
d.      DBMS


2.      Which was the first commercial RDBMS:


a.       MS SQL
b.      DB2
c.       MY SQL
d.      ORACLE


3.      In which year RSI introduced oracle V2:


a.       1978
b.      1979
c.       1980
d.      1981


4.      Which version of oracle, released in 1983:


a.       V1
b.      V2
c.       V3
d.      V4


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


a.       V1
b.      V2
c.       V3
d.      V4


6.      In which year oracle v5 was released:


a.       1977
b.      1979
c.       1983
d.      1985


7.      Which version of oracle entered the market with more features:


a.       V2
b.      V3
c.       V5
d.      V6


8.      Which has enhancements in the input/output operation of disk, scalability, locking of row, backup and recovery:


a.      Oracle V6  
b.      Oracle V5
c.       Oracle V3
d.      Oracle V4


9.      Oracle 8 is an object relational database that was released in:


a.      1977
b.      1979
c.       1983
d.      1985


10.  V6 of oracle also included the first version for_____:


a.       PL
b.      SQL
c.       Both
d.      None


11.  Which was introduced stored procedures and triggers in PL/SQL:


a.       Oracle V6 
b.      Oracle V5
c.       Oracle V3
d.      Oracle V7


12.  Version 8i entered the market in______:


a.       1979
b.      1989
c.       1999
d.      None of these


13.  RAC stands for:
a.       Real application cluster
14.  Which version included RAC that enable multiple instances for accessing a database simultaneously:


a.       V2i
b.      V4i
c.       V6i
d.      V9i


15.   Oracle 9i was introduced in:


a.       1999
b.      2000
c.       2001
d.      2002


16.  ASM stands for:
a.      Automatic storage management
17.  Oracle database 11g was released in_________:


a.       2001
b.      2002
c.       2006
d.      2007


18.  The server process contains memory for a private session which is its own and is called_________:


a.       SGA
b.      PGA
c.       Both
d.      None


19.  Tables and indexes that are data of logical database structure that are stored physically in the form of______:


a.      Data files
b.      Control files
c.       Online redo log files
d.      All of these


20.  Which files has metadata that specifies database structure that includes database name along with database files names and locations:


a.       Data files
b.      Control files
c.       Online redo log files
d.      All of these


21.  Which is also known as redo records, recording whatever changes are made to data:


a.       Data files
b.      Control files
c.       Online redo log files
d.      All of these


22.  The data in oracle database is stored in blocks known as ________:


a.      Data blocks
b.      Extents
c.       Segments
d.      Tablespaces


23.  Which contains many extents:


a.       Data blocks
b.      Extents
c.       Segments
d.      Tablespaces


24.  _____ shows a specified number of data blocks that are logically contiguous and keeps a particular type of information in its storage:


a.       Data blocks
b.      Extents
c.       Segments
d.      Tablespaces


25.  Which are logical storage units contained in a database and a logical container for some segment:


a.       Data blocks
b.      Extents
c.       Segments
d.      Tablespaces


26.  SOA stands for:
a.      Service- oriented architecture
27.  SOAP stands for:
a.      Simple object access protocol
28.  WSDL stands for:
a.      Web services description language
29.  ONS stands for:
a.      Oracle net services
30.  OLTP stands for:
a.      Online transaction processing
31.  OLAP stands for:
a.      Online analytical processing
32.  Which refers to a software that can be executed on two or more kinds of computer containing two or more kinds of operating system:


a.       Data blocks
b.      Extents
c.       Segments
d.      Portable


33.  Which refers to independent events of the main program flow of the systems that lacks concurrency:


a.       RDBMS
b.      Portable
c.       Asynchronously
d.      None of these


34.  Which is a method provided by an operating system, running in a sequence of steps:


a.       Storage
b.      Process
c.       Computing
d.      None of these


35.  How many interfaces provided by oracle:


a.       1
b.      2
c.       3
d.      4


36.  Which interface provided by oracle:
a.       SQL*PLUS
b.      SQL*PLUS command line interface
c.       SQLPlus Worksheet
d.      iSQL*PLUS
e.      All of these

No comments :

Post a Comment