Skip to main content

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)

Comments

Popular posts from this blog

Checking operating system version: must be 5.0, 5.1 or 5.2 Actual 6.1 Failed

This error occurred when we are installing old oracle software in latest OS (Operating System).   Basically Its’s occurring on windows platform.

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS

ORA-01775 Looping chain of synonyms

Explain Plan Error: ORA-01775: Looping chain of synonyms