Register

DBMS-7

372 views
0 votes
0 votes

User Avatar

1 Answer

0 votes
0 votes
The EXISTS subquery tests whether a subquery fetches at least one row. When no data is returned then this operator returns 'FALSE'.

Sub-query regarding count(*) should return 0. So, the subquery being tested by EXISTS has returned 1 row. Hence, the entire employee table should be printed. ie. C) 3 rows.
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
akash.dinkar12 asked Apr 1, 2019
227 views
DBMS Korth Edition 4 Exercise 16 Question 7 (Page No. 633)
Show by example that there are schedules possible under the tree protocol that are not possible under the two-phase locking protocol, and vice versa.
Show by example that there are schedules possible under the tree protocol that are not possible under the two-phase locking protocol, and vice versa.
User Avatar
0 votes
0 votes
0 answers
2
akash.dinkar12 asked Apr 1, 2019
193 views
DBMS Korth Edition 4 Exercise 15 Question 7 (Page No. 589)
Explain the distinction between the terms $serial$ schedule and $serializable$ schedule.
Explain the distinction between the terms $serial$ schedule and $serializable$ schedule.
User Avatar
0 votes
0 votes
1 answer
4
ajaysoni1924 asked Mar 28, 2019
829 views
DBMS Korth Edition 6 Exercise 7 Question 29 (Page No. 321)
Explain the distinction between total and partial constraints.
Explain the distinction between total and partial constraints.
User Avatar
Link Copied!