Rebirth 1z0-050 Exam Study Guides With New Update Exam Questions

Q1. You have applications that have frequently executed queries, and produce small and static result sets.

You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.

What is the purpose of this configuration?

A. to avoid round trips to the server by enabling caching of query results in client memory

B. to improve performance by storing a copy of the data from the private SQL area of the PGA

C. to enhance the query performance by creating a cache in the client memory for sorting operations

D. to avoid the storing of query plans and results in the server by creating a cache in the client memory

View Answer

Q2. View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

You executed the following commands:

SQL> VAR tname VARCHAR2(60);

SQL> BEGIN

:tname := 'my_instance_analysis_mode_task'

DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT'); END;

Which statement describes the consequence?

A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.

C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.

D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

View Answer

Q3. You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)

A. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

B. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

C. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

D. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

View Answer

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

View Answer

Q5. View the Exhibit to examine the error obtained during the I/O calibration process.

There are no data files on raw devices. 

What is the reason for this error?

A. The DISK_ASYNCH_IO parameter is set to TRUE.

B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.

C. Another session runs the I/O calibration process concurrently.

D. The pending area has not been created before running the I/O calibration process.

View Answer

Q6. You have the following requirements in relation to the detection of block corruption for your database instance:

1. Check for logical self-consistency of data blocks when modified in memory.

2. Checksums are calculated before and after the block change.

3. Checks are performed for the lost writes to the physical standby database.

Which method would help you perform the above checks automatically?

A. Set the DB_SECUREFILE parameter to PERMITTED.

B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.

C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.

D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.

View Answer

Q7. The INV_HISTORY table is created using the command:

SQL>CREATE TABLE INV_HISTORY

(inv_no NUMBER(3),

inv_date DATE,

inv_amt NUMBER(10,2))

partition by range (inv_date)

interval (numtoyminterval(1,'month'))

(partition p0 values less than (to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than (to_date('01-01-2006','dd-mm-yyyy'))); The following data has been inserted into the INV_HISTORY table :

INV_NO INV_DATE INV_AMT

1 30-dec-2004 1000

2 30-dec-2005 2000

3 1-feb-2006 3000

4 1-mar-2006 4000

5 1-apr-2006 5000

You would like to store the data belonging to the year 2006 in a single partition and issue the command:

SQL> ALTER TABLE inv_history MERGE PARTITIONS

FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006')) INTO PARTITION sys_py;

What would be the outcome of this command?

A. It executes successfully, and the transition point is set to '1-apr-2006'.

B. It executes successfully, and the transition point is set to '15-apr-2006'.

C. It produces an error because the partitions specified for merging are not adjacent.

D. It produces an error because the date values specified in the merge do not match the date values stored in the table.

View Answer

Q8. You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command:

RMAN>CHANGE BACKUPSET 231 NOKEEP;

What is the implication of this command?

A. The backup is deleted.

B. The backup is marked unavailable.

C. The backup overrides the backup retention policy.

D. the backup becomes eligible for deletion according to the existing retention policy

View Answer

Q9. Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

A. It repairs blocks that have read disk I/O errors.

B. It checks whether the alias metadata directory and the file directory are linked correctly.

C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.

D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

View Answer

Q10. You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. 

What configuration would you effect to achieve your objective? (Choose all that apply.)

A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

View Answer