_______ operator can be used with a multiple row subquery.
Correct Answer: NOT IN
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle SQL 9i Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle SQL 9i MCQ Questions
Evaluate the SQL statement given below: SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the following values are displayed?
Which of the following tasks can be performed by using the TO_CHAR function?
You need to create a report of ten students who achieved the highest ranking in the course INT_SQL and completed the course in the year 1999. Which of the following SQL statements accomplishes this task?
Which component is a literal in the following select statement? Select Emp name :||ename from emp where deptno=20;
Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries work?
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which of the following statements will accomplish this task?
You want to display the titles of books that meet the following criteria: 1. Purchased before Feb 21, 2002 2. Price is less than $500 or greater than $900. You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?
You have to calculate the value 12* salary* commission_pct for all the employees in the EMP table. Which of the following statements ensures that a value is displayed in the calculated column for all the employees?
You want to list names of the employees who have been with the company for more than five years. Which of the following SQL statements will display the required results?
Which type of join will you write to perform an outer join of tables A and B that returns all rows from B