网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
如何在tablespace里增加数据文件？
参考答案
更多 “ 如何在tablespace里增加数据文件？ ” 相关考题
考题
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
考题
oracle逻辑存储结构正确的是（）A、tablespace--segment--osblock--blockB、tablespace--segment--extent--blockC、tablespace--extent--segment--blockD、tablespace--extent--block–segment
考题
下面关于数据库文件叙述错误的是（）。A、可添加辅助数据文件和事务日志文件B、可删除主数据文件和事务日志文件C、可修改数据文件和事务日志文件大小D、数据文件和事务日志文件默认允许自动增加大小
考题
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？（） A、 TEST_TBS is a small file tablespace.B、 TEST_TBS is a bigfile tablespace （BFT）.C、 TEST_TBS is the default temporary tablespace.D、 TEST_TBS is a dictionary-managed 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 tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
考题
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.
考题
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
考题
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.
考题
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.
考题
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
考题
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.
考题
多选题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
考题
单选题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.
考题
单选题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
考题
多选题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.
考题
单选题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 backup C
alter tablespace DAVE_TBS begin backup D
alter tablespace DAVE_TBS backup begin E
alter tablespace DAVE_TBS backup
考题
问答题如何在已有的选择集里移除或添加对象？
热门标签
最新试卷