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

更多“多选题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题

Which statements are true about logical structures of the Oracle database（）A、Each segment contains one or more extents.B、Multiple tablespaces can share a single data fileC、A data block is the smallest unit of input/output （I/O） in data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one operating system block

点击查看答案
第2题

You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）A、The database automatically determines the extent-sizing policy for the tablespace.B、The segments are automatically shrunk when the contents are removed from them.C、The allocation of extents within the tablespace is managed through the dictionary tables.D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.E、The space utilization description of the data blocks in segments is managed through free lists.

点击查看答案
第3题

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

点击查看答案
第4题

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A、One tablespace has only one datafileB、Many tablespaces can share one datafileC、One tablespace can have many datafilesD、One datafile can contain many tablespaces

点击查看答案
第5题

Which three statements are true regarding the logical structure of the Oracle database？（）A、Each segment contains one or more extents.B、Multiple tablespaces can share single data file.C、A data block is the smallest unit of I/O for data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one OS block.

点击查看答案
第6题

Which three statements are true about logical structures of the Oracle database（）A、Each segment contains one or more extents.B、Multiple tablespaces can share a single data file.C、A data block is the smallest unit of input/output （I/O） in data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one operating system block.

点击查看答案
第7题

多选题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？（）Aset PCTFREE and PCTUSED to 50Bspecify extent allocation as UniformCspecify extent allocation as AutomaticDcreate the tablespace as bigfile tablespaceEcreate the tablespace as smallfile tablespaceFset segment space management to AutomaticGuse the RESIZE clause while creating the tablespace

点击查看答案

多选题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？ （）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

更多“多选题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”相关问题