网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 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?()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.

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

考题 多选题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?()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

考题 单选题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 overD 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

考题 单选题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 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 utilityB the ANALYZE commandC the RMAN LIST commandD the RMAN REPORT commandE the RMAN CROSSCHECK commandF the 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?()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 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?()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 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 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