[单选]
You need to create a partitioned table to store historical data and you issued the following command：
CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL
（NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3）（ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES
LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’）））
AS SELECT * FROM purchases WHERE time_id < TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；
What is the outcome of the above command？（）

A . It returns an error because the range partitions P1 and P2 should be of the same range.
B . It creates two range partitions （P1， P2）. Within each range partition， it creates monthwise subpartitions.
C . It creates two range partitions of varying range. For data beyond ’1-1-2007，’ it creates partitions with a width of one month each.
D . It returns an error because the number of tablespaces （TBS1，TBS2，TBS3）specified does not match the number of range partitions （P1，P2） specified.

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（） The database must be opened in restricted mode.。 The database must be configured to run in ARCHIVELOG mode.。 The tablespaces are required to be in backup mode before taking the backup.。 The tablespaces are required to be in read-only mode before taking the backu。新规程修订和补充的有关质量术语中指对工程质量有影响，但小于一般质量事故的质量问题是（）。质量事故。质量缺陷。外观质量。质量评定。 Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL> DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（） the datafiles associated with the SYSTEM tablespace。 the datafiles associated to the DATA1 tablespace。 the datafiles associated to the SYSTEM and DATA1 tablespaces。 all the datafiles in the database。 You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMAN>RUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； } NOMOUNT。 MOUNT。 OPEN。 RESTRICTED。简述关节松动技术的实施步骤。

You need to create a partitioned table to store historical data and you issued the following command：
CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL
（NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3）（ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES
LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’）））
AS SELECT * FROM purchases WHERE time_id < TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；
What is the outcome of the above command？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-053题库

相关题目: