多項選擇題

Which three statements about subqueries are true? （）

A.A single row subquery can retrieve only one column and one row.
B.A single row subquery can retrieve only one row but many columns.
C.A multiple row subquery can retrieve multiple rows and multiple columns.
D.A multiple row subquery can be compared using the ">" operator.
E.A single row subquery can use the IN operator.
F.A multiple row subquery can use the "=" operator.

你可能感興趣的試題

單項選擇題

Click the Exhibit button and examine the data in the EMPLOYEES table.
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.
Evaluate this DELETE statement:
DELETE employee_id, salary, job_id
FROM employees
WHERE dept_id = 90;
Why does the DELETE statement fail when you execute it?（）

A.There is no row with dept_id 90 in the EMPLOYEES table.
B.You cannot delete the JOB_ID column because it is a NOT NULL column.
C.You cannot specify column names in the DELETE clause of the DELETE statement.
D.You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

多項選擇題

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHAR2(10)
START_DATE DATE
END_DATE DATE
Which two aggregate functions are valid on the START_DATE column? （）

A.SUM(start_date)
B.AVG(start_date)
C.COUNT(start_date)
D.AVG(start_date, end_date)
E.MIN(start_date)
F.MAXIMUM(start_date)

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

Which three statements about subqueries are true? （）

你可能感興趣的試題

Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? （）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHAR2(10)
START_DATE DATE
END_DATE DATE
Which two aggregate functions are valid on the START_DATE column? （）