Instant Access Oracle.1z0-062.v2022-11-15.q125 Actual Practice Test Engine for Free (Page 24)

40%off

1z0-062 Premium Dumps

Latest 1z0-062 Exam Premium Dumps provide by TrainingQuiz.com to help you Passing 1z0-062 Exam! TrainingQuiz.com offers the updated 1z0-062 exam dumps, the TrainingQuiz.com 1z0-062 exam questions has been updated to correct Answer. Get the latest TrainingQuiz.com 1z0-062 pdf dumps with Exam Engine here:

(380 Q&As Dumps, 40%OFF Special Discount: DumpsDB)

Question 111

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)

A.Only the ORD_CUSTOMER_IX1 index created.
B.Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
C.Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
D.The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
E.Both the indexes are created and used by the optimizer for queries on the ORDERS table.
F.Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Question 112

Identify three benefits of Unified Auditing.

A.Decreased use of storage to store audit trail rows in the database.
B.It improves overall auditing performance.
C.It guarantees zero-loss auditing.
D.The audit trail cannot be easily modified because it is read-only.
E.It automatically audits Recovery Manager (RMAN) events.

Correct Answer: A,B,E

Explanation/Reference:
Explanation:
A: Starting with 12c, Oracle has unified all of the auditing types into one single unit called Unified auditing.
You don't have to turn on or off all of the different auidting types individually and as a matter of fact auditing
is enabled by default right out of the box. The AUD$ and FGA$ tables have been replaced with one single
audit trail table. All of the audit data is now stored in Secure Files table thus improving the overall
management aspects of audit data itself.
B: Further the audit data can also be buffered solving most of the common performance related problems
seen on busy environments.
E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label Security,
Database Vault and Real Application Security operations.
Note:
* Benefits of the Unified Audit Trail
The benefits of a unified audit trail are many:
/(B) Overall auditing performance is greatly improved. The default mode that unified audit works is
Queued Write mode. In this mode, the audit records are batched in SGA queue and is persisted in a
periodic way. Because the audit records are written to SGA queue, there is a significant performance
improvement.
/The unified auditing functionality is always enabled and does not depend on the initialization parameters
that were used in previous releases
/(A) The audit records, including records from the SYS audit trail, for all the audited components of your
Oracle Database installation are placed in one location and in one format, rather than your having to look
in different places to find audit trails in varying formats. This consolidated view enables auditors to co-
relate audit information from different components. For example, if an error occurred during an INSERT
statement, standard auditing can indicate the error number and the SQL that was executed. Oracle
Database Vault-specific information can indicate whether this error happened because of a command rule
violation or realm violation. Note that there will be two audit records with a distinct AUDIT_TYPE. With this
unification in place, SYS audit records appear with AUDIT_TYPE set to Standard Audit.
/The management and security of the audit trail is also improved by having it in single audit trail.
/You can create named audit policies that enable you to audit the supported components listed at the
beginning of this section, as well as SYS administrative users. Furthermore, you can build conditions and
exclusions into your policies.
* Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database
using policies and conditions. The new policy based syntax simplifies management of auditing within the
database and provides the ability to accelerate auditing based on conditions.
* The new architecture unifies the existing audit trails into a single audit trail, enabling simplified
management and increasing the security of audit data generated by the database.

Question 113

Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)

A.The DEGREE_OF_PARALLELISM parameter is set to AUTO.
B.You cannot have multiple SQL *Loader data files.
C.If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory and uses it.
D.You can have multiple bad files created when loading in parallel.
E.You can selectively load rows into a table based on a filter.

Question 114

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

Question 115

Which two are prerequisites for performing a flashback transaction? (Choose two.)

A.Flashback Database must be enabled.
B.Undo retention guarantee for the database must be configured.
C.EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
D.Supplemental logging must be enabled.
E.Recycle bin must be enabled for the database.
F.Block change tracking must be enabled tor the database.