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 regard

题目

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

1.You issued the following command: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.

2.You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

3. You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace

4. Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

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

  • 第1题：

    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

    • A、 redo logs
    • B、 control file
    • C、 temporary files of temporary tablespace
    • D、 the latest backup of only the damaged data file
    • E、 the latest backup of all the data files In the USERS tablespace

    正确答案:A,B,D

  • 第2题：

    You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  

    • A、 The tablespace must be locally managed.
    • B、 The tablespace must have only one temp file.
    • C、 The tablespace must be made nondefault and offline.
    • D、 The tablespace can remain as the default but must have no active sort operations.

    正确答案:A

  • 第3题：

    You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

    • A、 SQL scripts
    • B、 Recovery Manager （RMAN） script
    • C、 Data Pump
    • D、 SQL*Loader
    • E、 Flashback database

    正确答案:A,C

  • 第4题：

    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

    • A、 undo tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第5题：

    The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

    • A、Add a data file to the SMD tablespace.
    • B、Add a data file to the temporary tablespace associated with the user HR.
    • C、Resize the data file associated with the SMD tablespace to make it larger.
    • D、Alter the data file associated with the SMD tablespace to grow automatically.
    • E、Change the segment space management for the SMD tablespace to automatic

    正确答案:A,C,D

  • 第6题：

    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.

    正确答案:B,D

  • 第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

    正确答案:D,E,G

  • 第8题：

    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

  • 第9题：

    单选题
    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
    A

     undo tablespace

    B

     index tablespace

    C

     read-only tablespace

    D

     temporary tablespace


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

  • 第10题：

    单选题
    Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）
    A

     The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.

    B

     The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.

    C

     The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.

    D

     The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.


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

  • 第11题：

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


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

  • 第12题：

    单选题
    Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）
    A

     DROP TABLESPACE temp1；

    B

     DROP TABLESPACE temp1 INCLUDING CONTENTS；

    C

     DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；

    D

     DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；


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

  • 第13题：

    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

    • A、flash back the database
    • B、perform point-in-time recovery
    • C、perform a full database recovery
    • D、drop and re-create the tablespace
    • E、use Recovery Manager （RMAN） to recover the database

    正确答案:D

  • 第14题：

    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

    • A、This clause is not valid for a temporary or undo tablespace.
    • B、If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
    • C、The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
    • D、The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

    正确答案:A,D

  • 第15题：

    Which statement will NOT create a tablespace？（）

    • A、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；
    • B、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；
    • C、 CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；
    • D、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；

    正确答案:D

  • 第16题：

    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

    • A、This clause is not valid for a temporary or undo tablespace.
    • B、If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
    • C、The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
    • D、The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.

    正确答案:A,D

  • 第17题：

    While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

    • A、the CREATE TABLE .. command
    • B、sorting of the SYSTEM tablespace’s data
    • C、sorting of data required by recursive SQL statements
    • D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
    • E、sorting of data if the users have not been allocated temporary tablespace explicitly
    • F、sorting of data if the users have been allocated temporary tablespace explicitly

    正确答案:E

  • 第18题：

    Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

    • A、 DROP TABLESPACE temp1；
    • B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；
    • C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
    • D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

    正确答案:C

  • 第19题：

    The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）

    • A、Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
    • B、Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
    • C、Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
    • D、Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

    正确答案:D

  • 第20题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


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

  • 第21题：

    多选题
    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
    A

    This clause is not valid for a temporary or undo tablespace.

    B

    If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.

    C

    The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.

    D

    The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.


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

  • 第22题：

    单选题
    You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）
    A

    The tablespace must be locally managed.

    B

    The tablespace must have only one temp file.

    C

    The tablespace must be made nondefault and offline.

    D

    The tablespace can remain as the default but must have no active sort operations.


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

  • 第23题：

    单选题
    Which statement will NOT create a tablespace？（）
    A

     CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；

    B

     CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；

    C

     CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；

    D

     CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；


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

相关内容