1Z0-514 試験問題を無料オンラインアクセス

Which two statements are true regarding the Undo Retention Settings? (Choose two.)

• A.Undo Retention indicates the time period or which uncommitted transaction data is retained.
• B.Undo Retention Indicates the time period for which committed transaction data is retained.
• C.Enabling Retention Guarantee ensures that long running queries and transactions do not fail.
• D.Enabling Retention Guarantee ensures that only long-running Queries do not fail.

Your application has a need to allow managers to see all sales records owned by sales reps in their entire territory, and for the sales reps to see only the sales records they own. What technology should be used to implement this type of security?

• A.Label Security
• B.Advanced Security Option
• C.Data Manger Pack for Enterprise Manger
• D.Database Security option
• E.Audit Vault option

Which two statements are true regarding SQL*Plus? (Choose two.)

• A.It can be used in interactive hut not batch mode for SQL commands.
• B.It has to be installed separately after the Oracle database install installation.
• C.It has commands to perform database administration operations.
• D.Operating system commands can be executed from the SOL *Plus command prompt

View the exhibit below and examine the details entered.

User HR has made some modifications to the data in the HR.EMPLOYEES table. You need to now restore the data in the table to a previous version and use the Enterprise Manager.
From which source dose the operation flash back the table data to the specified time?

• A.undo tablespace
• B.redo logs
• C.flash recovery area
• D.temporary tablespace

Which two statements are true regarding point-in-time recovery? (Choose two.)

• A.It uses only online redo logs.
• B.It uses both archivelog and online redo logs.
• C.It requires the SPFILE.
• D.It requires the control file.