单项选择题
Which best describes an inline view?（）
A. a schema object
B. a subquery that can contain an ORDER BY clause
C. another name for a view that contains group functions
D. a subquery that is part of the FROM clause of another query
相关考题
-
多项选择题
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）
A. MANAGER must be a role.
B. It allows the MANAGER to pass the specified privileges on to other users.
C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table. -
单项选择题
Which operator can be used with a multiple-row subquery?（）
A. =
B. LIKE
C. BETWEEN
D. NOT IN
E. IS
F. <> -
单项选择题
Examine the structure of the EMPLOYEES table: 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);
