What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with t

第1题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

• A、All the related indexes and views are automatically dropped
• B、The flashback drop feature can recover only the table structure
• C、Only the related indexes are dropped whereas views are invalidated
• D、The flashback drop feature can recover both the table structure and its data

第2题：

Identify the logical structure that will never have more than one data segment created for it.（）

• A、external table
• B、partitioned table
• C、partitioned index
• D、nonclustered table
• E、global temporary table

第3题：

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?（）

• A、The partitions can be moved online to new tablespaces.
• B、Global indexes must be rebuilt manually after moving the partitions.
• C、The partitions can be compressed in the same tablespaces.
• D、The partitions can be compressed in the new tablespaces.
• E、Local indexes must be rebuilt manually after moving the partitions.

第4题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

• A、 All the related indexes and views are automatically dropped
• B、 The flashback drop feature can recover only the table structure
• C、 Only the related indexes are dropped whereas views are invalidated
• D、 The flashback drop feature can recover both the table structure and its data

第5题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）

• A、LOCK TABLE emp IN SHARE MODE；
• B、LOCK TABLE emp IN EXCLUSIVE MODE；
• C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
• E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

第6题：

Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）

• A、INDEXES
• B、SKIP_INDEXES_MAINTENANCE
• C、SKIP_UNUSABLE_INDEXES
• D、RESUMABLE
• E、INDEXES_UNUSABLE

第7题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

• A、LOCK TABLE emp IN SHARE MODE;
• B、LOCK TABLE emp IN EXCLUSIVE MODE;
• C、DELETE FROM emp WHERE job=’MANAGER’;
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
• E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）

• A、Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B、All DDL commands are logged in the alert log file.
• C、All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D、Only DDL commands that resulted in the creation of new segments are logged.
• E、All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

第14题：

Which statements are correct regarding indexes？ （）

• A、 When a table is dropped， the corresponding indexes are automatically dropped.
• B、 For each DML operation performed， the corresponding indexes are automatically updated.
• C、 Indexes should be created on columns that are frequently referenced as part of an expression.
• D、 A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.

第15题：

Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?（）

• A、It cannot be done in parallel.
• B、It can be done at the table level or partition level.
• C、It does not require additional storage because the operation is done online.
• D、Local and global indexes are maintained automatically during the operation.

第16题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno；  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session（）

• A、LOCK TABLE emp IN SHARE MODE；
• B、LOCK TABLE emp IN EXCLUSIVE MODE；
• C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
• E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

第17题：

Which three statements are correct about temporary tables？（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

第18题：

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?（）

• A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
• B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
• C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
• D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

第19题：

第20题：

第21题：

第22题：

第23题：