Online Access Free 1Z1-050 Exam Questions

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

• A.ADR diagnostic files
• B.initialization parameter settings
• C.PL/SQL functions, procedures, and packages
• D.the table and index definitions and actual data
• E.all the optimizer statistics

Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?

• A.The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
• B.The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
• C.The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.
• D.The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).

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.intrafile parallel backup
• B.parallel image copy backup
• C.parallel backup with MAXPIECESIZE configured for the channel
• D.backup with MAXPIECESIZE configured for the channel

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=>'Mytemp4l,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?

• A.It produces an error because no snapshot information is provided to create the baseline.
• B.It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.
• C.It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.
• D.It creates a baseline template that never expires.

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

• A.It can be used to allow the access privilege settings for users as well as roles.
• B.It can be used to selectively restrict the access for each user in a database to different host computers.
• C.It can be used to control the time interval for which the access privilege is available to a user.
• D.It can be used to allow the access privilege settings for users but not roles.
• E.It can be used to selectively restrict a user's access to different applications in a specific host computer.