多选题Which two statements about bigfile tablespaces are true？（）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe b

题目内容(请给出正确答案)

多选题

Which two statements about bigfile tablespaces are true？（）

The bigfile tablespace have only one data file.

The segment space management is automatic.

The extent management is dictionary managed.

The database can have only one bigfile tablespace.

The bigfile tablespace can be converted to a smallfile tablespace.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

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

点击查看答案
第2题

多选题Which two statements are true regarding undo tablespaces（）AThe database can have more than one undo tablespace.BThe UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.CUndo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.DAn undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

点击查看答案
第3题

多选题You executed the following command to create a tablespace called SALES_DATA： > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded inbitmapblocks.EThe space utilization description of the data blocks in segments is managed through free lists.MANUAL

点击查看答案
第4题

多选题Which statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data fileCA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block

点击查看答案
第5题

单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）A use automatic extent allocationB disable threshold for the tablespaceC use freelists to manage the free spaceD use automatic segment space managementE create the tablespace as a bigfile tablespaceF use the RESIZE clause while creating the tablespaceG enable AUTOEXTEND for at least one of the data files in the tablespace

点击查看答案
第6题

多选题Which two statements about bigfile tablespaces are true？（）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.

点击查看答案
第7题

多选题Which two statements correctly describe the relation between a data file and the logical database structures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system （OS）blocks

点击查看答案

多选题Which two statements about bigfile tablespaces are true？ （）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe b

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

多选题Which two statements about bigfile tablespaces are true？（）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe b