Evaluate this SQL statement:SELECT e.e...

多项选择题 Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10,40)
ORSER BY dept_name;
The statement fails when executed. Which change fixes the error?（）

A. remove the ORDER BY clause
B. remove the table alias prefix from the WHERE clause
C. remove the table alias from the SELECT clause
D. prefix the column in the USING clause with the table alias
E. prefix the column in the ORDER BY clause with the table alias
F. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which three statements about subqueries are true? （）

A. A main query can have more than one subquery.
B. A subquery can have more than one main query.
C. The subquery and main query must retrieve data from the same table.
D. The subquery and main query can retrieve data from different tables.
E. Only one column or expression can be compared between the subquery and main query.
F. Multiple columns or expression can be compared between the subquery and main query.

点击查看答案

2.单项选择题 EXHIBIT, Emp Table

Exhibit A

Exhibit B

Examine the data from the EMP table.
Evaluate this SQL statement:
SELECT *
FROM emp
WHERE emp _ id = 3);
WHERE commission = (SELECT commission
FROM emp
What is the result when the query is executed?（）

A. Exhibit A
B. Exhibit B
C. The query returns no rows
D. The query fails because the outer query is retrieving more than one column
E. The query fails because both the inner and outer queries are retrieving data from the same table.

点击查看答案

3.多项选择题Which two statements about creating constraints are true?（）

A. Constraint names must start with SYS_C
B. All constraints must be defines at the column level
C. Constraints can be created after the table is created
D. Constraints can be created at the same time the table is created
E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

点击查看答案

4.单项选择题For which action can you use the TO_DATE function?（）

A. Convert any date literal to a date
B. Convert any numeric literal to a date
C. Convert any character literal to a date
D. Convert any date to a character literal
E. Format '10-JAN-99' to 'January 10 1999'

点击查看答案

5.单项选择题What is true regarding subqueries?（）

A. The inner query always sorts the results of the outer query
B. The outer query always sorts the results of the inner query
C. The outer query must return a value to the outer query
D. The inner query returns a value to the outer query
E. The inner query must always return a value or the outer query will give an error

点击查看答案

6.单项选择题You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A. Create a table view.
B. Create a view in any schema.
C. Create a view in your schema.
D. Create a sequence view in any schema.
E. Create a view that is accessible by everyone.
F. Create a view only of it is based on tables that you created.

点击查看答案

7.多项选择题 Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement? （）

A. You cannot roll back this statement.
B. All pending transactions are committed.
C. All views based on the DEPT table are deleted.
D. All indexes based on the DEPT table are dropped.
E. All data in the table is deleted, and the table structure is also deleted.
F. All data in the table is deleted, but the structure of the table is retained.
G. All synonyms based on the DEPT table are deleted.

点击查看答案

8.单项选择题Which statement describes the ROWID data type?（）

A. Binary data up to 4 gigabytes.
B. Character data up to 4 gigabytes.
C. Raw binary data of variable length up to 2 gigabytes.
D. Binary data stored in an external file, up to 4 gigabytes.
E. A hexadecimal string representing the unique address of a row in its table.

点击查看答案

9.单项选择题 You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:

Which SELECT statement accomplishes this task?（）

A. SELECT*   FROM customers;
B. SELECT name, address   FROM customers;
C. SELECT id, name, address, phone   FROM customers;
D. SELECT cust_name, cust_address   FROM customers;
E. SELECT cust_id, cust_name, cust_address, cust_phone   FROM customers;

点击查看答案

10.单项选择题 The STUDENT_GRADES table has these columns
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?（）

A. SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' OR gpa > 3.;
B. SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa gt 3.0;
C. SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa > 3.0;
D. SELECT student_id, gpa FROM student_grades WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >=s 3.0;

点击查看答案