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

题目
单选题
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 opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

2.You work as an administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers in the ABC.com domain have Windows Server 2012 R2 installed. You have logged on to a server， named ABC-SR07， and would like to obtain the IP configurations of a server， named ABC-SR13.Which of the following actions should you take？（）A、You should consider making use of the Winrs.exe command.B、You should consider making use of the Winsat.exe command.C、You should consider making use of the Winpop.exe command.D、You should consider making use of the Dsrm.exe command.

3.You work as an administrator at ABC.com.The ABC.com network consists of a single domain named ABC.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 R2 on a new ABC.com server，you are instructed to add a graphical user interface （GUI） to the server.  You want to achieve this goal from the command prompt. Which of the following actions should you take？（）A、You should consider making use of the dism.exe command.B、You should consider making use of the dsquery.exe command.C、You should consider making use of the dsadd.exe command.D、You should consider making use of the dsrm.exe command.

4. You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

更多“Consider the following command to create a tablespace in you”相关问题

  • 第1题：

    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.

    正确答案:C

  • 第2题：

    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

    • A、The table is moved to the SYSAUX tablespace.
    • B、The table is moved to the SYSTEM tablespace.
    • C、The table is removed from the database permanently.
    • D、The table is renamed and remains in the TBSFD tablespace.

    正确答案:D

  • 第3题：

    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

    • A、DB_CREATE_FILE_DEST 
    • B、DB_CREATE_ONLINE_LOG_1 
    • C、DB_CREATE_ONLINE_LOG_2
    • D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

    正确答案:A

  • 第4题：

    单选题
    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）
    A

    DB_CREATE_FILE_DEST 

    B

    DB_CREATE_ONLINE_LOG_1 

    C

    DB_CREATE_ONLINE_LOG_2

    D

    The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed


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

  • 第5题：

    单选题
    Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）
    A

    It executes successfully and creates an UNDO tablespace in hr_pdb.

    B

    It falls and reports an error because there can be only one undo tablespace in a cdb.

    C

    It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

    D

    It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

    E

    It executes successfully but neither tablespace nor the data file is created.


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

  • 第6题：

    单选题
    You issued the following command：   ALTER TABLE SCOTT.EMP SHRINK SPACE；   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：   ORA-10635： Invalid segment or tablespace type    What could be the reason for the failure of the command？（）
    A

     The tablespace， DATA1， is not read-only.

    B

     The tablespace， DATA1， is not autoextensible.

    C

     The tablespace， DATA1， is not offline.

    D

     The segment space management for the tablespace， DATA1， is manual.


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

  • 第7题：

    多选题
    While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）
    A

    profile

    B

    account lock

    C

    account unlock

    D

    password expire

    E

    quota 10MB on TBS1

    F

    password never expire

    G

    default tablespace TBS1

    H

    quota unlimited on TBS1

    I

    temporary tablespace TEMP

    J

    temporary tablespace SYSTEM


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

  • 第8题：

    单选题
    You opened the encryption wallet and then issued the following command：   SQL>CREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M  ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）；   Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.  What is the outcome？（）
    A

     It creates the table and encrypts the data in it.

    B

     It generates an error because the wallet is closed.

    C

     It creates the table but does not encrypt the data in it.

    D

     It generates an error because the NO SALT option cannot be used with the ENCRYPT option.


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

  • 第9题：

    单选题
    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）
    A

    The table is moved to the SYSAUX tablespace.

    B

    The table is moved to the SYSTEM tablespace.

    C

    The table is removed from the database permanently.

    D

    The table is renamed and remains in the TBSFD tablespace.


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

  • 第10题：

    单选题
    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）
    A

    It will create the tablespace TEMP1 in group G1

    B

    It will create the tablespace TEMP1 in group G3 

    C

    It will not add the tablespace TEMP1 to any group

    D

    It will create the tablespace TEMP1 in the default group

    E

    It will throw an error with message 'specified group is not available

    F

    It will create a new group with a system-generated name and add the tablespace TEMP1 to it.


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

  • 第11题：

    多选题
    You issued the following command：   CREATE GLOBAL TEMPORARY TABLE admin_work_area   （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；   An index is then created on the ADMIN_WORK_AREA temporary table.  Which two statements are true regarding the TBS_T1 tablespace in the above command？（）
    A

    It stores only the temporary table but not its indexes.

    B

    It stores both the temporary table as well as its indexes.

    C

    It must be a nondefault temporary tablespace for the database.

    D

    It can be a default or nondefault temporary tablespace for the database.

    E

    It must be the default temporary tablespace of the user who issues the command.


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    You have created a locally managed tablespace by issuing the following command：        CREATE TABLESPACE data1   DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE        UNLIMITED；   For the DATA1 tablespace， you have set the warning level alert limit to 70 percent.  In which situation will a warning level alert be generated？（）  

    • A、 when 700 KB is used
    • B、 when 700 KB is left as free space
    • C、 when 7MB is used
    • D、 when 7MB is left as free space
    • E、 no alert will be generated because an autoextensible datafile is included in the tablespace

    正确答案:C

  • 第14题：

    You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

    • A、The database automatically determines the extent-sizing policy for the tablespace.
    • B、The segments are automatically shrunk when the contents are removed from them.
    • C、The allocation of extents within the tablespace is managed through the dictionary tables.
    • D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
    • E、The space utilization description of the data blocks in segments is managed through free lists.

    正确答案:A,D

  • 第15题：

    You work as an administrator at ENSUREPASS.com. The ENSUREPASS.com network consists of a single domain named ENSUREPASS.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 on a new ENSUREPASS.com server， you are instructed to add a graphical user interface （GUI） to the server.You want to achieve this goal from the command prompt. Which of the following actions should you take？（）

    • A、You should consider making use of the dism.exe command.
    • B、You should consider making use of the dsquery.exe command
    • C、You should consider making use of the dsadd.exe command
    • D、You should consider making use of the dsrm.exe command

    正确答案:A

  • 第16题：

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


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

  • 第17题：

    单选题
    You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）
    A

    The tablespace TBS1 is full.

    B

    The user is not the owner of the SYSTEM tablespace.

    C

    The user does not have quota on the TBS1 tablespace.

    D

    The user does not have sufficient system privileges to create table in the TBS1 tablespace.

    E

    The user does not have sufficient privileges to create table on the default permanent tablespace.


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

  • 第18题：

    多选题
    The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command：    SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS；    SQL> CREATE TABLESPACE INDEXES DATAFILE   ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m；   After that， you issued the following command to recreate the index：    CREATE UNIQUE INDEX sales_index_pk ON sales （order_id）   PCTFREE 10   INITRANS 2   MAXTRANS 255   TABLESPACE indexes   STORAGE （   INITIAL 1m  NEXT 1m   PCTINCREASE 0   MINEXTENTS 1   MAXEXTENTS 8192  ）   NOLOGGING   PARALLEL（ degree 4）   Which two clauses are responsible for reducing the time for the recreation of the index？（）
    A

    PCTFREE

    B

    MAXTRANS

    C

    PCTINCREASE

    D

    INITIAL

    E

    NOLOGGING

    F

    PARALLEL


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

  • 第19题：

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


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

  • 第20题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第21题：

    单选题
    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）
    A

    It will create the tablespace TEMP1 in group G1.

    B

    It will create the tablespace TEMP1 in group G3.

    C

    It will not add the tablespace TEMP1 to any group.

    D

    It will create the tablespace TEMP1 in the default group.


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

  • 第22题：

    单选题
    You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows：   CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ；   Which statement regarding the above command is correct？（）
    A

     It will create the tablespace TEMP1 in group G1.

    B

     It will create the tablespace TEMP1 in group G3.

    C

     It will not add the tablespace TEMP1 to any group.

    D

     It will create the tablespace TEMP1 in the default group.


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

  • 第23题：

    单选题
    You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）
    A

     The command generates an error.

    B

     The command backs up the tablespace and creates a backup set of size 200 MB

    C

     The command backs up the tablespace and creates two backup sets of size 100 MB each.

    D

     The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.


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

相关内容