niusouti.com

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

题目
多选题
Which two statements are true regarding 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.

相似考题

1.You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.

2.Which two statements correctly describe the relation between a data file and the logical databasestructures（）A、An extent cannot spread across data files.B、A segment cannot spread across data files.C、A data file can belong to only one tablespace.D、A data file can have only one segment created in it.E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.

3. The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

4.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.

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

  • 第1题：

    Which two statements are true regarding undo tablespaces（）

    • A、The database can have more than one undo tablespace.
    • B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
    • C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
    • D、An 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.

    正确答案:A,C

  • 第2题：

    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.

    正确答案:A,D

  • 第3题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第4题：

    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.

    正确答案:A,D

  • 第5题：

    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

    正确答案:A,C

  • 第6题：

    Which two statements are true regarding a tablespace（）

    • A、It can span multiple databases.
    • B、It can consist of multiple data files.
    • C、It can contain blocks of different sizes.
    • D、It can contain segments of different sizes.
    • E、It can contain a part of a nonpartitioned segment.

    正确答案:B,D

  • 第7题：

    多选题
    The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）
    A

    Add a data file to the SMD tablespace.

    B

    Add a data file to the temporary tablespace associated with the user HR.

    C

    Resize the data file associated with the SMD tablespace to make it larger.

    D

    Alter the data file associated with the SMD tablespace to grow automatically.

    E

    Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.


    正确答案： C,E
    解析： 暂无解析

  • 第8题：

    多选题
    Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）
    A

    Oracle Managed Files are used for this instance.

    B

    The USER_DATA tablespace is managed using FET$/UET$ tables.

    C

    The COMPATIBLE initialization parameter must be 9.0.0 or higher.

    D

    Space within segments in the USER_DATA tablespace is managed with freelists.


    正确答案： B,A
    解析： 暂无解析

  • 第9题：

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


    正确答案： E,C
    解析： 暂无解析

  • 第10题：

    多选题
    The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command：  SQL> ALTER TABLESPACE hi_data BEGIN BACKUP；   Which two statements are true in this scenario？（）
    A

    No transaction on the tablespace is allowed but you can perform queries.

    B

    The tablespace will automatically come out of backup mode when the file copy is complete.

    C

    The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.

    D

    The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.


    正确答案： A,C
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements are true regarding a tablespace（）
    A

    It can span multiple databases.

    B

    It can consist of multiple data files.

    C

    It can contain blocks of different sizes.

    D

    It can contain segments of different sizes.

    E

    It can contain a part of a nonpartitioned segment.


    正确答案： E,C
    解析： 暂无解析

  • 第12题：

    多选题
    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）
    A

    The tablespace has two data files.

    B

    An error is reported and tablespace creation fails.

    C

    Data files are created with names generated by the instance.

    D

    The tablespace can be extended without specifying the data file.

    E

    Data files belonging to the USERS tablespace cannot be renamed.


    正确答案： B,D
    解析： 暂无解析

  • 第13题：

    Which two statements about bigfile tablespaces are true？ （）

    • A、The bigfile tablespace have only one data file.
    • B、The segment space management is automatic.
    • C、The extent management is dictionary managed.
    • D、The database can have only one bigfile tablespace.
    • E、The bigfile tablespace can be converted to a smallfile tablespace.

    正确答案:A,B

  • 第14题：

    Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

    • A、 Drop and re-create the inbox.
    • B、 Coalesce the ORDERS_IND index.
    • C、 Coalesce the INDEXES tablespace.
    • D、 Drop and re-create the ORDERS table.
    • E、 Rebuild the index online and move it to another tablespace.

    正确答案:B,E

  • 第15题：

    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.

    正确答案:A,D

  • 第16题：

    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

    • A、The tablespace has two data files.
    • B、An error is reported and tablespace creation fails.
    • C、Data files are created with names generated by the instance.
    • D、The tablespace can be extended without specifying the data file.
    • E、Data files belonging to the USERS tablespace cannot be renamed.

    正确答案:C,D

  • 第17题：

    Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）

    • A、Oracle Managed Files are used for this instance.
    • B、The USER_DATA tablespace is managed using FET$/UET$ tables.
    • C、The COMPATIBLE initialization parameter must be 9.0.0 or higher.
    • D、Space within segments in the USER_DATA tablespace is managed with freelists.

    正确答案:A,C

  • 第18题：

    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.

    正确答案:B,C,D

  • 第19题：

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


    正确答案： B,A
    解析： 暂无解析

  • 第20题：

    多选题
    You issued the following command：   CREATE GLOBAL TEMPORARY TABLE admin_work_area   （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；   An index is then created on the ADMIN_WORK_AREA temporary table.  Which two statements are true regarding the TBS_T1 tablespace in the above command？（）
    A

    It stores only the temporary table but not its indexes.

    B

    It stores both the temporary table as well as its indexes.

    C

    It must be a nondefault temporary tablespace for the database.

    D

    It can be a default or nondefault temporary tablespace for the database.

    E

    It must be the default temporary tablespace of the user who issues the command.


    正确答案： E,C
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An 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.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

  • 第22题：

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

    E

    The space utilization description of the data blocks in segments is managed through free lists.MANUAL


    正确答案： E,C
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements about bigfile tablespaces are true？ （）
    A

    The bigfile tablespace have only one data file.

    B

    The segment space management is automatic.

    C

    The extent management is dictionary managed.

    D

    The database can have only one bigfile tablespace.

    E

    The bigfile tablespace can be converted to a smallfile tablespace.


    正确答案： D,B
    解析： 暂无解析

相关内容