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

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

相似考题

1.You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?()A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.

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

3.In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database

4.While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

更多“You have created a locally managed tablespace by issuing the”相关问题

  • 第1题：

    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

  • 第2题：

    While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

    • A、 A primary key must have been created.
    • B、 A mapping table must have been created.
    • C、 An overflow tablespace must have been specified.
    • D、 The PCTTHRESHOLD option must have been specified.

    正确答案:B

  • 第3题：

    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

  • 第4题：

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

  • 第5题：

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

  • 第6题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）
    A

    The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

    C

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

    D

    If you restart the database, the database will not be opened.


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

  • 第7题：

    单选题
    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90  Critical （%）： 95  Which background process is responsible for issuing alerts when the threshold is crossed（）
    A

    System monitor （SMON）

    B

    Process monitor （PMON）

    C

    Memory manager process （MMAN）

    D

    Manageability Monitor process （MMON）


    正确答案： B
    解析： 可管理性监视器进程(MMON)，可执行各种与可管理性相关的后台任务，
    例如： 
    • 每当给定的度量超过其阈值时发出预警 
    • 通过衍生附加进程（MMON 从属进程）获取快照 
    • 捕获近期已做修改的SQL 对象的统计值

  • 第8题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

    A primary key must have been created.

    B

    A mapping table must have been created.

    C

    An overflow tablespace must have been specified.

    D

    The PCTTHRESHOLD option must have been specified.


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

  • 第9题：

    单选题
    While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

     A primary key must have been created.

    B

     A mapping table must have been created.

    C

     An overflow tablespace must have been specified.

    D

     The PCTTHRESHOLD option must have been specified.


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

  • 第10题：

    单选题
    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）
    A

    System monitor （SMON）

    B

    Process monitor （PMON）

    C

    Memory manager process （MMAN）

    D

    Manageability Monitor process （MMON）


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

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


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

  • 第12题：

    单选题
    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.  Which statement about performing user-managed backups in a 24x7 environment is true？（）
    A

     You must have change tracking enabled in your database

    B

     Your database must be running in NOARCHIVELOG mode

    C

     To back up a tablespace，it must be in backup mode

    D

     To back up a tablespace，it must first be taken offline


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

  • 第13题：

    You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）

    • A、Extents would be managed by the freelists.
    • B、The segment would be managed by bitmaps.
    • C、The segment would be managed by the freelists.
    • D、Free space would be managed by the data dictionary.

    正确答案:B

  • 第14题：

    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

  • 第15题：

    You are employed as the exchange administrator at company.com.the company.com network contains an exchange 2010 organization.Company.com has its headquarters in stock holm where you are located.During the course of the week you receive an instruction from the cio to make sure those messages in the inbox folder of a company.com employee named kara lang is moved to a custom folder as soon as it reaches 51 days.What should you do？（）

    • A、you should first consider having a new mail folder created using microsoft office outlook. There after a journal rule should be created.
    • B、you should first consider having a new mail folder created using microsoft office outlook.There after use the inbox managed default folder to run the managed content settings wizard.
    • C、you should first consider having a managed custom folder created.thereafter a transport rule should be created.
    • D、you should first consider having a managed custom folder created.There after use the inbox managed default folder to run the managed content settings wizard.

    正确答案:D

  • 第16题：

    单选题
    In which scenario will you perform a cancel-based recovery？（）
    A

     when a tablespace is dropped and you have only RMAN-based backup of the database

    B

     when a table is dropped and stored in the Recycle Bin

    C

     when you are required to recover an existing table to its previous state

    D

     when a tablespace is dropped and you have only a user-managed full backup of the database


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

  • 第17题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
    A

     The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.

    C

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.

    D

     If you restart the database，the database will not be opened.


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

  • 第18题：

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

  • 第19题：

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


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

  • 第20题：

    多选题
    Which two statements are true regarding the MRKT tablespace（）
    A

    No more data files can be added to the tablespace.

    B

    Segment space is managed by free lists in the tablespace.

    C

    A user created without being assigned a default tablespace uses this tablespace.

    D

    The tablespace can be dropped with the current setting with segments present in it.


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

  • 第21题：

    单选题
    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
    A

    You must have change tracking enabled in your database

    B

    Your database must be running in NOARCHIVELOG mode

    C

    To back up a tablespace, it must be in backup mode

    D

    To back up a tablespace, it must first be taken offline


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

  • 第22题：

    单选题
    You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）
    A

    Extents would be managed by the freelists.

    B

    The segment would be managed by bitmaps.

    C

    The segment would be managed by the freelists.

    D

    Free space would be managed by the data dictionary.


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

  • 第23题：

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

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


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

相关内容