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

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

相似考题

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

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

4.At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

更多“单选题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 .. commandB sorting ”相关问题

  • 第1题：

    our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

    • A、Oracle Net Manager
    • B、Listener Control utility
    • C、Database Configuration Assistant
    • D、Oracle Net Configuration Assistant

    正确答案:B

  • 第2题：

    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

  • 第3题：

    While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

    • A、configure the database to run in ARCHIVELOG mode
    • B、configure the Flash Recovery Area to enable automatic database backup
    • C、schedule the database backup using DBMS_JOB package after creating the database
    • D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
    • E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

    正确答案:E

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

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

  • 第7题：

    单选题
    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）
    A

     Oracle Net Manager

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

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


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

  • 第9题：

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


    正确答案： 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.


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

  • 第11题：

    单选题
    While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）
    A

    configure the database to run in ARCHIVELOG mode

    B

    configure the Flash Recovery Area to enable automatic database backup

    C

    schedule the database backup using DBMS_JOB package after creating the database

    D

    schedule the database backup using Recovery Manager （RMAN）commands after creating the database

    E

    schedule the database backup using Database Configuration Assistant （DBCA）while creating the database


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

  • 第12题：

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


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

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

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    单选题
    At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）
    A

     Start the database in OPEN mode， and create a new index tablespace.

    B

     Start the database in OPEN mode， and drop the lost index tablespace from the database.

    C

    Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.

    D

     Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.


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

  • 第19题：

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


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

  • 第20题：

    单选题
    You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
    A

    DBMS_STATS 

    B

    DBMS_ALERT 

    C

    DBMS_SPACE 

    D

    DBMS_MONITOR 

    E

    DBMS_SERVER_ALERT

    F

    DBMS_SPACE_ADMIN


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

  • 第21题：

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

  • 第22题：

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

    B

     import the temporary tablespace from the last export

    C

     restore all the data files and temporary files from the last full database backup and perform a recovery

    D

     not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace


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

  • 第23题：

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

  • 第24题：

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

相关内容