This preview shows page 1. Sign up to view the full content.
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.
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.
PLSQL_CODE_TYPE specifies the compilation mode for PL/SQL library units.
PL/SQL library units will be compiled to PL/SQL bytecode format. Such modules are
executed by the PL/SQL interpreter engine.
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.
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.)
C.http://fubar.europe. Certkiller .com:5500/em
D.http:// Certkiller 22.214.171.124.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
You work as a database administrator for Certkiller .com. While load...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09