1z0-050 Oracle 11i Braindump
ExamSoon 1z0-050 Exams
Oracle Oracle Database 11g: New Features for Administrators
O rder : 1z0-050 Exam
Practice Exam: 1z0-050
Exam Number/Code: 1z0-050
Exam Name: Oracle Database 11g: New Features for Administrators
Questions and Answers: 183 Q&As
Free 1z0-050 Braindumps
Exam : Oracle 1Z0-050
Title : Oracle Database 11g: New Features for Administrators
1. Which steps are mandatory to enable Direct NFS?
A.2 and 3
B.1 and 3
C.1 and 2
D.1, 2 and 3
Answer: B
2. Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A.SQL statements that are part of the AWR baseline only
B.SQL statements based on the AWR top SQL identification
C.SQL statements that are part of the available SQL Tuning Set (STS) only
D.SQL statements that are available in the cursor cache and executed by a user other than SYS
Answer: B
3. Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A.Undo retention guarantee must be enabled.
B.Database must be running in archivelog mode.
C.Automatic undo management must be enabled.
D.The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space
Management (ASSM).
Answer: CD
4. Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor
environment. At the end of the upgrade, you observe that the DBA executes the following script:
SQL> @utlrp.sql
What is the significance of executing this script?
A.It performs parallel recompilation of only the stored PL/SQL code.
B.It performs sequential recompilation of only the stored PL/SQL code.
C.It performs parallel recompilation of any stored PL/SQL as well as Java code.
D.It performs sequential recompilation of any stored PL/SQL as well as Java code.
Answer: C
5. During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option
to create a database as part of the installation. How would this environment variable s