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