Performance Tuning - Question 038

Which of these is an accurate implementation of manual striping?

A. CREATE TABLESPACE APP_DATADATAFILE 'D:\ORACLE\ORADATA\OR9I\APP_DATA01.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA02.DBF' SIZE 10 M,
'F:\ORACLE\ORADATA\OR9I\APP_DATA03.DBF' SIZE 10 M,
'G:\ORACLE\ORADATA\OR9I\APP_DATA04.DBF' SIZE 10 M/

B . CREATE TABLESPACE APP_DATADATAFILE 'E:\ORACLE\ORADATA\OR9I\APP_DATA01.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA02.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA03.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA04.DBF' SIZE 10 M/

C . CREATE TABLESPACE APP_DATADATAFILE 'D:\ORACLE\ORADATA\OR9I\APP_DATA01.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA02.DBF' SIZE 10 M,
'D:\ORACLE\ORADATA\OR9I\APP_DATA03.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA04.DBF' SIZE 10 M
USING MANUAL STRIPING/

Explanation:

Answer A: The CREATE TABLESPACE command specifically creates datafiles of equal size on four separate disk devices. This is a good example of manual striping. CREATE TABLESPACE APP_DATADATAFILE 'E:\ORACLE\ORADATA\OR9I\APP_DATA01.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA02.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA03.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA04.DBF' SIZE 10 M/
is incorrect because all four data files are created on the same device.
CREATE TABLESPACE APP_DATADATAFILE 'D:\ORACLE\ORADATA\OR9I\APP_DATA01.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA02.DBF' SIZE 10 M,
'D:\ORACLE\ORADATA\OR9I\APP_DATA03.DBF' SIZE 10 M,
'E:\ORACLE\ORADATA\OR9I\APP_DATA04.DBF' SIZE 10 M
USING MANUAL STRIPINGis incorrect because the "MANUAL STRIPING" clause is invalid.