Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER\
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in
orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

多选题

2022-01-04 04:33

A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

查看答案

正确答案

C| D

试题解析

标签： 1Z0-007

感兴趣题目

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.

Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（）

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.

Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（）

Whenever visible traces of oil are observed on or below the surface of the water in the immediate vicinity of ship or its wake，Governments of Parties to the Convention should，to the extent they are reasonably able to do so，promptly（）the facts bearing on the issue of whether there has been a violation of the provisions of this Regulation or Regulation 10 of this Annex of MARPOL 73/78.

The master may bind the Shipowner or Charterer（）doing such things as are necessary on the part of the one or of the other to carry out the contract.

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.

The three main things that a learner has to acquire when learning a new structure are the form, meaning and（）of the structure.

The circular steel structure installed around the propeller of a towboat is the（）.

Examine the structure of the STUDENTS table:

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）

The prima facie rule that the law of the flag governs contracts of carriage by sea（）the paramount rule of the intention of the parties，which may be express，or implied from the circumstances of the sea.