1z0-050 | The Secret of Oracle 1z0-050 pdf


Q11. The following command is executed to create the baseline template:

SQL> EXECUTE

DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=> TO_TIMESTAMP(SYSDATE+2),

END_TIME=>TO_TIMESTAMP(SYSDATE+10),

BASELINE_NAME=>'Mybase4',

TEMPLATE_NAME=>'Mytemp4',

EXPIRATION=>NULL);

Which statement is true about the effect of the above command?

A. It creates a baseline template that never expires.

B. It produces an error because no snapshot information is provided to create the baseline.

C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.

D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

Answer: A

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

Q13. Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

A. Health Monitor checks are always initiated manually when there is some critical error.

B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.

C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.

D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.

Answer: BD

Q14. Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)

A. renaming of control files

B. multiplexing of control files

C. dropping the database user

D. configuring the database in ARCHIVELOG mode

E. renaming of data files

Answer: DE

Q15. Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

A. The database must be running in ARCHIVELOG mode.

B. No special setup is required, and the feature is enabled by default.

C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.

D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.

E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

Answer: E

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

Q17. The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. 

Which two operations are performed by the optimizer in this scenario? (Choose two.)

A. The optimizer adds the new plan to the plan history.

B. The optimizer selects the new plan for the execution of the SQL statement.

C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.

D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

Answer: AE

Q18. Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

A. It contains only SQL profiles generated by SQL Tuning Advisor.

B. It stores plans generated by the optimizer using a stored outline.

C. It is part of the data dictionary and stored in the SYSAUX tablespace.

D. It is part of the data dictionary and stored in the SYSTEM tablespace.

E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

Answer: CE

Q19. You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:

ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR; 

What is the implication of this command?

A. The command produces an error because the retention time cannot be reduced.

B. All historical data older than three years is purged from the flashback archive FLA1.

C. All historical data is purged and the new flashback data archives are maintained for three years.

D. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

Answer: B

Q20. View the Exhibit to observe the error.

You receive this error regularly and have to shut down the database instance to overcome the error.

What can the solution be to reduce the chance of this error in future, when implemented?

A. locking the SGA in memory

B. automatic memory management

C. increasing the value of SGA_MAX_SIZE

D. setting the PRE_PAGE_SGA parameter to TRUE

Answer: B