多选题Which  statements are true regarding a tablespace()AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned s

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


相似考题
更多“多选题Which  statements are true regarding a tablespace()AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned s”相关问题
  • 第1题:

    Which statement describes a security zone?()

    • A、A security zone can contain one or more interfaces.
    • B、A security zone can contain interfaces in multiple routing instances.
    • C、A security zone must contain two or more interfaces.
    • D、A security zone must contain bridge groups.

    正确答案:A

  • 第2题:

    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

  • 第3题:

    What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()

    • A、It can contain parameters with distinct values for each distance.
    • B、It can contain only parameters with identical values for each instance.
    • C、It must contain an IFILE parameter for each instance’s individual parameter file.
    • D、It must be located in the default location for the primary instance’s parameter file.

    正确答案:A

  • 第4题:

    Which two statements are true regarding the usage of the SQL*Loader utility()

    • A、You can load data into multiple tables during the same load session.
    • B、You can load data from multiple files to a table during the same load session.
    • C、You cannot perform selective data loading based on the values available in the records.
    • D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
    • E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

    正确答案:A,B

  • 第5题:

    单选题
    Which statement about windows and blocks is true?()
    A

    Transaction management is block-oriented rather than window-oriented. 

    B

    Forms automatically navigates to an item located in an activated window. 

    C

    A window may contain multiple blocks, but each block can only span one window. 

    D

    A window can contain multiple canvases, and an item can be located on multiple canvases. 


    正确答案: A
    解析: 暂无解析

  • 第6题:

    多选题
    Which two statements are true regarding a PL/SQL package body?()
    A

    It cannot be created without a package specification.

    B

    It cannot invoke subprograms defined in other packages.

    C

    It can contain only the subprograms defined in the package specification.

    D

    It can be changed and recompiled without making the package specification invalid.


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

  • 第7题:

    单选题
    Which statement describes a security zone?()
    A

    A security zone can contain one or more interfaces.

    B

    A security zone can contain interfaces in multiple routing instances.

    C

    A security zone must contain two or more interfaces.

    D

    A security zone must contain bridge groups.


    正确答案: C
    解析: 暂无解析

  • 第8题:

    多选题
    Which two characteristics are true of IVRs? ()
    A

    They are known as fabric routing

    B

    They cannot span multiple switches

    C

    Their connectivity is supported by Layer 2

    D

    They enable devices in different VSAN fabrics to communicate

    E

    They require that multiple switch fabrics be merged before they can function


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

  • 第9题:

    多选题
    Which two statements are true regarding the WebLogic domain?()
    A

    A WebLogic domain can have more than one Administration server.

    B

    A WebLogic domain has at least one WebLogic server.

    C

    A WebLogic domain can have at the most one cluster.

    D

    A WebLogic domain can cross multiple physical machines.

    E

    Each WebLogic domain is associated with a different Node Manager.


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

  • 第10题:

    多选题
    Which two statements are true regarding single row functions?()
    A

    They accept only a single argument

    B

    They can be nested only to two levels

    C

    Arguments can only be column values or constants

    D

    They always return a single result row for every row of a queried table

    E

    They can return a data type value different from the one that is referenced


    正确答案: E,B
    解析: 暂无解析

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

    多选题
    Which of the following are TRUE about a store archive?()
    A

    It is an XML file containing store data assets

    B

    It uses the same file format as a ZIP file

    C

    It contains file assets to create a store or site

    D

    It can easily be copied from one machine to another

    E

    It can contain WebSphere Commerce instance configuration information


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

  • 第13题:

    Which  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

  • 第14题:

    Which two statements are true regarding the WebLogic domain?()

    • A、A WebLogic domain can have more than one Administration server.
    • B、A WebLogic domain has at least one WebLogic server.
    • C、A WebLogic domain can have at the most one cluster.  
    • D、A WebLogic domain can cross multiple physical machines.  
    • E、Each WebLogic domain is associated with a different Node Manager.

    正确答案:B,D

  • 第15题:

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

  • 第16题:

    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

  • 第17题:

    单选题
    What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()
    A

    It can contain parameters with distinct values for each distance.

    B

    It can contain only parameters with identical values for each instance.

    C

    It must contain an IFILE parameter for each instance’s individual parameter file.

    D

    It must be located in the default location for the primary instance’s parameter file.


    正确答案: C
    解析: 暂无解析

  • 第18题:

    多选题
    Which two statements are true regarding the USING and ON clauses in table joins?()
    A

    Both USING and ON clauses can be used for equijoins and nonequijoins

    B

    Amaximum of one pair of columns can be joined between two tables using the ON clause

    C

    The ON clause can be used to join tables on columns that have different names but compatible data types

    D

    The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause


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

  • 第19题:

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


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

  • 第20题:

    多选题
    Which two statements are true regarding the usage of the SQL*Loader utility()
    A

    You can load data into multiple tables during the same load session.

    B

    You can load data from multiple files to a table during the same load session.

    C

    You cannot perform selective data loading based on the values available in the records.

    D

    You can use an export file generated by the EXPDP utility as an input data file to load the data.

    E

    You can load data only if the input file is available on the disk and tape but not in a named pipes.


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

  • 第21题:

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

  • 第22题:

    多选题
    Which three statements are true regarding subqueries?()
    A

    Subqueries can contain GROUP BY and ORDER BY clauses

    B

    Main query and subquery can get data from different tables

    C

    Main query and subquery must get data from the same tables

    D

    Subqueries can contain ORDER BY but not the GROUP BY clause

    E

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

    F

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


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

  • 第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
    解析: 暂无解析