Which statement is true about the fine-grained auditing implemented by this policy?

You have created the following auditing policy: BEGINdmbs_fga.add_policy (object_schema => ‘DNX’,object_name => ‘CUSTOMERS’policy_name => ‘policy_acc_principal’,audit_condition =>NULL,audit_column => ‘ACCOUNT_ID, AMOUNT’,audit_column_opts => DBMS_FGA.ALL_COLUMNS,audit_trail => DBMS_FGA.DB_EXTENDED,statement_types => ‘INSERT, UPDATE’);END; Which statement is true about the fine-grained auditing implemented by this policy? A.An audit record is created for all INSERT and UPDATE statements on either the ACCOUNT_ID or AMOUNT […]

Read More

You need to ensure that the database users should be able to use the various flashback query features in order

You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What should you do? (Choose two.) A.set SQL_TRACE=true B.set UNDO_RETENTION=14400 C.set FAST_START_MTTR_TARGET=240 D.set LOG_CHECKPOINT_INTERVAL=240 E.set DB_FLASHBACK_RETENTION_TARGET=14400 F.issue ALTER DATABASE FLASHBACK ON; command G.set the RETENTION GUARANTEE clause […]

Read More

Which statement regarding the COMPATIBLE parameter is correct?

Which statement regarding the COMPATIBLE parameter is correct? A.It is a dynamic parameter. B.It is an advanced parameter. C.It is a new parameter in Oracle 10g. D.It can have any value between8.0.0 and 10.1.0 in Oracle 10g database. E.After it is set to 10.0.0 or greater and the database is opened, it cannot be set […]

Read More

Which two tasks can you automate while created the database using the DBCA? (Choose two.)

You plant to create a database ‘PROD’ using the Database Configuration Assistant (DBCA).Which two tasks can you automate while created the database using the DBCA? (Choose two.) A.database backups B.user quota increment C.tablespace defragmentation D.gathering optimizer statistics E.data export using Data Pump F.data export using conventional export Explanation:On the DBCA Operations window, select Create a […]

Read More

Which two dynamic performance views would you query to determine the endian format of your platform? (Choose t

Which two dynamic performance views would you query to determine the endian format of your platform? (Choose two.) A.V$DATABASE B.V$INSTANCE C.V$PLATFORM D.V$TABLESPACE E.V$CONTROLFILE F.V$TRANSPORTABLE_PLATFORM Explanation:SQL>SELECT d.PLATFORM_NAME, ENDIAN_FORMATFROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE dWHERE tp.PLATFORM_NAME=d.PLATFORM_NAME;PLATFORM_NAME ENDIAN_FORMAT——————————————- ————– Linux 64-bit for AMD Little Show Answer

Read More

Which three statements regarding the Policy Framework in Enterprise Manager (EM) are correct? (Choose three.)

Which three statements regarding the Policy Framework in Enterprise Manager (EM) are correct? (Choose three.) A.Policies are evaluated automatically by Enterprise Manager. B.Policy violations are prioritized as High, Medium, or Informational by category. C.Policies can be disabled completely, or flagged as ignored, for the specified target. D.Policies are evaluated based on configuration and metrics collected […]

Read More

Select the command that will enable you to do the job.

You want to retain the job entries for the last five days and purge all job entries from the job log that are older than five days. Select the command that will enable you to do the job. A.EXECUTE DBMS_SCHEDULER.PURGE_LOG ( log_history => 5, which_log => ‘JOB_LOG’); B.EXECUTE DBMS_SCHEDULER.PURGE_LOG(); C.EXECUTE DBMS_SCHEDULER.PURGE_LOG ( log_history => 5, […]

Read More

Which three actions are required to configure the Flashback Database? (Choose three.)

Which three actions are required to configure the Flashback Database? (Choose three.) A.set Flash Recovery Area B.enable Flashback logging C.create FLASHBACK tablespace D.create a user called flashoper E.start the database in the ARCHIVELOG mode F.start the database in the NOARCHIVELOG mode Explanation:The requirements for enabling Flashback Database are:* Your database must be running in ARCHIVELOG […]

Read More