Let us see the Oracle MCQ’s Questions Answers.
1. In the following which the instance made by oracle?
A. Data processes
B. Oracle background processes
C. Memory processes
D. all of these
Ans: ANSWER IS MEN DALNY HEN
2. In dynamic data replication which of the following database is used for oracle
A.DBMS
B. DBA
C. DBMA
D. none of these
Ans: ANSWER IS MEN DALNY HEN
3 When a ROLLBACK statement is issued to the database, the transaction has ended, which of the following is true.
A. all work done by the transaction is undone as if it had not been issued.
B. Any locks acquired by the transaction are released.
C. all work done by the transaction is done.
D. A&B both
Ans: ANSWER IS MEN DALNY HEN
4. When the SQL statement is finished which of the following segment is destroyed?
B. Temporary Segment
C. Data Segment
D. None of these
5. ANSWER IS MEN DALNY HEN
6. In oracle we can create SNAPSHOT LOG for[DBA].
A. complex snapshot
B. destroyable snapshot
C. Simple snapshot
D. A&B both
Ans: ANSWER IS MEN DALNY HEN
7. By the help of PL/SQL expression reconstructed using?
A.HTP
B. HTTP
C. FTP
D. A&C both
Ans: ANSWER IS MEN DALNY HEN
8. Which of the following is the use of index?
A. simply the user’s perception of the data
B. retrieve data more quickly and efficiently
C. retrieve data more quickly
D. none of these
Ans: ANSWER IS MEN DALNY HEN
9. In [DBA] transaction per rollback is derived in
A. DB-block-buffers
B. shared pool size
C. process
D. none of these
Ans: ANSWER IS MEN DALNY HEN
10. For displaying the output on the webpage which of the following method are used?
A. %ROWTYPE
B. %ROWCOL
C. %COL
D. none of these
Ans: ANSWER IS MEN DALNY HEN
11. The following component comprise an oracle architecture?
A. datafiles
B. tablespace
C. data related background
D. All of these
Ans: ANSWER IS MEN DALNY HEN
12. The LGWR is used to writes information into?
A. control files
B. redo log files
C. database files
D. none of these
Ans: ANSWER IS MEN DALNY HEN
13. In oracle, the following is used to declare the record.
A. function
B. procedure
C.A&B both
D. package
Ans: ANSWER IS MEN DALNY HEN
14. Use of context in oracle is?
A. store rollback information used when data must be reload back
B. store user data within database
C. minimize the amount of wasted (empty) storage
D. All of these
15. In oracle the overall structure of the database is maintained in file called?
A. roiling files
B. control files
C. redolog file
D. B&C both
Ans: ANSWER IS MEN DALNY HEN