1Z1-050 by Oracle Valid Free Exam Practice Test

Question 1

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

A. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash. B. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement. C. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements. D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

Correct Answer: A,D

Question 2

View the Exhibit.

Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS(lsh\ 'customers^be1, '(countryjd, cust_state_province)') FROM dual;
Which statement describes the significance of this command?

A. It creates a histogram to hold skewed information about the data in the columns. B. It collects statistics into the pending area in the data dictionary. C. It creates a virtual hidden column in the CUSTOMERSjDBE table. D. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.

Correct Answer: C

Question 3

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans generated for every SQL statement are stored in the SQL plan baseline by default. B. The plan baselines are stored temporarily in the memory as long as the database instance is running. C. The plans can be manually loaded to the SQL plan baseline. D. The plans in the SQL plan baseline are verified and accepted plans. E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

Correct Answer: C,D,E

Question 4

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

A. Recover from failures in the Real Application Cluster (RAC) environment. B. Diagnose and repair failures on a standby database. C. Diagnose and repair a data file corruption offline. D. Diagnose and repair a data file corruption online.

Correct Answer: A,B

Question 5

You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2.
The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it.
What action is required for dependent objects when you perform online table redefinition?

A. Referential integrity constraints must be manually enabled after the online table redefinition process. B. The dependent materialized view should have a complete refresh performed after the online table redefinition process. C. The materialized log should be dropped before the online table redefinition process. D. Triggers with the PRECEDES clause should be disabled before the online table redefinition process.

Correct Answer: B

Question 6

You are managing an Oracle Database 11 g database. You want to take the of size 100 TB on tape drive, but you have tape drives of only 10 GB each, quickly and efficiently?

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

Correct Answer: D

Question 7

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans. B. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB). C. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline. D. Capture the plans from the previous version using STS and then load them into the stored outline.

Correct Answer: B

Question 8

Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

A. It can be used to re-create the ASM disk group with its attributes. B. It can be used to backup all data on ASM disks. C. It can be used to recover the damaged ASM disk group along with the data. D. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.

Correct Answer: A,D

Question 9

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

A. SQL statements that are part of the available SQL Tuning Set (STS) only B. SQL statements that are part of the AWR baseline only C. SQL statements that are available in the cursor cache and executed by a user other than SYS D. SQL statements based on the AWR top SQL identification

Correct Answer: D

Question 10

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

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

Correct Answer: A,B,D

Question 11

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?

A. all disks in the disk group only if all of them are ONLINE B. all disks that are currently in OFFLINE mode C. all disks in the disk group D. all disks that are not currently in OFFLINE mode

Correct Answer: D

Question 12

You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.
You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?

A. The Flashback Archive FLA1 is dropped only if it is empty. B. The Flashback Data Archive and historical data are dropped. C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive. D. The tablespace having Flashback Archive is dropped.

Correct Answer: C

Oracle Database 11g: New Features for Administrators - 1Z1-050 Exam Practice Test