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_tb

题目

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.
相似考题

1.You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A、 mount the new disk group in the ASM instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

2. You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A、The rebalancing of the disk group would be stopped.B、The rebalancing of the disk group would be completed as fast as possible.C、The command would result in an error because the value of POWER cannot be 0.D、The rebalancing of the disk group would be completed without affecting the disk group DG3.E、The command would result in an error because the disk groups cannot be manually rebalanced.

3. 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.

4.n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A、 Oracle Migration AssistantB、 Recovery Manager （RMAN）C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

更多“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_tbs”相关问题

  • 第1题：

    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

    正确答案:D

  • 第2题：

    Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）

    • A、 ASMB
    • B、 PMON
    • C、 RBAL
    • D、 SMON

    正确答案:A

  • 第3题：

    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

    • A、Oracle Migration Assistant
    • B、Recovery Manager （RMAN）
    • C、Oracle Data Pump Export and Import
    • D、conventional Oracle Export and Import
    • E、operating system utilities to copy the files to the ASM instance

    正确答案:B

  • 第4题：

    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

    • A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
    • B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
    • C、 RMAN would relocate all the database files to an ASM disk group.
    • D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

    正确答案:C

  • 第5题：

    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

    • A、The tablespace has two data files.
    • B、An error is reported and tablespace creation fails.
    • C、Data files are created with names generated by the instance.
    • D、The tablespace can be extended without specifying the data file.
    • E、Data files belonging to the USERS tablespace cannot be renamed.

    正确答案:C,D

  • 第6题：

    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）

    • A、RMAN would relocate all the database files to an ASM disk group.
    • B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
    • C、RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
    • D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location， defined using OMF

    正确答案:A

  • 第7题：

    单选题
    n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）
    A

     Oracle Migration Assistant

    B

     Recovery Manager （RMAN）

    C

     Oracle Data Pump Export and Import

    D

     conventional Oracle Export and Import

    E

     operating system utilities to copy the files to the ASM instance


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    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 （usder_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.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message：   CREATE TABLESPACE tbsl；  ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199  02199， 00000， “missing DATAFILE/TEMPFILE clause”  *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.  *Action： specify DATAFILE/TEMPFILE clause.   What is the corrective action to create the OMF based tablespace？（）
    A

    A

    B

    B

    C

    C

    D

    D


    正确答案： D
    解析： 暂无解析

  • 第11题：

    You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

    • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
    • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
    • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
    • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
    • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

    正确答案:D

  • 第12题：

    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

    • A、mount the new disk group in the ASM instance
    • B、restart the ASM instance and the production database instance
    • C、register the new disk groups in the production database instance
    • D、restart the ASM instance without restarting the production database instance
    • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

    正确答案:A

  • 第13题：

    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

    • A、Use the DROP DATAFILE command.
    • B、Use the DROP TABLESPACE command.
    • C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
    • D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

    正确答案:B

  • 第14题：

    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）

    • A、Oracle Migration Assistant
    • B、Recovery Manager （RMAN）
    • C、Oracle Data Pump Export and Import
    • D、conventional Oracle Export and Import
    • E、operating system utilities to copy the files to the ASM instance

    正确答案:B

  • 第15题：

    Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）

    • A、ASMB
    • B、PMON
    • C、RBAL
    • D、SMON

    正确答案:A

  • 第16题：

    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 （usder_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.

    正确答案:C

  • 第17题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    多选题
    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）
    A

    The tablespace has two data files.

    B

    An error is reported and tablespace creation fails.

    C

    Data files are created with names generated by the instance.

    D

    The tablespace can be extended without specifying the data file.

    E

    Data files belonging to the USERS tablespace cannot be renamed.


    正确答案： B,D
    解析： 暂无解析

相关内容