• 单选题 Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）

  标签：OCP 11G认证考试 2022-01-03 01:30

• 多选题 You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）

  标签：OCP 11G认证考试 2022-01-03 00:33

• 多选题 The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs. View the Exhibit. Which two statements about the results of the query shown in the Exhibit are correct?（）

  标签：OCP 11G认证考试 2022-01-03 00:31

• 单选题 You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?（）

  标签：OCP 11G认证考试 2022-01-02 14:33

• 多选题 Which of the following are valid program types for a lightweight job?（）

  标签：OCP 11G认证考试 2021-12-31 20:09

• 单选题 Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）

  标签：OCP 11G认证考试 2021-12-31 20:09

• 单选题 Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

  标签：OCP 11G认证考试 2021-12-31 19:25

• 多选题 Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）

  标签：OCP 11G认证考试 2021-12-31 18:53

• 单选题 After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）

  标签：OCP 11G认证考试 2021-12-31 18:53

• 多选题 You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）

  标签：OCP 11G认证考试 2021-12-31 18:53

• 多选题 Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?（）

  标签：OCP 11G认证考试 2021-12-31 18:44

• 多选题 What happens when you run the SQL Tuning Advisor with limited scope?（）

  标签：OCP 11G认证考试 2021-12-29 07:28

• 多选题 You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）

  标签：OCP 11G认证考试 2021-12-28 18:20

• 多选题 Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）

  标签：OCP 11G认证考试 2021-07-23 01:12

• 多选题 Which three statements are true about persistent configuration?（）

  标签：OCP 11G认证考试 2021-07-23 01:08

免费的网站请分享给朋友吧