You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? （）

A、The main query executes with the first value returned by the subquery.

B、The main query executes with the last value returned by the subquery.

C、The main query executes with all the values returned by the subquery.

D、The main query fails because the multiple-row subquery cannot be used with the comparison operator.

E、You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

相关问题推荐

• In which two cases would you use an outer join? （）

  A

  The tables being joined have NOT NULL columns.

  B

  The tables being joined have only matched data.

  C

  The columns being joined have NULL values.

  D

  The tables being joined have only unmatched data.

  E

  The tables being joined have both matched and unmatched data.

  F

  Only when the tables have a primary key/foreign key relationship.

  查看答案

• In which scenario would TOP N analysis be the best solution?（）

  A、You want to identify the most senior employee in the company.

  B、You want to find the manager supervising the largest number of employees.

  C、You want to identify the person who makes the highest salary for all employees.

  D、You want to rank the top three sales representatives who have sold the maximum number of products.

  查看答案

• Which two statements are true about constraints? （）

  A

  The UNIQUE constraint does not permit a null value for the column.

  B

  A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

  C

  The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

  D

  The NOT NULL constraint ensures that null values are not permitted for the column.

  查看答案

• Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）

  A、SELECT last_name, department_name FROM employees NATURAL JOIN departments;

  B、SELECT last_name, department_name FROM employees JOIN departments ;

  C、SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);

  D、SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

  E、SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);

  F、SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

  查看答案

• The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）

  A、Column definitions cannot be altered to add DEFAULT values.

  B、A change to the DEFAULT value affects only subsequent insertions to the table.

  C、Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

  D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

  查看答案