单选题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？（）AThe tablespace must be locally managed.BThe 

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

相似考题

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

更多“单选题You issued the following command on the temporary tablespace LMTEMP in your database：   SQLALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）A  The tablespace must be locally managed.B  T”相关问题

  • 第1题：

    To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）  

    • A、 The database will open，and the tablespace automatically comes out of the backup mode.
    • B、 The database will be mounted，and recovery must be performed on the USERS tablespace.
    • C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
    • D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

    正确答案:C

  • 第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 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 NOARCHIVELOG mode and the tablespace is online.
    • C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
    • D、 The database is in ARCHIVELOG mode and the tablespace is offline.
    • E、 The database is in ARCHIVELOG mode and the tablespace is online.

    正确答案:C,D,E

  • 第4题：

    You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）

    • A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
    • B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
    • C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
    • D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

    正确答案:B

  • 第5题：

    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

  • 第6题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

  • 第7题：

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

  • 第8题：

    单选题
    To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）
    A

     The database will open，and the tablespace automatically comes out of the backup mode.

    B

     The database will be mounted，and recovery must be performed on the USERS tablespace.

    C

     The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.

    D

     The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.


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

  • 第9题：

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

  • 第10题：

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

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）

    • A、The command must be issued in MOUNT state.
    • B、The command succeeds only if the data file is offline.
    • C、The command must be issued when the database is in the archivelog mode.
    • D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

    正确答案:D

  • 第14题：

    You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

    • A、run a procedure to check the tablespace space usage
    • B、define the warning threshold for the tablespace at 75% in Database Control
    • C、create a trigger to be executed when tablespace space usage reaches 75%
    • D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
    • E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

    正确答案:B

  • 第15题：

    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.

    正确答案:A

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    单选题
    You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）
    A

    The command must be issued in MOUNT state.

    B

    The command succeeds only if the data file is offline.

    C

    The command must be issued when the database is in the archivelog mode.

    D

    The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.


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

  • 第19题：

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

  • 第20题：

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

  • 第21题：

    单选题
    You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）
    A

    run a procedure to check the tablespace space usage

    B

    define the warning threshold for the tablespace at 75% in Database Control

    C

    create a trigger to be executed when tablespace space usage reaches 75%

    D

    submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals

    E

    define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command


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

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

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

  • 第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
    解析： 暂无解析

相关内容