The FACULTY table in your schema contains these columns FACI

The FACULTY table in your schema contains these columns:

FAC_ID NUMBER(9) NOT NULL, Primary Key

LAST_NAME VARCHAR2(25)

FIRST_NAME VARCHAR2(25)

SUBJECT_ID NUMBER(9)

You execute this statement

SQL> CREATE INDEX faculty_name_idx

ON faculty(first_name, last_name);

Which statement is true?

Solution

SQL> CREATE INDEX faculty_name_idx

ON faculty(first_name, last_name);

This statement is true

Fom the above query there is no create keyword to create the faculty table, and there is no \",\" at the end of attributes.