單項(xiàng)選擇題

The INV_HISTORY table is created using the command:

You would like to store the data belonging to the year 2006 in a single partition and issue the command:

What would be the outcome of this command? （）

A. It executes successfully, and the transition point is set to '1-apr-2006'.
B. It executes successfully, and the transition point is set to '15-apr-2006'.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values stored in the table.

你可能感興趣的試題

單項(xiàng)選擇題

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects.
Which option must you use to perform TSPITR and preserve the object?（）

A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

單項(xiàng)選擇題

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:

What is the outcome of the above commands?（）

A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
D. They produce an error because you need to connect to the target database to execute this packaged procedure.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

The INV_HISTORY table is created using the command: You would like to store the data belonging to the year 2006 in a single partition and issue the command: What would be the outcome of this command? （）

你可能感興趣的試題

The INV_HISTORY table is created using the command:

You would like to store the data belonging to the year 2006 in a single partition and issue the command:

What would be the outcome of this command? （）