Com when you try to connect to the database you get

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: hen you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error? Choose two. A.snmp.ora B.names.ora C.spfile.ora D.sqlnet.ora E.listener.ora F.tnsnames.ora Answer: D, F QUESTION 8: You work as a database administrator for Certkiller .com. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user's connections. Which activity must you have completed before accomplishing this task? A.You must have started the database instance in restricted mode. B.You must have started the database instance inNORMALmode. C.You must have started the database instance with server parameter file. D.You must have started the database instance but must not have mounted. E.You must have started the database instance but must not have opened. Answer: C QUESTION 9: Actualtests.com - The Power of Knowing 1Z0-042 Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database? A.Until last commit B.Until the time you perform recovery C.Until the time the date file got corrupted D.Until the point where the last transaction begun E.You cannot recover the SYSTEMtablespaceand must re-create the database. Answer: A QUESTION 10: You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct? A.Undo data becomes obsolete after 1,000 seconds. B.Undo data gets refreshed after 1,000 seconds. C.Undo data will be stored permanently after 1,000 seconds. D.Commi...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online