Free Oracle 1Z1-050 Exam Dumps Questions & Answers

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose al that apply.)

• A.  testing and accepting the SQL profile
• B.  adding tuned SQL plans into the SQL plan baseline
• C.  tuning each SQL statement in the order of importance
  F- generating baselines that include candidate SQLs fortuning
• D.  generating the SQL profile
• E.  generating a list of candidate SQLs fortuning

You issued the following command to mount the DATA disk group in restricted mode:
ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?

• A.  The client RDBMS instance can access the file as a read-only file.
• B.  A disk in a disk group can be taken offline.
• C.  The client RDBMS instance cannot access the files in the disk group,
• D.  A new disk cannot be added to a disk group.

What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)

• A.  partitioning of tables and indexes
• B.  creation of bitmap, function-based, and B-tree indexes
• C.  selection of SQL plan baselines
• D.  creation of index-organized tables
• E.  optimization of materialized views for maximum query usage and fast refresh

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 becomes eligible for deletion according to the existing retention policy
• B.  The backup is deleted.
• C.  The backup is marked unavailable.
• D.  The backup overrides the backup retention policy.

Evaluate the following command and Its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

• A.  ALLO CAT ED_S PACE indicates only the space currently allocated and in use.
• B.  ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.
• C.  FREE_SPACE indicates only the space that is currently allocated and available for reuse.
• D.  FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
• E.  FREE_SPACE indicates only the space that is currently unallocated.