单选题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=SAMPLEAOnly the EMPLOYEES table.BOnly the EMPLOYEES table and its corresponding primary key index.CThe EMPLOYEES table and partition P1.DThe EMPLOYEES table, IPK_EMP index, and the SALES table.

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


参考解析

解析: 暂无解析

相关考题:

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.

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

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.

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.

Which type of EIGRP route entry describes a feasible successor?() A. a primary route,stored in the routing tableB. a backup route,stored in the routing tableC. a backup route,stored in the topology tableD. a primary route,stored in the topology table

Which type of EIGRP route entry describes a feasible successor?()A、a primary route,stored in the routing tableB、a backup route,stored in the routing tableC、a backup route,stored in the topology tableD、a primary route,stored in the topology table

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.

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.

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

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.

Which statement is true about the forwarding table?()A、The forwarding table is stored in the control plane onlyB、The forwarding table is stored in the control plane and in the forewarding planeC、The forwarding table contains both active and inactive routesD、The forwarding table can contain only sigle next hop per destination

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;

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=SAMPLEA、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.

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 commandB、 the DBNEWID utilityC、 the RMAN REPORT commandD、 the RMAN BLOCKRECOVER commandE、 the RMAN CROSSCHECK commandF、 the ANALYZE command

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.

单选题Which statement is true about the forwarding table?()AThe forwarding table is stored in the control plane only.BThe forwarding table is stored in the control plane and in the forwarding plane.CThe forwarding table contains both active and inactive routes.DThe forwarding table can contain only a single next hop per destination.

单选题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?()AOracle Data Pump.BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.DOnline Table Redefinition.EEdition-Based Table Redefinition.

多选题Which two operations can be flashed back using the Flashback technology?()ADROP USER SMITH;BDROP TABLE EMPLOYEES;CDROP TABLESPACE USERS;DALTER TABLE SALES_REP DROP PARTITION P1;EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

单选题Which statement is true about the forwarding table?()AThe forwarding table is stored in the control plane onlyBThe forwarding table is stored in the control plane and in the forewarding planeCThe forwarding table contains both active and inactive routesDThe forwarding table can contain only sigle next hop per destination

单选题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?()AThe data in the segment will be compacted but the high water mark will not be adjusted BThe EMPLOYEES table will be changed to read-only mode during the shrink operation CThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overDThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation EData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation

单选题Which two operations can be flashed back using the Flashback technology? ()ADROP USER SMITH;BDROP TABLE EMPLOYEES;CDROP TABLESPACE USERS;DALTER TABLE SALES_REP DROP PARTITION P1;EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

单选题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?()Athe DBNEWID utilityBthe ANALYZE commandCthe RMAN LIST commandDthe RMAN REPORT commandEthe RMAN CROSSCHECK commandFthe RMAN BLOCKRECOVER command

单选题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?()AThe EMPLOYEES table will be changed to read-only mode during the shrink operation.BThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.CThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.DData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

多选题Which two statements are true of the forwarding table?()AThe forwarding table is stored in the control plane only.BThe forwarding table contains both active and inactive routes.CThe forwarding table is stored in the control plane and the forwarding plane.DThe forwarding table uses a longest match lookup for forwarding decisions.

单选题In what location are EIGRP successor routes stored?()AIn the routing table only.BIn the neighbor table only.CIn the topology table only.DIn the routing table and neighbor table.EIn the routing table and topology table.FIn the topology table and neighbor table.

单选题Which statement is correct about the forwarding table?()AThe forwarding table is stored only on the PFEBThe forwarding table contains all known routesCThe forwarding table is stored on both the RE and PFEDThe forwarding table is stored only on the RE

单选题Which type of EIGRP route entry describes a feasible successor?()Aa primary route,stored in the routing tableBa backup route,stored in the routing tableCa backup route,stored in the topology tableDa primary route,stored in the topology table