Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (21-30)

By | May 4, 2014

QUESTION 21
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.)

A.    The disk automatically goes offline.
B.    The disk is immediately dropped from the disk group.
C.    The ASM tracks the extents that are modified during the outage.
D.    The ASM migrates the extents from the unavailable disk to the remaining disks.

Answer: AC

QUESTION 22
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

A.    The incident metadata is purged when the problem is resolved and the DBA closes the SR.
B.    The incident files and dumps are not retained in the ADR for the manually created incidents.
C.    The incident files are retained but the incident metadata is purged when the problem is resolved
and the DBA closes the SR
D.    The default setting is for one year after which the incident metadata is purged from the ADR and
the files are retained for one month.

Answer: D

QUESTION 23
You opened the encryption wallet and then issued the following command:
SQL>CREATE TABLESPACE securespace
DATAFILE ‘/home/user/oradata/secure01.dbf’
SIZE 150M
ENCRYPTION USING ‘3DES168’
DEFAULT STORAGE(ENCRYPT);
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?

A.    It creates the table and encrypts the data in it.
B.    It generates an error because the wallet is closed.
C.    It creates the table but does not encrypt the data in it.
D.    It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

Answer: B

QUESTION 24
Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT.PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?

A.    The plan baselines are verified with the SQL profiles.
B.    All fixed plan baselines are converted into nonfixed plan baselines.
C.    All the nonaccepted SQL profiles are accepted into the plan baseline.
D.    The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

Answer: D

QUESTION 25
In which two aspects does hot patching differ from conventional patching? (Choose two.)

A.    It consumes more memory compared with conventional patching.
B.    It can be installed and uninstalled via OPatch unlike conventional patching.
C.    It takes more time to install or uninstall compared with conventional patching.
D.    It does not require down time to apply or remove unlike conventional patching.
E.    It is not persistent across instance startup and shutdown unlike conventional patching.

Answer: AD

QUESTION 26
Which statement about the enabling of table compression in Oracle Database 11g is true?

A.    Compression can be enabled at the table, tablespace, or partition level for direct loads only.
B.    Compression can be enabled only at the table level for both direct loads and conventional DML.
C.    Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
D.    Compression can be enabled at the table, tablespace, or partition level for both direct loads and
conventional DML.

Answer: D

QUESTION 27
Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

A.    Supplemental log must be enabled.
B.    Supplemental log must be enabled for the primary key.
C.    Undo retention guarantee for the database must be configured.
D.    Execute permission on the DBMS_FLASHBACK package must be granted to the user.

Answer: ABD

QUESTION 28
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tape drives of only 10 GB each. Which method would accomplish the task quickly and efficiently?

A.    intrafile parallel backup
B.    parallel image copy backup
C.    backup with MAXPIECESIZE configured for the channel
D.    parallel backup with MAXPIECESIZE configured for the channel

Answer: A

QUESTION 29
Which statements are true regarding the Query Result Cache? (Choose all that apply.)

A.    It can be set at the system, session, or table level.
B.    It is used only across statements in the same session.
C.    It can store the results from normal as well as flashback queries.
D.    It can store the results of queries based on normal, temporary, and dictionary tables.

Answer: AC

QUESTION 30
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)

A.    Every SQL statement in the STS is considered only once for execution.
B.    The SQL statements in the STS are executed concurrently to produce the execution plan and
execution statistics.
C.    The execution plan and execution statistics are computed for each SQL statement in the STS.
D.    The effects of DDL and DML are considered to produce the execution plan and execution statistics.

Answer: AC

If you want to pass Oracle 1Z0-050 successfully, do not missing to read latest lead2pass Oracle 1Z0-050 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-050.html