Category «1Z0-040»

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 …

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 …

In which three situations would you perform a compressed backup? (Choose three.)

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.) A.Your database includes a large number of BFILEs. B.You are making image copies, and you have not enabled tablespace compression. C.You are backing up to tape and your tape device performs its won compression. …

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 …

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

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 …

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 …

Which four statements regarding the Clone Database tool are correct? (Choose four.)

Which four statements regarding the Clone Database tool are correct? (Choose four.) A.It clones Oracle databases from release 8.1.7 or later. B.It clones a source database while the database is in NOMOUNT state. C.It clones a source database while the database is in MOUNT state. D.It clones an Oracle database by using Recovery Manager (RMAN). …