单选题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 usedB when 700 KB is left as free spaceC when 7MB is usedD when 7MB is left as free spaceE no alert will be generated because an autoextensible datafile is included in the tablespace
单选题
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
参考解析
解析：
暂无解析
相关考题：
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.
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 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
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
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 databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database
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.
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.
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 usedB、 when 700 KB is left as free spaceC、 when 7MB is usedD、 when 7MB is left as free spaceE、 no alert will be generated because an autoextensible datafile is included in the tablespace
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；
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.
单选题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 usedB when 700 KB is left as free spaceC when 7MB is usedD when 7MB is left as free spaceE no alert will be generated because an autoextensible datafile is included in the tablespace
单选题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
单选题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？（）Athe CREATE TABLE .. commandBsorting of the SYSTEM tablespace’s dataCsorting of data required by recursive SQL statementsDthe CREATE TABLE .. ORGANIZATION EXTERNAL .. commandEsorting of data if the users have not been allocated temporary tablespace explicitlyFsorting of data if the users have been allocated temporary tablespace explicitly
单选题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.
单选题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?（）AThe DATA1 tablespace is automatically taken out of backup mode when the instance aborts.BIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.CIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.DIf you restart the database, the database will not be opened.
单选题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？（）AUse the DROP DATAFILE command.BUse the DROP TABLESPACE command.CEnsure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.DEnsure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
单选题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（）ASystem monitor （SMON）BProcess monitor （PMON）CMemory manager process （MMAN）DManageability Monitor process （MMON）
单选题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？（）Aflash back the databaseBperform point-in-time recoveryCperform a full database recoveryDdrop and re-create the tablespaceEuse Recovery Manager （RMAN） to recover the database
单选题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？（）AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe PCTTHRESHOLD option must have been specified.
多选题Which two statements are true regarding the MRKT tablespace（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it.
单选题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.
单选题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?（）AYou must have change tracking enabled in your databaseBYour database must be running in NOARCHIVELOG modeCTo back up a tablespace, it must be in backup modeDTo back up a tablespace, it must first be taken offline
单选题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（）ASystem monitor （SMON）BProcess monitor （PMON）CMemory manager process （MMAN）DManageability Monitor process （MMON）
单选题You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）AExtents would be managed by the freelists.BThe segment would be managed by bitmaps.CThe segment would be managed by the freelists.DFree space would be managed by the data dictionary.
单选题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?（）AThe tablespace must be locally managed.BThe tablespace must have only one temp file.CThe tablespace must be made nondefault and offline.DThe 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 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 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 databaseB Your database must be running in NOARCHIVELOG modeC To back up a tablespace，it must be in backup modeD To back up a tablespace，it must first be taken offline
单选题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；