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? （） -题库考试答案搜索网

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

单选题

2022-01-03 23:06

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)

查看答案

正确答案

试题解析

标签： 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.