Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER

题目

Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）

A、CREATE INDEX NAME _IDX (first_name, last_name);
B、CREATE INDEX NAME _IDX (first_name, AND last_name)
C、CREATE INDEX NAME_IDX ON (First_name, last_name);
D、CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E、CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F、CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

参考答案和解析

正确答案:E

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

相似问题和答案

第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

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容