tablespace point-in-time recovery is possible only with RMAN.（）A、 TrueB、 False
tablespace point-in-time recovery is possible only with RMAN.（）
- A、 True
- B、 False
相关考题：
Examine these two statements:Which three are true about the MRKT tablespace?() A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.B. The MRKT tablespace may be dropped if it has no contents.C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.D. No more data files can be added to the tablespace.E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
oracle逻辑存储结构正确的是（）A、tablespace--segment--osblock--blockB、tablespace--segment--extent--blockC、tablespace--extent--segment--blockD、tablespace--extent--block–segment
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： SQLALTER 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.
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（） A、 alter tablespace DAVE_TBS backup modeB、 alter tablespace DAVE_TBS start backupC、 alter tablespace DAVE_TBS begin backupD、 alter tablespace DAVE_TBS backup beginE、 alter tablespace DAVE_TBS backup
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 tablespaceB、 index tablespaceC、 read-only tablespaceD、 temporary tablespace
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 tablespacelevel logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.
Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding 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
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；
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）A、 Disable SQL tracing for the APPS tablespace.B、 Disable logging attributes for the APPS tablespace.C、 Modify the tablespace to be a dictionary-managed tablespace.D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
单选题You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）A The index tablespace contains bitmap indexes.B The index tablespace contains more than one data file.C The index tablespace supports only complete recovery.D The index tablespace is not a dictionary-managed tablespace.E There is a dependency relationship between a table and its indexes.
单选题You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）A restore the tablespace from the backup， and then perform an incomplete recoveryB restore the tablespace from the backup， and then apply all the redo informationC restore all the data files in the database， and then perform an incomplete recoveryD restore the tablespace from the backup
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）A alter tablespace DAVE_TBS backup modeB alter tablespace DAVE_TBS start backupC alter tablespace DAVE_TBS begin backupD alter tablespace DAVE_TBS backup beginE alter tablespace DAVE_TBS backup
多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.CThe tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.DThe tablespacelevel logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.
多选题Identify three situations in which you would NOT be able to drop a tablespace. （）Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction
单选题An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）ATEST_TBS is a small file tablespace.BTEST_TBS is a bigfile tablespace (BFT).CTEST_TBS is the default temporary tablespace.DTEST_TBS is a dictionary-managed tablespace.
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A restore the tablespace from the backup； there is no need to apply the redo informationB restore the full database to recover the data up to the point when you performed the backupC restore the tablespace from the backup and then perform a recovery using the backup control fileD restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
单选题Which option is best practice for creating a recovery catalog owner in the catalog database？（）A Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the userD Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
单选题Which option is best practice for creating a recovery catalog owner in the catalog database?（）AGranting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerBAllocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userCCreating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userDAllocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）Arestore the tablespace from the backup; there is no need to apply the redo information Brestore the full database to recover the data up to the point when you performed the backup Crestore the tablespace from the backup， and then perform a recovery using the backup control fileDrestore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
多选题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.
多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.CThe tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.DThe tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
单选题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？（）Arun a procedure to check the tablespace space usageBdefine the warning threshold for the tablespace at 75% in Database ControlCcreate a trigger to be executed when tablespace space usage reaches 75%Dsubmit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsEdefine the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
多选题Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding 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
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）Aalter tablespace DAVE_TBS backup modeBalter tablespace DAVE_TBS start backup Calter tablespace DAVE_TBS begin backup Dalter tablespace DAVE_TBS backup begin Ealter tablespace DAVE_TBS backup
单选题Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）A Disable SQL tracing for the APPS tablespace.B Disable logging attributes for the APPS tablespace.C Modify the tablespace to be a dictionary-managed tablespace.D Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.E Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
多选题Examine these two statements:Which three are true about the MRKT tablespace?（）AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.BThe MRKT tablespace may be dropped if it has no contents.CUsers who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.DNo more data files can be added to the tablespace.EThe relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.