Exam Code: 1z0-050 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: New Features for Administrators
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-050 Exam.

2016 Jun 1z0-050 Study Guide Questions:

Q71. You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. 

Which two statements are true regarding this oranfstab file? (Choose two.)

A. Its entries are specific to a single database.

B. It contains file systems that have been mounted by Direct NFS.

C. It is globally available to all Oracle 11g databases on the machine.

D. It contains file systems that have been mounted by the kernel NFS system.

Answer: CD


Q72. While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. 

Which two statements describe the consequences? (Choose two.)

A. The plan baselines can be evolved over time to produce better performance.

B. The newly generated plans are directly placed into the SQL plan baseline without being verified.

C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

Answer: AC


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


1z0-050  test

Rebirth 1z0-050 free exam:

Q74. You set the following parameters in the parameter file and restarted the database:

MEMORY_MAX_TARGET=0

MEMORY_TARGET=500M

PGA_AGGREGATE_TARGET=90M

SGA_TARGET=270M

Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.

C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Answer: AD


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


Q76. Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

A. Diagnose and repair a data file corruption offline.

B. Diagnose and repair a data file corruption online.

C. Diagnose and repair failures on a standby database.

D. Recover from failures in the Real Application Cluster (RAC) environment.

Answer: CD


2passeasy.com

Realistic 1z0-050 faq:

Q77. Which statement describes the effect of table redefinition on the triggers attached to the table?

A. All triggers on the table remain valid.

B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.

C. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.

D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.

Answer: B


Q78. Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

A. It returns space usage of only BasicFile LOB chunks.

B. It returns space usage of only SecureFile LOB chunks.

C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

Answer: B


Q79. ENCRYPT_TS is an encrypted tablespace that contains tables with data. 

Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A. The data is decrypted during SORT and JOIN operations.

B. The data remains encrypted when it is read into memory.

C. The data remains encrypted when it is stored in the redo logs.

D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Answer: C


Q80. You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB. You want to create the same directory structure for duplicate database files as of the target database.

You executed the following RMAN commands:

RMAN> CONNECT TARGET sys/sys@APPPROD

RMAN> CONNECT AUXILIARY sys/sys@DUPDB

RMAN> DUPLICATE TARGET DATABASE

TO dupdb

FROM ACTIVE DATABASE

PASSWORD FILE

SPILE

NOFILENAMECHECK;

What are the implications of this command?

A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

Answer: B