1z0-050 | The Renovate Guide To 1z0-050 vce


Q31. Examine the following PL/SQL block:

DECLARE

my_plans pls_integer;

BEGIN

my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id => ?9twu5t2dn5xd?; END;

Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

A. It is loaded with the FIXED status.

B. It is loaded with the ACCEPTED status.

C. It is not loaded with the ENABLED status.

D. It is not loaded with the ACCEPTED status.

Answer: B

Q32. You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.

You issued the following RMAN commands to create a duplicate database:

RMAN> CONNECT target sys/sys@APPPROD

RMAN> DUPLICATE TARGET DATABASE

TO dupdb

FROM ACTIVE DATABASE

DB_FILE_NAME_CONVERT '/oracle/oradata/prod/',

'/scratch/oracle/oradata/dupdb/'

SPILE

PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/',

'/scratch/oracle/oradata/dupdb/'

SET SGA_MAX_SIZE = '300M'

SET SGA_TARGET = '250M'

SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', '/scratch/oracle/oradata/dupdb/redo/'

Which three are the prerequisites for the successful execution of the above command? (Choose three.)

A. The source database should be open.

B. The target database should be in ARCHIVELOG mode if it is open.

C. RMAN should be connected to both the instances as SYSDBA.

D. The target database backups should be copied to the source database backup directories.

E. The password file must exist for the source database and have the same SYS user password as the target.

Answer: BCE

Q33. Which two statements are true regarding hot patching? (Choose two.)

A. It requires relinking of the Oracle binary.

B. It does not require database instance shutdown.

C. It can detect conflicts between two online patches.

D. It is available for installing all patches on all platforms.

E. It works only in a single database instance environment.

Answer: BC

Q34. Examine the section of the Health Check report given below:

DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')

----------------------------------------------------------------------- Run Name : HM_RUN_1061

Run Id : 1061

Check Name : Data Block Integrity Check

Mode : REACTIVE

Status : COMPLETED

Start Time : 2007-05-12 22:11:02.032292 -07:00

End Time : 2007-05-12 22:11:20.835135 -07:00

Error Encountered : 0

Source Incident Id : 7418

Number of Incidents Created :0

Which two statements are true regarding the Health Check report? (Choose two.)

A. Health Check was performed manually.

B. Health Check was performed to check the disk image block corruptions.

C. Health Check was performed to check interblock and intersegment corruption.

D. Health Check was performed to verify the integrity of database files and report failures.

E. Health Check was performed by the Health Monitor automatically in response to a critical error.

Answer: AB

Q35. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A. The database files are corrupted when the database is open.

B. The archived log files are missing for which backup is not available.

C. The user has dropped an important table that needs to be recovered.

D. You are not able to start up the database instance because the required database files are missing.

Answer: AD

Q36. What are the advantages of variable extent size support for large ASM files? (Choose two.)

A. It improves performance in the extended cluster configuration by reading from a local copy of an extent.

B. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.

C. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

D. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.

Answer: CD

Q37. In which cases is reference partitioning effective in enhancing performance?

A. It is effective only in partition pruning.

B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

Answer: D

Q38. 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

Q39. You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.

Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)

A. The ASM-preferred mirror read feature is enabled.

B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.

D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

Answer: AB

Q40. Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

A. It does not allow you to change the moving window size.

B. Adaptive threshold functionalities use it by default to compute statistics.

C. It is created by default with the window size being equal to the AWR retention time.

D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

Answer: BC