多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is

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

相似考题

1.Which three statements are true about Oracle Data Pump export and import operations?()A. You can detach from a data pump export job and reattach later.B. Data pump uses parallel execution server processes to implement parallel import.C. Data pump import requires the import file to be in a directory owned by the oracle owner.D. The master table is the last object to be exported by the data pump.E. You can detach from a data pump import job and reattach later.

2.The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A、 The Oracle database will not perform block checking for any of the data blocks.B、 The Oracle database will perform block checking for the default permanent tablespace only. C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

3.The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?（）A、The Oracle database will perform block checking for the index blocks only B、The Oracle database will not perform block checking for any of the data blocks C、The Oracle database will perform block checking for the default permanent tablespace only D、The Oracle database will perform block checking for the data blocks in all user tablespaces E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle

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

更多“多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is”相关问题

  • 第1题：

    Which three statements about subqueries are true? （）

    • A、A main query can have more than one subquery.
    • B、A subquery can have more than one main query.
    • C、The subquery and main query must retrieve data from the same table.
    • D、The subquery and main query can retrieve data from different tables.
    • E、Only one column or expression can be compared between the subquery and main query.
    • F、Multiple columns or expression can be compared between the subquery and main query.

    正确答案:A,C,E

  • 第2题：

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

    正确答案:A,C,D

  • 第3题：

    Which two statements are true about simple views？（）

    • A、Views can be created as read only.
    • B、Views are data segments like tables.
    • C、Views can be created on the basis of more than one table.
    • D、Data manipulation language （DML） operations cannot be performed on views.

    正确答案:A,C

  • 第4题：

    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

    • A、Only one LONG column can be used per table 
    • B、A TIMESTAMP data type column stores only time values with fractional seconds 
    • C、The BLOB data type column is used to store binary data in an operating system file 
    • D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
    • E、The value for a CHAR data type column is blank-padded to the maximum defined column width

    正确答案:A,D,E

  • 第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.

    正确答案:A,C,D

  • 第6题：

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


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

  • 第7题：

    多选题
    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）
    A

    Only one LONG column can be used per table

    B

    A TIMESTAMP data type column stores only time values with fractional seconds

    C

    The BLOB data type column is used to store binary data in an operating system file

    D

    The minimum column width that can be specified for a VARCHAR2 data type column is one

    E

    The value for a CHAR data type column is blank-padded to the maximum defined column width


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

  • 第8题：

    多选题
    Which three statements are true about Oracle Data Pump export and import operations?（）
    A

    You can detach from a data pump export job and reattach later.

    B

    Data pump uses parallel execution server processes to implement parallel import.

    C

    Data pump import requires the import file to be in a directory owned by the oracle owner.

    D

    The master table is the last object to be exported by the data pump.

    E

    You can detach from a data pump import job and reattach later.


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

  • 第9题：

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


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

  • 第10题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）
    A

     The Oracle database will not perform block checking for any of the data blocks.

    B

     The Oracle database will perform block checking for the default permanent tablespace only. 

    C

     The Oracle database will perform block checking for the data blocks in all user tablespaces.

    D

     The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

    E

     The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.


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

  • 第11题：

    多选题
    Which three statements are true regarding single-row functions？（）
    A

    They can accept only one argument.

    B

    They can be nested up to only two levels.

    C

    They can return multiple values of more than one data type.

    D

    They can be used in SELECT， WHERE， and ORDER BY clauses.

    E

    They can modify the data type of the argument that is referenced.

    F

    They can accept a column name， expression， variable name， or a user-supplied constant as arguments.


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

  • 第12题：

    多选题
    SQ L*Loader is a utility that can perform which two tasks？（）
    A

    Load data from a disk， tape， or named pipes.

    B

    Load data into an Oracle database using DML statements.

    C

    Extract， reorganize， and insert data within an Oracle database.

    D

    Load data from external files into tables in an Oracle database.

    E

    Load data into an Oracle database using operating system commands.

    F

    Load data directly from a non-Oracle database to an Oracle database.


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

  • 第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题：

    Which three statements are true about Oracle Data Pump export and import operations?（）

    • A、You can detach from a data pump export job and reattach later.
    • B、Data pump uses parallel execution server processes to implement parallel import.
    • C、Data pump import requires the import file to be in a directory owned by the oracle owner.
    • D、The master table is the last object to be exported by the data pump.
    • E、You can detach from a data pump import job and reattach later.

    正确答案:A,B,D

  • 第15题：

    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

  • 第16题：

    The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

    • A、The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
    • B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
    • C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
    • D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
    • E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent

    正确答案:A

  • 第17题：

    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.

    正确答案:A,C,D

  • 第18题：

    多选题
    Which three statements about subqueries are true? （）
    A

    A main query can have more than one subquery.

    B

    A subquery can have more than one main query.

    C

    The subquery and main query must retrieve data from the same table.

    D

    The subquery and main query can retrieve data from different tables.

    E

    Only one column or expression can be compared between the subquery and main query.

    F

    Multiple columns or expression can be compared between the subquery and main query.


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

  • 第19题：

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


    正确答案： A,C,D
    解析： A答案：每个段包含一个或多个区，正确。 
    B答案：一个数据文件只能属于一个表空间，故错误。 
    C答案：Oracle data block是最小的I/O单位，正确 
    D答案：可以是不同的块大小，需要指名非标准块的位置。 
    E答案：每个数据库里面的数据库对应一个或多个操作系统块，故E错误。

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements correctly describe the relation between a data file and the logical database structures（）
    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


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

  • 第24题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）
    A

    The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.

    B

    DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

    C

    The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.

    D

    The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.

    E

    The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent


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

相关内容