On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin.  Which statement is correct？（） A、You can restore the DEPT t

第1题：

Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）

• A、SELECT UNIQUE dept FROM staff
• B、SELECT DISTINCT dept FROM staff
• C、SELECT (dept) UNIQUE FROM staff
• D、SELECT (dept) DISTINCT FROM staff

第2题：

In which scenario do you use the Flashback Database feature？（）

• A、 when a table is dropped and you restore it from the Recycle Bin
• B、 when a user’s schema is dropped and you recover the user’s schema
• C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
• D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

第3题：

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

• A、It releases the storage space used by the table.
• B、It does not release the storage space used by the table.
• C、You can roll back the deletion of rows after the statement executes.
• D、You can NOT roll back the deletion of rows after the statement executes.
• E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
• F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

第4题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）

• A、You cannot roll back this statement.
• B、All pending transactions are committed.
• C、All views based on the DEPT table are deleted.
• D、All indexes based on the DEPT table are dropped.
• E、All data in the table is deleted, and the table structure is also deleted.
• F、All data in the table is deleted, but the structure of the table is retained.
• G、All synonyms based on the DEPT table are deleted.

第5题：

You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

• A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
• B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
• C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
• D、 You cannot shrink the SCOTT.EMP table.

第6题：

On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

• A、You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
• B、You can restore the DEPT table by using the Oracle Flashback Drop feature and a system­generated name will be assigned to the restored table.
• C、You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.
• D、You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

第7题：

You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement：   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2；   What will be the result of executing this statement？（）

• A、 One of the tables is recovered from the Recycle Bin using a First In First Out （FIFO） approach.
• B、 One of the tables is recovered from the Recycle Bin using a Last In First Out （LIFO） approach.
• C、 Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
• D、 None of the tables are recovered from the Recycle Bin， and the statement returns an error.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

• A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
• B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
• C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
• D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

第14题：

In which scenario will you use the Flashback Transaction Query feature？（）

• A、 when you want to restore an important table that is dropped from the Recycle Bin
• B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
• C、when you want to restore a dropped user’s schema
• D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

第15题：

You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

• A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
• B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
• C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
• D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

第16题：

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）

• A、You obtain the results retrieved from the public synonym HR created by the database administrator.
• B、You obtain the results retrieved from the HR table that belongs to your schema.
• C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
• D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
• E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

第17题：

In which scenario will you use the Flashback Version Query feature？（）

• A、 when you want to restore a table that has been dropped from the Recycle Bin
• B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
• C、 when you want to recover the schema of a dropped user
• D、when you want to restore a dropped tablespace

第18题：

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

• A、DROP emp_dept_uv;
• B、DELETE emp_dept_uv;
• C、REMOVE emp_dept_uv;
• D、DROP VIEW emp_dept_uv;
• E、DELETE VIEW emp_dept_uv;
• F、REMOVE VIEW emp_dept_uv;

第19题：

Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）

• A、An error is generated.
• B、You will have two identical tables in the HR schema with different names.
• C、You create a table called employees in the HR schema based on you EMP table.
• D、You create an alternative name for the employees table in the HR schema in your own schema.

第20题：

第21题：

第22题：

第23题：

第24题：