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