多选题Which statements are true regarding SecureFile LOBs?（）AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encrypt

题目
多选题
Which statements are true regarding SecureFile LOBs?（）
A

The amount of undo retained is user controlled.

B

SecureFile LOBs can be used only for nonpartitioned tables.

C

Fragmentation is minimized by using variable-sized chunks dynamically.

D

SecureFile encryption allows for random reads and writes of the encrypted data.

E

It automatically detects duplicate LOB data and conserves space by storing only one copy.

相似考题

1.Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

2.Which statements are true regarding the Query Result Cache？（） A、 It can be set at the system， session， or table level.B、 It is used only across statements in the same session.C、 It can store the results from normal as well as flashback queries.D、 It can store the results of queries based on normal，temporary，and dictionary tables.

3.Which statements are true regarding SecureFile LOBs？（） A、 The amount of undo retained is user controlled.B、 SecureFile LOBs can be used only for nonpartitioned tables.C、 Fragmentation is minimized by using variable-sized chunks dynamically.D、 SecureFile encryption allows for random reads and writes of the encrypted data.E、 It automatically detects duplicate LOB data and conserves space by storing only one copy.

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

参考答案和解析
正确答案： C,A
解析： 暂无解析
更多“多选题Which statements are true regarding SecureFile LOBs?（）AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encrypt”相关问题

  • 第1题：

    Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）

    • A、RAW
    • B、LONG
    • C、VARCHAR
    • D、LONG RAW

    正确答案:B,D

  • 第2题：

    Which two statements regarding a SQL profile are true？（）

    • A、 It is built by Automatic Tuning Optimizer.
    • B、 It cannot be stored persistently in the data dictionary.
    • C、 It can be used by the query optimizer automatically.
    • D、 It can be created manually by using the CREATE PROFILE command.

    正确答案:A,C

  • 第3题：

    Which two statements are true regarding subqueries? （）

    • A、A subquery can retrieve zero or more rows 
    • B、Only two subqueries can be placed atone level 
    • C、A subquery can be used only in SQL query statements 
    • D、A subquery can appear on either side of a comparison operator 
    • E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement 

    正确答案:A,D

  • 第4题：

    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

  • 第5题：

    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 

    正确答案:C,D

  • 第6题：

    单选题
    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）
    A

    It returns space usage of only BasicFile LOB chunks.

    B

    It returns space usage of only SecureFile LOB chunks.

    C

    It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

    D

    It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.


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

  • 第7题：

    多选题
    Which two statements are true regarding subqueries? （）
    A

    A subquery can retrieve zero or more rows

    B

    Only two subqueries can be placed atone level

    C

    A subquery can be used only in SQL query statements

    D

    A subquery can appear on either side of a comparison operator

    E

    There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement


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

  • 第8题：

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


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

  • 第9题：

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

  • 第10题：

    单选题
    Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）
    A

     It cannot be done in parallel.

    B

     It can be done at the table level or partition level.

    C

     It does not require additional storage because the operation is done online.

    D

     Local and global indexes are maintained automatically during the operation.


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

  • 第11题：

    多选题
    Which statements are true regarding the Query Result Cache？（）
    A

    It can be set at the system， session， or table level.

    B

    It is used only across statements in the same session.

    C

    It can store the results from normal as well as flashback queries.

    D

    It can store the results of queries based on normal，temporary，and dictionary tables.


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

  • 第12题：

    多选题
    Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）
    A

    RAW

    B

    LONG

    C

    VARCHAR

    D

    LONG RAW


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

  • 第13题：

    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）

    • A、 It returns space usage of only BasicFile LOB chunks.
    • B、 It returns space usage of only SecureFile LOB chunks.
    • C、 It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
    • D、 It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

    正确答案:B

  • 第14题：

    Which two are true regarding direct-path exports？（）

    • A、Direct-path export is typically faster.
    • B、Direct-path export can be invoked interactively.
    • C、Direct-path export is character set independent.
    • D、Direct-path export bypasses the SQL-command processing layer.
    • E、Direct-path export can be used to export rows containing LOBs and BFILEs.

    正确答案:A,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 statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?（）

    • A、It cannot be done in parallel.
    • B、It can be done at the table level or partition level.
    • C、It does not require additional storage because the operation is done online.
    • D、Local and global indexes are maintained automatically during the operation.

    正确答案:B

  • 第17题：

    多选题
    Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）
    A

    The copy of the datafile created is stored in the RMAN repository.

    B

    The copy of the datafile created can be viewed using the LIST BACKUP command.

    C

    The copy of the datafile created using this COPY command can be placed only on the disk.

    D

    The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

    E

    The copy of the datafile created can be used for recovering the database using the user-managed recovery method.


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

  • 第18题：

    多选题
    Which two statements are true regarding the USING clause in table joins?（）
    A

    It can be used to join a maximum of three tables

    B

    It can be used to restrict the number of columns used in a NATURAL join

    C

    It can be used to access data from tables through equijoins as well as nonequijoins

    D

    It can be used to join tables that have columns with the same name and compatible data types


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

  • 第19题：

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

  • 第20题：

    多选题
    Which two are true regarding direct-path exports？（）
    A

    Direct-path export is typically faster.

    B

    Direct-path export can be invoked interactively.

    C

    Direct-path export is character set independent.

    D

    Direct-path export bypasses the SQL-command processing layer.

    E

    Direct-path export can be used to export rows containing LOBs and BFILEs.


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

  • 第21题：

    多选题
    Which two statements regarding a SQL profile are true？（）
    A

    It is built by Automatic Tuning Optimizer.

    B

    It cannot be stored persistently in the data dictionary.

    C

    It can be used by the query optimizer automatically.

    D

    It can be created manually by using the CREATE PROFILE command.


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

  • 第22题：

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

  • 第23题：

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

相关内容