ITPub博客

QUESTION 8Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET=0LOG_CHECKPOINT_INTERVAL=0 Which two will be the implications of these values in&n...

QUESTION 7See the Exhibit:  Which statements are true regarding the USERS tablespace? (Choose all that apply.) A. A bitmap is used to record free ext...

QUESTION 6You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the loc...

QUESTION 5You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order: 1. Shut down the instance.2. Execute the ALTER DATABASE ARCHIVELOG command.3. Start up the inst...

QUESTION 4In which of the scenario will the DBA perform recovery? (Choose all that apply.)A. The alert log file is corruptedB. A tablespace is accidentally drop...

QUESTION 3You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_dataDATAFILE SIZE 100MSEGMENT SPACE MANAGEMENT AUTO;Which two&...

QUESTION 2Identify the memory component from which memory may be allocated for:Session memory for the shared server, Buffers for I/O slaves Oracle Database Recovery Manager (RMAN) backup and restore operationsA. Large PoolB. Redo Log BufferC. Database Buffer CacheD....

【每日一练】Oracle OCP认证考试题库解析052-1