itgle.com

单选题The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablesp

题目
单选题
The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace.  Which object will be exported by this command？（）   exp system/manager tablespaces=SAMPLE
A

Only the EMPLOYEES table.

B

Only the EMPLOYEES table and its corresponding primary key index.

C

The EMPLOYEES table and partition P1.

D

The EMPLOYEES table， IPK_EMP index， and the SALES table.

相似考题

1.Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

2.Which two statements are true of the forwarding table?()A.The forwarding table is stored in the control plane only.B.The forwarding table contains both active and inactive routes.C.The forwarding table is stored in the control plane and the forwarding plane.D.The forwarding table uses a longest match lookup for forwarding decisions.

3.In what location are EIGRP successor routes stored?()A. In the routing table only.B. In the neighbor table only.C. In the topology table only.D. In the routing table and neighbor table.E. In the routing table and topology table.F. In the topology table and neighbor table.

4.Which statement is correct about the forwarding table?()A. The forwarding table is stored only on the PFEB. The forwarding table contains all known routesC. The forwarding table is stored on both the RE and PFED. The forwarding table is stored only on the RE

更多“单选题The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablesp”相关问题

  • 第1题：

    Which type of EIGRP route entry describes a feasible successor?()

    A. a primary route,stored in the routing table

    B. a backup route,stored in the routing table

    C. a backup route,stored in the topology table

    D. a primary route,stored in the topology table


    参考答案：C

  • 第2题：

    In what location are EIGRP successor routes stored?（）

    • A、In the routing table only.
    • B、In the neighbor table only.
    • C、In the topology table only.
    • D、In the routing table and neighbor table.
    • E、In the routing table and topology table.
    • F、In the topology table and neighbor table.

    正确答案:E

  • 第3题：

    Which statement is correct about the forwarding table?（）

    • A、The forwarding table is stored only on the PFE
    • B、The forwarding table contains all known routes
    • C、The forwarding table is stored on both the RE and PFE
    • D、The forwarding table is stored only on the RE

    正确答案:C

  • 第4题：

    Which statement is true about the forwarding table?（）

    • A、The forwarding table is stored in the control plane only
    • B、The forwarding table is stored in the control plane and in the forewarding plane
    • C、The forwarding table contains both active and inactive routes
    • D、The forwarding table can contain only sigle next hop per destination

    正确答案:B

  • 第5题：

    The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace.  Which object will be exported by this command？（）   exp system/manager tablespaces=SAMPLE

    • A、Only the EMPLOYEES table.
    • B、Only the EMPLOYEES table and its corresponding primary key index.
    • C、The EMPLOYEES table and partition P1.
    • D、The EMPLOYEES table， IPK_EMP index， and the SALES table.

    正确答案:D

  • 第6题：

    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

    • A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
    • B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
    • C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
    • D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

    正确答案:C

  • 第7题：

    单选题
    Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
    A

    Oracle Data Pump.

    B

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

    C

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

    D

    Online Table Redefinition.

    E

    Edition-Based Table Redefinition.


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

  • 第8题：

    单选题
    Which statement is true about the forwarding table?（）
    A

    The forwarding table is stored in the control plane only

    B

    The forwarding table is stored in the control plane and in the forewarding plane

    C

    The forwarding table contains both active and inactive routes

    D

    The forwarding table can contain only sigle next hop per destination


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

  • 第9题：

    单选题
    Which two operations can be flashed back using the Flashback technology？ （）
    A

    DROP USER SMITH；

    B

    DROP TABLE EMPLOYEES；

    C

    DROP TABLESPACE USERS；

    D

    ALTER TABLE SALES_REP DROP PARTITION P1；

    E

    ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；


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

  • 第10题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The EMPLOYEES table will be changed to read-only mode during the shrink operation.

    B

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

    C

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

    D

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.


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

  • 第11题：

    单选题
    In what location are EIGRP successor routes stored?（）
    A

    In the routing table only.

    B

    In the neighbor table only.

    C

    In the topology table only.

    D

    In the routing table and neighbor table.

    E

    In the routing table and topology table.

    F

    In the topology table and neighbor table.


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

  • 第12题：

    单选题
    Which type of EIGRP route entry describes a feasible successor?（）
    A

    a primary route,stored in the routing table

    B

    a backup route,stored in the routing table

    C

    a backup route,stored in the topology table

    D

    a primary route,stored in the topology table


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

  • 第13题：

    Which type of EIGRP route entry describes a feasible successor?（）

    • A、a primary route,stored in the routing table
    • B、a backup route,stored in the routing table
    • C、a backup route,stored in the topology table
    • D、a primary route,stored in the topology table

    正确答案:C

  • 第14题：

    Which statement is true about the forwarding table?（）

    • A、The forwarding table is stored in the control plane only.
    • B、The forwarding table is stored in the control plane and in the forwarding plane.
    • C、The forwarding table contains both active and inactive routes.
    • D、The forwarding table can contain only a single next hop per destination.

    正确答案:B

  • 第15题：

    Which two statements are true of the forwarding table?（）

    • A、The forwarding table is stored in the control plane only.
    • B、The forwarding table contains both active and inactive routes.
    • C、The forwarding table is stored in the control plane and the forwarding plane.
    • D、The forwarding table uses a longest match lookup for forwarding decisions.

    正确答案:C,D

  • 第16题：

    Which two operations can be flashed back using the Flashback technology？（）

    • A、DROP USER SMITH；
    • B、DROP TABLE EMPLOYEES；
    • C、DROP TABLESPACE USERS；
    • D、ALTER TABLE SALES_REP DROP PARTITION P1；
    • E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；

    正确答案:A,B

  • 第17题：

    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

    • A、 the RMAN LIST command
    • B、 the DBNEWID utility
    • C、 the RMAN REPORT command
    • D、 the RMAN BLOCKRECOVER command
    • E、 the RMAN CROSSCHECK command
    • F、 the ANALYZE command

    正确答案:F

  • 第18题：

    单选题
    Which statement is true about the forwarding table?（）
    A

    The forwarding table is stored in the control plane only.

    B

    The forwarding table is stored in the control plane and in the forwarding plane.

    C

    The forwarding table contains both active and inactive routes.

    D

    The forwarding table can contain only a single next hop per destination.


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

  • 第19题：

    多选题
    Which two operations can be flashed back using the Flashback technology？（）
    A

    DROP USER SMITH；

    B

    DROP TABLE EMPLOYEES；

    C

    DROP TABLESPACE USERS；

    D

    ALTER TABLE SALES_REP DROP PARTITION P1；

    E

    ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；


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

  • 第20题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The data in the segment will be compacted but the high water mark will not be adjusted 

    B

    The EMPLOYEES table will be changed to read-only mode during the shrink operation 

    C

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over

    D

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 

    E

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation


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

  • 第21题：

    单选题
    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
    A

    the DBNEWID utility

    B

    the ANALYZE command

    C

    the RMAN LIST command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the RMAN BLOCKRECOVER command


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

  • 第22题：

    多选题
    Which two statements are true of the forwarding table?（）
    A

    The forwarding table is stored in the control plane only.

    B

    The forwarding table contains both active and inactive routes.

    C

    The forwarding table is stored in the control plane and the forwarding plane.

    D

    The forwarding table uses a longest match lookup for forwarding decisions.


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

  • 第23题：

    单选题
    Which statement is correct about the forwarding table?（）
    A

    The forwarding table is stored only on the PFE

    B

    The forwarding table contains all known routes

    C

    The forwarding table is stored on both the RE and PFE

    D

    The forwarding table is stored only on the RE


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

相关内容