Course Hero Logo

B the database instance must be shut down to take the

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 25 - 26 out of 28 pages.

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.)
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
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.)
Explanation:NEW QUESTION 285Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;The Leader of IT Certificationvisit -

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 28 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Abhishek
Tags
Oracle Database, Certleader

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture