Visit Amazan Store

Sunday, February 17, 2013

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)