Oracle DBA Interview questions With Answer Part-IV

                               Oracle DBA Interview questions With Answer Part-IV

Question 1: What is a potential reason for a Snapshot too old error message?
a. You did not refresh your snapshots in time.
b. An ITL entry in a data block has been reused.
c. Rollback segment extent sizes are too large.
d. Your online redo log files are not big enough to snap your largest transactions.

Question 2: An Oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What is the possible solution?

A. Increase the extent size of the rollback segments.
B. Perform media recovery.
C. Increase the number of rollback segments.
D. Increase the size of the rollback segment tablespace.

Question 3: The status of the Rollback segment can be viewed through

A. DBA_SEGMENTS
B. DBA_ROLES
C. DBA_FREE_SPACES
D. DBA_ROLLBACK_SEG

Question 4: Explicitly we can assign transaction to a rollback segment

A. TRUE
B. FALSE

Question 5: Are uncommitted transactions written to flashback redologs?

A. Yes
B. No

Question 6: Is it possible to do flashback after truncate?

A.No
B. Yes

Question 7: Can we restore a dropped table after a new table with the same name has been created?

A. Yes
B. No

Question 8: Which following command will clear database recycle bin?

A.delete recyclebin;
B. clear recyclebin;
C. purge recyclebin;
D. truncate recyclebin

Question 9: What is the OPTIMAL parameter?

A. length of a rollback segment.
B. Optimizer mode
C. Size of the undo tablespace
D. None of the above

Question 10: Flashback query time depends on ____?

A. Undo_retention
B. Flashback_timeout

Question 11: Can we create spfile in shutdown mode?

A.Yes
B. No

Question 12: Can we alter static parameters by using scope=both

A. Yes
B. No

Question 13: Can we take backup of spfile in RMAN?

A. Yes
B. No

Question 14: Does Drop Database command removes spfile?

A. Yes
B. No

Question 15: Using which SQL command we can alter the parameters?

A. Alter database
B. Alter parameter
C. Alter system

Question 16: OMF database will improve the performance?

A. Yes
B. No

Question 17: Max number of control files that can be multiplexed in an OMF database?

A. 1
B. 5
C. 8
D. unlimited

Question 18. Which environment variable is used to help set up Oracle names?

A. ADMIN_TNS
B. TNS_NAMES
C. TNS_ADMIN
D. NAMES_TNS
E. NAMES_ADMIN
F. ADMIN_NAMES

Question19: Which Net8 component waits for incoming requests on the server side?

A. Port
B. Server
C. Listener
D. Dispatcher
E. Background process

Question 20: What is the listener name when you start the listener without specifying an argument?
A. LIST
B. LISTENER
C. LISTENER_NAME
D. The same as the instance name.


Best Oracle Books
Correct answer: 1(b), 2(a), 3(d), 4(a), 5(a), 6(a), 7(a), 8(c), 9(a), 10(a), 11(a), 12(b), 13(a),14(a),15(c),16(b),17(b),18(c),19(c),20(b)