Free Oracle 1Z1-050 Exam Dumps Questions & Answers

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

• A.  Database must be running in archivelog mode.
• B.  The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
• C.  Undo retention guarantee must be enabled.
• D.  Automatic undo management must be enabled.

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1 /archive1
LOG_ARCHIVE_DEST_2 = 'SERVICE = Stdb1
DB_RECOVERY_FILE_DEST = 7u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?

• A.  All archived redo log files backed up at least once to tape are eligible for deletion.
• B.  All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
• C.  All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
• D.  All archived redo log files backed up at least twice to tape are deleted.

Evaluate the following block of code
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => lmycompany-com-permissions.xmll1
principal => 'ACCTJvlGR1,
is_grant => TRUE,
privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => 'mycompany-com-permissions.xml',
host => ".mycompany.com');
END;
What is the outcome of the above code?

• A.  It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
• B.  It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges
• C.  It produces an error because a fully qualified host name needs to be specified.
• D.  It produces an error because the range of ports associated with the hosts has not been specified.

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 costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
• C.  The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
• D.  The optimizer selects the new plan for the execution of the SQL statement.
• E.  The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

View the Exhibit to examine the Automatic SQL Tuning result details.

Which action would you suggest for the selected SQL statement in the Exhibit?

• A.  Collect statistics for the related objects.
• B.  Run the Segment Advisor for recommendations.
• C.  Run the Access Advisor for the SQL statement.
• D.  Accept the recommended SQL profile.