Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

A . Only a single partitioning key column can be specified. B . All DML statements must use partition-extended syntax. C . The same physical attributes must be specified for each partition. D . Unique local indexes cannot be created on a system-partitioned table. E . Traditional partition pruning and partitionwise joins are not supported on these tables.

A . Tables with BLOB and TEXT columns cannot be partitioned B . Partitioning allows easier management of smaller data sets for certain queries C . Partitioning allows different columns to be stored in separate files D . The partitioning expression is an integer or function that returns an integer value or NULL value E . Partitioning is only available for those storage engines that implements it natively

A . upon a port state change B . upon receiving a topology change notification C . when transitioning from discarding to forwarding D . when transitioning from forwarding to discarding E . only when changing from listening to discarding F . when CAM resources have been completely used u

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.

A .  Flashback Table can be performed on system tables. B .  Flashback Table operation does not shrink the segments. C .  Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements. D .  Flashback Table operation acquires exclusive data manipulation language （DML） locks.

A . The FLASHBACK TABLE statement will not be written to the alert log file. B . The changes made to the EMP table since the specified time will be undone. C . The EMP table that was dropped by mistake from the database will be restored. D . The FLASHBACK TABLE statement will be executed within a single transaction. E . The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.  F . The list of transactions that have modified the EMP table since the specified time will be displayed.

A . Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current B . Using the statement RESET PERFORMANCE CACHE C . Using the statement FLUSH PERFORMANCE CACHE D . Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current E . Disabling and re-enabling all instruments F . Restarting Mysql

A .  Only a single partitioning key column can be specified. B .  All DML statements must use partition-extended syntax. C .  The same physical attributes must be specified for each partition. D .  Unique local indexes cannot be created on a system-partitioned table. E .  Traditional partition pruning and partitionwise joins are not supported on these tables.

A . The systems must use internal storage for boot purposes.  B . All virtualized ethernet adapters must be numbered below 10.  C . The mobile partition's network and disk access must be virtualized.  D . Each system must be controlled by a different Hardware Management Console (HMC).&e

A . External tables can be updated.  B . External tables are read-only tables.  C . Indexes can be created on external tables.  D . Indexes cannot be created on external tables.

A . It can be used to join a maximum of three tables  B . It can be used to restrict the number of columns used in a NATURAL join  C . It can be used to access data from tables through equijoins as well as nonequijoins  D . It can be used to join tables that have columns with the same name and compatible data type

A . Flashback Table can be performed on system tables. B . Flashback Table operation does not shrink the segments. C . Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements. D . Flashback Table operation acquires exclusive data manipulation language (DML) locks.

A . Create a view on the table. B . Create an index on the table. C . Create a synonym on the table. D . Add a virtual column to the table. E . Update the table using the UPDATE statement. F . Delete rows in the table using the DELETE command

A . Always stop the server prior to the backup B . Stop the server or lock the tables prior to the backup C . Stop the server or lock the databases prior to the backup D . Make a copy of the .frm, .myd, and the .myi files E . Make a copy of the binary log and tablespace file

A . It is not possible to disable the primary key constraint. B . It is possible to have more than one primary key constraint in a single table. C . The primary key constraint can be referred by only one foreign key constraint. D . The primary key constraint can be imposed by combining more than one column. E . The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

A . VLAN B . Virtual Ethernet C . Virtual I/O Server Support D . Capped and Uncapped Partitio

A . Single database partition, single processor   B . Single database partition, multiple processors   C . Multiple database partitions, single processor   D . Multiple database partitions, multiple processor

A . forwarding information base B . adjacency tables C . neighbor tables D . caching tables E . route table

A . UPDATE TABLE B . CREATE CLUSTER C . TRUNCATE TABLE D . ALTER TABLE MOVE E . INSERT INTO···VALUES F . ALTER TABLE···DROP COLUMN G . ALTER TABLE···DROP PARTITION

A .  The systems must use internal storage for boot purposes. B .  All virtualized Ethernet adapters must be numbered below 10. C .  The mobile partition’s network and disk access must be virtualized. D .  Each system must be controlled by a different Hardware Management Console （HMC）.

A . A B . B C . C D . D E . E

A .  LogMiner B .  The DBNEWID utility C .  The DBVERIFY utility D .  The ANALYZE command E .  The RMAN REPORT command F .  The RMAN CROSSCHECK command. G .  The RMAN BLOCKRECOVER command.

A .  The FLASHBACK TABLE statement will not be written to the alert log file. B .  The EMP table that was dropped by mistake from the database will be restored. C .  The changes made to the EMP table since the specified time will be undone. D .  The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. E .  The FLASHBACK TABLE statement will be executed within a single transaction. F .  The list of transactions that have modified the EMP table since the specified time will be displayed.