Scribd
Upload
25 views2 pages

WS-2 SQL

Uploaded by

MunchChocolate Nanet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
25 views2 pages

WS-2 SQL

Uploaded by

MunchChocolate Nanet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Kendriya Vidyalaya Sangathan, Ahmedabad Region

Revision Worksheet -01


SQL
Subject: Computer Science
1 Which clause is used to search for NULL values in any column?

2 RDBMS stands for:

3 Rajesh a database developer at StoreIndia wants to search the record of those employees
whose name starts from „R‟ and they have not allotted any project, for this he has
writtenthe following query-
Select * from Employee where Name = ‘R%’ and Project=Null;
But the query is not producing the correct output. Rewrite the query after correcting
the errors

4 Which clause is used to see the output of query in ascending or descending order?

5 What is the difference between Primary Key and Candidate Key?

6 Explain count () and count (*)?

7
8

You might also like