单项选择题
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.)（）
单项选择题 Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
单项选择题 You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）