多选题Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）AThe procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.BThe pr

题目
多选题
Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）
A

The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

B

The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

C

All the components may be moved into SYSAUX tablespace.

D

All the components may be moved from the SYSAUX tablespace.

相似考题

1.Which two statements about the SQL Management Base (SMB) are true?()A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

2.Which statement is true？（）  A、 A flow layout can be used to position a component that should resize horizontally when the  container is resized.B、 A grid layout can be used to position a component tat should maintain a constant size even when  the container is resized.C、 A border layout can be used to position component that should maintain a constant size even when  the container is resized.D、 The grid bag layout can be used to give a grid-like layout which differs from the normal grid in that individual rows and columns can have unique sizes.E、 If two components are placed in the same column of a grid bag layout， and one component resizes horizontally， then the other component must resize horizontally.

3.Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)A、It contains only SQL profiles generated by SQL Tuning Advisor.B、It stores plans generated by the optimizer using a stored outline.C、It is part of the data dictionary and stored in the SYSAUX tablespace.D、It is part of the data dictionary and stored in the SYSTEM tablespace.E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

4.Which two statements about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true？（）A、You may use Cisco Network Assistant to set up the initial configurationB、You must use CLI for initial configurationC、You may use either CLI or CAN for configurationD、You may make a direct connection to the PC from any point on the switchE、You may only make a direct connection from the port with the flashing green LED to the PC

更多“多选题Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）AThe procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.BThe pr”相关问题

  • 第1题：

    Which two statements are true about the Automatic Workload Repository （AWR）（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR contains systemwide tracing and logging information.
    • C、The snapshots collected by the AWR are accessible through data dictionary views.
    • D、The snapshots collected by the AWR are used by self-tuning components in the database.

    正确答案:C,D

  • 第2题：

    Which two statements are true regarding Oracle Data Pump（）

    • A、EXPDP and IMPDP are the client components of Oracle Data Pump.
    • B、DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
    • C、Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
    • D、Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
    • E、EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

    正确答案:A,B

  • 第3题：

    Which two statements about sequences are true? （）

    • A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
    • B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
    • C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
    • D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
    • E、If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
    • F、You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

    正确答案:B,C

  • 第4题：

    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

  • 第5题：

    多选题
    Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）
    A

    A CHECK constraint is created on the OID column.

    B

    A NOT NULL constraint is created on the OID column.

    C

    The ORDERS table is the only object created in the USERS tablespace.

    D

    The ORDERS table and a unique index are created in the USERS tablespace.

    E

    The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.


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

  • 第6题：

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

  • 第7题：

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

  • 第8题：

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

  • 第9题：

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

    A single row subquery can retrieve data from only one table.

    B

    A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

    C

    A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.

    D

    A single row subquery can retrieve data from more than one table.

    E

    A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    F

    A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.


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

  • 第10题：

    多选题
    Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）
    A

    The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

    B

    The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

    C

    All the components may be moved into SYSAUX tablespace.

    D

    All the components may be moved from the SYSAUX tablespace.


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

  • 第11题：

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

  • 第12题：

    多选题
    Which two statements are true regarding Oracle Data Pump（）
    A

    EXPDP and IMPDP are the client components of Oracle Data Pump.

    B

    DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

    C

    Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

    D

    Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.

    E

    EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.


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

  • 第13题：

    Which two statements about subqueries are true?（）

    • A、A single row subquery can retrieve data from only one table.
    • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
    • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
    • D、A single row subquery can retrieve data from more than one table.
    • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
    • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    正确答案:B,D

  • 第14题：

    Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）

    • A、The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
    • B、The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
    • C、All the components may be moved into SYSAUX tablespace.
    • D、All the components may be moved from the SYSAUX tablespace.

    正确答案:A,B

  • 第15题：

    Which two statements about subqueries are true? （）

    • A、A single row subquery can retrieve data from only one table.
    • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
    • C、A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.
    • D、A single row subquery can retrieve data from more than one table.
    • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
    • F、A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.

    正确答案:D,F

  • 第16题：

    多选题
    Which two statements about the SQL Management Base (SMB) are true?（）
    A

    It contains only SQL profiles generated by SQL Tuning Advisor.

    B

    It stores plans generated by the optimizer using a stored outline.

    C

    It is part of the data dictionary and stored in the SYSAUX tablespace.

    D

    It is part of the data dictionary and stored in the SYSTEM tablespace.

    E

    It contains the statement log, the plan history, plan baselines, and SQL profiles.


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

  • 第17题：

    多选题
    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)
    A

    It contains only SQL profiles generated by SQL Tuning Advisor.

    B

    It stores plans generated by the optimizer using a stored outline.

    C

    It is part of the data dictionary and stored in the SYSAUX tablespace.

    D

    It is part of the data dictionary and stored in the SYSTEM tablespace.

    E

    It contains the statement log, the plan history, plan baselines, and SQL profiles.


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

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


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

  • 第19题：

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

    A single row subquery can retrieve data from only one table.

    B

    A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

    C

    A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.

    D

    A single row subquery can retrieve data from more than one table.

    E

    A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    F

    A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.


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

  • 第20题：

    多选题
    Which two statements are true about the Automatic Workload Repository （AWR）（）
    A

    All AWR tables belong to the SYSTEM schema.

    B

    The AWR contains systemwide tracing and logging information.

    C

    The snapshots collected by the AWR are accessible through data dictionary views.

    D

    The snapshots collected by the AWR are used by self-tuning components in the database.


    正确答案： B,D
    解析： AWR 基础结构由两个主要部分组成：  • 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。  • 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。  它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。

  • 第21题：

    多选题
    You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）
    A

    It may advise the use of online table redefinition for tables in dictionary managed tablespace.

    B

    It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

    C

    It may advise the use of online table redefinition for tables in locally managed tablespaces

    D

    It will detect and advise about chained rows.

    E

    It may advise the use of segment shrink for free list managed tables.


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

  • 第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 about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true？（）
    A

    You may use Cisco Network Assistant to set up the initial configuration

    B

    You must use CLI for initial configuration

    C

    You may use either CLI or CAN for configuration

    D

    You may make a direct connection to the PC from any point on the switch

    E

    You may only make a direct connection from the port with the flashing green LED to the PC


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

  • 第24题：

    多选题
    Which two statements about sequences are true?（）
    A

    You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.

    B

    You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.

    C

    You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.

    D

    You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.

    E

    If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.

    F

    You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.


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

相关内容