B. The database instance must be shut down to take the backup.C. The database must be in MOUNT state to take the backup.D. The backup consists of blocks that have been formatted.E. The system Change Number (SCN) is the same for all the data files in the backuAnswer:BENEW QUESTION 279What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?A. Optimizer statistics are collected automatically.B. Only timed operating system (OS) statistics and plan execution statistics are collected.C. Automatic Workload Repository (AWR) snapshots are not generated automatically.D. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.Answer:C
Explanation:References: NEW QUESTION 281Examine the parameters:Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing othertransactions to wait on row-level locks.Which two actions would you take to prevent this problem? (Choose two.)
Get answer to your question and much more
NEW QUESTION 283Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.You execute the command:SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLEShr_admin, oe_admin; Which statement is true?C
Get answer to your question and much more
NEW QUESTION 284Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)
Get answer to your question and much more
Explanation:NEW QUESTION 285Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;The Leader of IT Certificationvisit -