网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The INV_HISTORY table is created using the command： SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0 values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））； The following data has been inserted into the INV_HISTORY table ： INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the data belonging to the year 2006 in a single partition and issue the command： SQL> ALTER TABLE inv_history MERGE PARTITIONS FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py； 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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题The INV_HISTORY table is created using the command： SQLCREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0 values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））； The following data has been inserted into the INV_HISTORY table ： INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the data belonging to the year 2006 in a single partition and issue the command： SQL ALTER TABLE inv_history MERGE PARTITIONS FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py； 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.” 相关考题
考题
单选题What is the end result of these commands if they are successful？（） RMAN show retention policy； RMAN configuration parameters for database with db_unique_name ORCL are： CONFIGURE RETENTION POLICY TO REDUNDANCY 1； # default Backup database tag=gold_copy plus archivelog tag=gold_copy delete input； Backup database tag=silver_copy plus archivelog tag=silver_copy delete input；A
Attempting to restore silver_copy will fail.B
Attempting to restore gold_copy will fail.C
Both backups will be available for restore without question.D
Attempting to restore gold_copy may or may not succeed.E
You will not be able to restore either gold_copy or silver_copy.
考题
多选题Which two statements are true regarding the functionality of the remap command in ASMCMD？（）AIt repairs blocks that have read disk I/O errors.BIt checks whether the alias metadata directory and the file directory are linked correctly.CIt repairs blocks by always reading them from the mirror copy and writing them to the original location.DIt reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
考题
多选题The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE） WHERE ename = ’ALLEN’； What are the minimum requirements for the statement to execute successfully？（）AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately
考题
单选题Which statement can be an inference from the output?（）A
The FRA disk group has an asynchronous I/O bottleneckB
The least number of I/Os are performed on the last data file in the listC
The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the listD
The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group
考题
多选题You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)AEven with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.BA resumable statement is suspended only if an out of space error occurs.CWhen a resumable statement is suspended, the transaction that contains the statement is also suspended.DA resumable statement can only be suspended and resumed once during the execution of the statement.EYou can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session
考题
多选题What are the different logging modes available in Oracle Database 11g？（）ANOLOG modeBNOARCHIVELOG modeCLOGGING modeDHOTDATABASE modeEARCHIVELOG mode
考题
多选题Which two statements are true regarding the starting of the database instance using the following command？（） SQLSTARTUP UPGRADEAIt enables all system triggers.BIt allows only SYSDBA connections.CIt ensures that all job queues remain active during the upgrade process.DIt sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
考题
多选题Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)AIt's only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
考题
多选题You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
热门标签
最新试卷