The EMPLOYEES table is stored in the SAMPLE tablespace.  The

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


参考答案:B

第2题:

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

第3题:

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? ()

A. MERGE

B. INSERT

C. UPDATE

D. ADD

E. ENTER

F. You cannot enter the phone numbers for the existing employee records.


参考答案: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题:

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

第6题:

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

第7题:

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?()

  • A、MERGE
  • B、INSERT
  • C、UPDATE
  • D、ADD
  • E、ENTER
  • F、You cannot enter the phone numbers for the existing employee records.

正确答案:C

第8题:

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.


参考答案:B, C, D

第9题:

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

第10题:

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

正确答案:B

更多相关问题