Oracle MCQ-1

image_pdfimage_print

1)The shared pool is also able to support ________ in data warehousing applications.
A. Unshared SQL
B. Stored SQL
C. Unsorted SQL
D. Shared SQL
E. None of these

2)An important purpose of the shared pool is to cache the executable versions of _________ statements.
A. SQL
B. PL/SQL
C. Both (A) and (B)
D. MS ACESS
E. None of these

3)___________ Database is the only database specifically designed as an Internet development and deployment platform
A. Oracle 8i
B. Oracle 9i
C. Oracle 6i
D. Oracle 7i
E. None of these

4)Oracle9i Reports is the solution of _______
A. Paper publishing
B. Web publishing
C. Both (A) and (B)
D. Publishing is not possible
E. None of these

5)When a query is submitted to oracle server for execution, oracle checks if same query has been executed previously. If found the same then this event is known as ________
A. Library cache hit
B. Soft parsing
C. Both (A) and (B)
D. Redo log
E. None of these

6)The ________ performs recovery when a failed instance starts up again.
A. Log Writer(LGWR)
B. Checkpoint(CKPT)
C. Process Monitor(PMON)
D. System Monitor(SMON)
E. None of these

7) Oracle9i Reports gives us _______options for building a Web report.
A. two
B. three
C. four
D. five
E. None of these

8)Which of the following is an example for Embedded SQL Statement?
A. ROLLBACK
B. SETROLE
C. ALTER SYSTEM
D. FETCH
E. None of these

9)Oracle Database segregates a small amount of the shared pool for large objects(Over 5KB).The segregated area of the shared pool is called ______
A. Fixed Pool
B. Allocated Pool
C. Reserved Pool
D. All of the above
E. None of the above

10)The ______ process is used for inter-instance locking in Real Application Clusters.
A. Lock Manager Server
B. Back Manager Server
C. Front Manager Server
D. Administration Manager
E. None of these

Answers:
1)a
2)c
3)b
4)c
5)c
6)d
7)a
8)d
9)c
10)a