Skip to main content

Oracle DBA Interview questions With Answer Part-V

                                                  Oracle DBA Interview questions With Answer


Question 1: When is a request sent to a listener?

A. After every call.
B. Before every call.
C. After name resolution.
D. Before name resolution.

Best Oracle Books
Question 2: In which file is the information that host naming is enabled stored?

A. init.ora
B. sqlnet.ora
C. tnsnames.ora
D. listener.ora

Question 3:  Which protocols can oracle Net 11g Use

A.TCP
B.UDP
C.SPX/IPX

Question 4: Which of the following statements about listeners is correct?

A. A listener can connect you to one instance only.
B. A listener can connect you to one service only.
C. Multiple listeners can share one network interface card.
D. An instance will only accept connections from the listener specified on the local_listener parameter. Best Oracle Books

Question 5: Can we perform DML operation on Materialized view?
A.Yes
B.No

Question 6: Materialized views are schema objects that can be used to summarize pre compute replicate and distribute data?
A.True
B.False

Question 7: Does a materialized view occupy space?

A. Yes
B. No

Question 8: Can we name a Materialized View log?

A. Yes
B. No


Best Oracle Books
Question 9: By using which view can a normal user see public database link?

A. USER_DB_LINKS
B. DBA_DB_LINKS
C. ALL_DB_LINKS

Question 10: Can we change the refresh interval of a Materialized View?

A. YES
B. NO

Question 11: Can we use a database link even after the target user has changed his password?
A. Yes
B. No

Question 12: Can we convert a materialized view from refresh fast to complete?
A. Yes
B. No

Question 13: A normal user can create public database link?

A. True
B. False

Question 14: If we truncate the master table, materialized view log on that table__

A. Will be truncated
B. Won’t be truncated
C. Will be dropped
Best Oracle Books
Question 15: What is the correct procedure for multiplexing online redo logs?

A. Issue the ALTER DATABASE. . . ADD LOGFILE GROUP command.
B. Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command.
C. Shut down the database, copy the online redo-log, and start up the database.
D. Shut down the database, copy the online redo-log, edit the REDO_LOG_FILES parameter, and start up the database

Question 16: In which situation would you need to create a new control file for an existing database?

A. When all redo-log files are lost.
B. When MAXLOGMEMBERS needs to be changed.
C. When RECOVERY_PARALLELISM needs to be changed.
D. When the name of the parameter file needs to be changed

Question 17: When configuring a database for ARCHIVELOG mode, you use an initialization parameter to specify which action?

A. The size of archived log files.
B. How frequently log files will be archived.
C. That the database is in ARCHIVELOG mode.
D. to Store Archive log Files

Question 18: Which command creates a text backup of the control file?

A. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
B. ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;
C. ALTER DATABASE BACKUP CONTROLFILE TO filename;
D. ALTER DATABASE BACKUP CONTROLFILE TO TEXT filename;


Question 19: You are configuring a database for ARCHIVELOG mode. Which initialization parameter should you use?

A. LOG_ARCHIVE_SIZE
B. ARCHIVELOG_MODE
C. LOG_ARCHIVE_DEST

Question 20: How does a DBA specify multiple control files?

A. With the ADD CONTROLFILE command.
B. By using the files in the STARTUP command.
C. With the MULTIPLEX control file command.
D. By listing the files in the CONTROL_FILES parameter.


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

Popular posts from this blog

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

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database.

I have submitted this matter in oracle forum but not found any perfect answer.

Do you know why  it's not working ???