单项选择题
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：
CREATE TABLESPACE user_tbsp
DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M；
What would be the result of this command？（）
A.It would result in an error because the template cannot be used along with the disk group.
B.It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C.It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
D.It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
相关考题
-
单项选择题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）
A.When a new log group is added， it would have one member in each disk group.
B.When a new log group is added， it would have two members in each disk group.
C.When a new tablespace is added， it would have one data file in each disk group.
D.When a new log file is added， it would have one member spread across the disk groups. -
单项选择题
Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA ADD ALIAS ’+tdgroupA/data/datafile.dbf’ FOR ’+tdgroupA.231.45678’； Which task would be accomplished by the command？（）
A.The command drops the file +tdgroupA·231.45678.
B.The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
C.The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
D.The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
E.The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views. -
单项选择题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）
A.to enable the ASM instance to identify the alert log file
B.to enable the ASM instance to identify the server parameter file
C.to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
D.to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
