Scribd
Upload
13 views2 pages

Chapter 2 - SQL-Worksheet

The document is a revision worksheet for Grade VIII Computer Science focusing on Structured Query Language (SQL). It includes fill-in-the-blank questions, true or false statements, short answer questions, application-based questions, and assertion-reason questions related to SQL concepts. The worksheet aims to assess students' understanding of SQL terminology, data types, operators, and commands.

Uploaded by

kaushalvanshika78
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
13 views2 pages

Chapter 2 - SQL-Worksheet

The document is a revision worksheet for Grade VIII Computer Science focusing on Structured Query Language (SQL). It includes fill-in-the-blank questions, true or false statements, short answer questions, application-based questions, and assertion-reason questions related to SQL concepts. The worksheet aims to assess students' understanding of SQL terminology, data types, operators, and commands.

Uploaded by

kaushalvanshika78
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

Revision Worksheet- Structured Query Language in Action

GRADE – VIII SUBJECT – Computer


Q1. Fill in the blanks.

1. SQL stands for ______________________________________.


2. SQL is a ________________ and __________________ programming language.
3. ___________________ datatype represents floating type numbers.
4. _________________ operator is used for not equal to.
5. _________________ is a type of literals in SQL.

Q2. State True or False.


1. CHAR and VARCHAR are same type of datatype.
2. * symbol is used to retrieve entire data from the table
3. ‘AND’ operator is used to add two conditions.
4. SQL is easy to manage and update data.

Q3. Answer in one word or One Sentence.


1. Name the constraints where we set a same value for each record.
2. What is the full form of DBMS.
3. Which operator is used to compare values for greater than equal to?
4. What is the full form of DML?.
5. Which datatype is used to enter numbers, characters and special characters upto 65535 characters.

Q4. Application based question.

1. In a database table for an office, which type of constraint should be applied to ensure that a particular
column has the same fixed value for every entry

Q5. Answer the following questions.

1. Write a shot note on DDL command.


2. What is the use of UPDATE Table.
3. List any two types of Operators in SQL
4. Differentiate between Int and Decimal datatype.
5. What do you mean by SQL?

Q5. Each question consists of two statements, namely, Assertion (A) and Reason (R). Select the most
suitable option considering the Assertion & Reason.
1. Assertion (A): SQL stands for Structured Query Language.
Reason (R): SQL is used for programming games and mobile applications.

a) Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A).
b) Both Assertion (A) and Reason (R) are false
c) Assertion (A) is true and Reason (R) is false.
d) Assertion (A) is false and Reason (R) is true

2. Assertion (A): The SELECT statement in SQL is used to delete records from a table.
Reason (R): The DELETE statement removes data, while SELECT displays it.

a) Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A).
b) Both Assertion (A) and Reason (R) are false
c) Assertion (A) is true and Reason (R) is false.
d) Assertion (A) is false and Reason (R) is true

You might also like