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

题目

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? （）

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.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

S7－200PLC有哪几种扩展模块?()

A、数字量扩展模块：EM 221、EM222、EM223

B、模拟量扩展模块：EM 231、EM232、EM235

C、通信模块：EM227

D、现场设备扩展模块：CP243;

正确答案: A,B,C,D

第2题：

Examine the structure of the EMPLOYEES table:What is the correct syntax for an inline view?()

参考答案：A

第3题：

M．Jackson suggested the data structure oriented software design method．Which of the following structure can be introduced by using input data structure?

A．algorithm structure

B．procedure structure

C．code structure

D．program structure

正确答案：D

第4题：

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()

参考答案：A

第5题：

Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()

参考答案：A

第6题：

Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）

参考答案：C

第7题：

Examine the structure of the EMPLOYEES table:You issue these statements:At the end of this transaction, what is true?()

A. You have no rows in the table.

B. You have an employee with the name of James.

C. You cannot roll back to the same savepoint more than once.

D. Your last update fails to update any rows because employee ID 180 was already eleted.

参考答案：A

第8题：

合法的电子邮件地址是( )。

A．Wang.em.hxing.com.cn

B．em.hxing.com.cn.wang

C．em.hxing.com.on@wang

D．wang@em.hxig.com.cn

正确答案：D
解析：电子邮件地址的一般格式为：用户名＞+电子邮件服务器域名＞。

第9题：

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?()

参考答案：B, D

第10题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

Examine the structure of the EM

题目

相似问题和答案

更多相关问题

相关内容