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题：

Which is a restriction on a list partitioned table？（）

• A、You cannot create global range partitioned indexes on the table. 
• B、The optimizer will not execute partition wise joins on the table’s partitions. 
• C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. 
• D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

第2题：

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

第3题：

第4题：

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.

第5题：

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

第6题：

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

• A、None of the data definition language (DDL) statements are logged in the trace file.
• B、Only DDL commands that resulted in errors are logged in the alert log file.
• C、A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
• D、Only DDL commands that resulted in the creation of new database files are logged.

第7题：

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.

第8题：

Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  

• A、 The VERSIONS BETWEEN clause may be used in DML statements.
• B、 The VERSIONS BETWEEN clause may be used in DDL statements.
• C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
• D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

第9题：

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.

第10题：

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.