What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A.statistics recommendations
• B.SQL profile recommendations
• C.SQL statement restructure recommendations
• D.creation of materialized views to improve query performance

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true when row archival management is enabled? (Choose two.)

• A.The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity
  tracking columns, to Indicate that a row is no longer considered active.
• B.The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
• C.The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
• D.The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session
  parameter.
• E.The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity
  tracking columns, to indicate that a row is no longer considered active.

Comment: *

Name: *

Email: *

Verification: *

You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package How would you create this role?

• A.as a secure application role
• B.with definer's rights
• C.with global authentication
• D.with external authentication

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

• A.It generates a script to recompile invalid objects post-upgrade.
• B.The preupgrade_fixups.sqlscript is created to list and describe issues in the source database.
• C.A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.
• D.It checks for required tablespaces and if they are not available, creates them automatically.
• E.The preupgrade_fixups.sqlscript is executed automatically to fix issues in the source database.
• F.The postupgrade_fixups.sqlscript is created to address issues that can be fixed after a database has been upgraded.

Comment: *

Name: *

Email: *

Verification: *

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.
Which two tools or utilities would you use to achieve this? (Choose two.)

• A.Oracle Enterprise Manager Cloud Control
• B.Database Configuration Assistant (DBCA)
• C.Oracle Enterprise Manager Database Express (EM Express)
• D.Recovery Manager (RMAN) script invoked by using scheduler

Comment: *

Name: *

Email: *

Verification: *