Oracle MCQ’s Questions Answers

Last modified on September 12th, 2020

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

Answer - Click Here:
B

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
Answer - Click Here:
B

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
Answer - Click Here:
D

4. When the SQL statement is finished which of the following segment is destroyed?
A. Object Segment
B. Temporary Segment
C. Data Segment
D. None of these
5. ANSWER IS MEN DALNY HEN
Answer - Click Here:
B

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
Answer - Click Here:
C

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
Answer - Click Here:
D

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
Answer - Click Here:
B

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
Answer - Click Here:
C

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
Answer - Click Here:
A

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
Answer - Click Here:
D

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
Answer - Click Here:
B

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
Answer - Click Here:
A

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
Ans: ANSWER IS MEN DALNY HEN
Answer - Click Here:
C

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
Answer - Click Here:
B

Computer Science Repeated MCQs Book Download

Subscribe for Friendship

Latest posts by Prof. Fazal Rehman Shamil (see all)