Register

Ace Test Series: Databases - Sql

• edited by
756 views

1 Answer

Best answer
5 5 votes

Answer : (c) 3- Rows

It will return all the rows, as 0 value of count is cosidered to be the Existing value,so TRUE is returned.

  • WHERE EXISTS tests for the existence of any records in a subquery.
  • EXISTS returns true if the subquery returns one or more records.
  • EXISTS is commonly used with correlated subqueries.
• selected by
Voting & Accepting an answer helps improve the community
← Previous · C programmingNext → · Ace Test Series: Dat...
← Previous in category · Nawathe ElmsariNext in category → · Ace Test Series: Dat...
Position:
Show:

Related questions

1 1 vote
1 1 answer
1.2k
1.2k views
Priyansh Singh asked Mar 29, 2019
1,178 views
Ace Test Series: Databases-Sql Query
Given the following schema:employees(emp-id, first-name, last-name, hire-date, dept-id, salary)departments(dept-id, dept-name, manager-id, location-id)You want to display...
1 1 vote
1 1 answer
1.3k
1.3k views
Harsh Mehta asked Dec 27, 2017
1,316 views
Ace Test Series: Databases - Sql
$Emp$ $(eid: integer, ename: string, age: integer, salary :real)$$Works$ $(eid: integer, did: integer, pct_time: integer)$$Dept$ $(did: integer, budget: real, managerid: ...
0 0 votes
0 0 answers
850
850 views
saxena0612 asked Dec 7, 2017
850 views
Ace Test Series: Databases - Sql
1 1 vote
1 1 answer
3.4k
3.4k views
Na462 asked Jan 19, 2019
3,370 views
Ace Test Series 2019: DBMS - SQL Output