After inspecting the alert log file you execute the

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: ecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true? A.PMON coordinates media recovery. B.SMON coordinates instance recovery. C.PMON coordinates instance recovery. D.Undo Advisor would roll back all uncommitted transactions. Actualtests.com - The Power of Knowing 1Z0-042 E.SQL*PLUS reports an error with the message asking you to perform instance recovery. Answer: B QUESTION 18: In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting? A.The source PL/SQL code will be stored in native machine code. B.The source PL/SQL code will be stored in interpreted byte code. C.The compiled PL/SQL code will be stored in native machine code. D.The compiled PL/SQL code will be stored in interpreted byte code. Answer: C PLSQL_CODE_TYPE specifies the compilation mode for PL/SQL library units. Values: *INTERPRETED PL/SQL library units will be compiled to PL/SQL bytecode format. Such modules are executed by the PL/SQL interpreter engine. *NATIVE PL/SQL library units (with the possible exception of top-level anonymous PL/SQL blocks) will be compiled to native (machine) code. Such modules will be executed natively without incurring any interpreter overhead. QUESTION 19: Exhibit: You work as a database administrator for Certkiller .com. You have started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control? (Choose two.) A.http://162.67.17.123:5500/em B.http://www.162.67.17.123:5500/em C.http://fubar.europe. Certkiller .com:5500/em D.http:// Certkiller 13.162.67.17.123:5500/em E.http:// Certkiller 13.fubar.europe. Certkiller .com:5500 F.http://www. Certkiller 13.fubar.europe. Certkiller .com:5500/em G.http:// Certkiller 13.fubar.europe. Certkiller .com:5500/em Answer: A, C Actualtests.com - The Power of Knowing 1Z0-042 QUESTION 20: You work as a database administrator for Certkiller .com. While load...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online