Which statement regarding subqueries is true

A sub-query that substitutes the names of the outer query D. View Answer Ans : B Explanation: A correlated sub-query is the one that uses the correlation name of an outer query.

Exact Subqueries B. Vector Subqueries C. Positive Subqueries D. Scalar Subqueries. View Answer Ans : D Explanation: SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called Scalar subqueries. Scalar Subqueries can be used in the SQL update statement when they are used under the set clause. Compensating transaction B.

Aborted transaction C. Active transaction D. Partially committed transaction. View Answer Ans : B Explanation: Aborted transaction is a state after the transaction has been rolled back and the database has been restored to the state prior to the transaction. Concurrency control scheme B. Multiprogramming scheme C.

Serialization scheme D. Home » Oracle » 1z » Which two statements are true regarding subqueries? Which two statements are true regarding subqueries? A subquery can retrieve zero or more rows. Only two subqueries can be placed at one level. A subquery can be used only in SQL query statements. A subquery can appear on either side of a comparison operator.

Which of the following queries will give the required result. Write a query to find the employees whose salary is equal to the salary of at least one employee in department of id Choose the best answer.

You need to find out all the employees who have salary greater than at least one employee in the department You need to find out all the employees who have salary lesser than the salary of all the employees in the department The columns of data are passed to the outer query in the same order in which they're listed in the subquery's SELECT clause.

You need to find out all the employees who have their manager and department matching with the employee having an Employee ID of or Answer: A, D. You need to find the department name of an employee with employee ID You need to find the job which has at least one employee in it. An Uncorrelated subquery executes the subquery first and passes the value to the outer query.

You need to find the job which has no employees in it. You need to find the maximum salary by using the user input for getting the value of N. What is true about the ALL operator used for sub-queries? Examine the table structures as given below and answer the questions 83 to 86 that follow. Which of the following queries will give the required results? You need to display all the employees who have the highest salary in a department You fire a query as below. Consider table structures as shown in the exhibit and answer the questions 87 to 89 that follow:.

Choose the most appropriate output. Select the query which will give you the maximum salary and maximum comm percentage. The query should also give the maximum comm percentage paid if the highest salaried employee gets the maximum comm percentage.

What will be the outcome of the following query? Consider the following query and answer the questions 92 to 95 that follow:.

The question shows the ALL clause in a simplified manner when it is followed by a list. If in the above query the list 10,20,30 is replaced by a sub-query, which of the following queries will give the required output for the department number ?

The question shows the ALL clause in a simplified manner when it is followed by a sub-query. With respect to the question 14 above, what among the following will be an equivalent query if ALL has to be replaced with ANY? With respect to the question 94, if the operator ANY is not to be used, which of the following queries will be correct? Examine the given table structures. Consider the following query and answer the questions 96 to 98 that follow:.

The question shows the ANY clause in a simplified manner when it is followed by a list. In the above query, if the list 10, 20, 30 is replaced by a sub-query, which of the following queries will give the required output for the department number ?

The question shows the ANY clause in a simplified manner when it is followed by a sub-query. With respect to the question 97 above, what among the following will be an equivalent query if ANY is removed? How many rows will get generated if the sub-query mentioned returns 0 rows? If a subquery's result must be compared with a group function, you must nest the inner query in the outer query's HAVING clause.

Subqueries to Solve Queries Questions Advertisements. Previous Page. Next Page. Previous Page Print Page.