The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） 

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

单选题查看答案

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

单选题查看答案

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

多选题查看答案

You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）

单选题查看答案

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）

单选题查看答案

Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables: Which MERGE statement is valid?（）

单选题查看答案

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

单选题查看答案

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which UPDATE statement is valid?（）

单选题查看答案

ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）

多选题查看答案