wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

SQL1

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

SQL is ______________?

a)

Programming Language

b)

Query Language

c)

Both

d)

None of these

2.

What is the meaning of “SELECT” clause in sql?

a)

Show me all Columns and rows

b)

Show me all columns

c)

Show me all rows

d)

None of the mentioned

3.

What will be the output of the following SQL statement?

SELECT *

FROM person;

a)

Show all rows and columns of table “person”

b)

Show all rows of table “person”

c)

Show all columns of table “person”

d)

None of the mentioned

4.

Can “SELECT” clause be used without the clause “FROM”?

a)

YES

b)

NO

c)

Depends upon condition

d)

None of the mentioned

5.

Find the error in the following SQL statement?

SELECT *;

a)

No Error

b)

No table mentioned

c)

Depends

d)

None of the mentioned

6.

Which clause is mandatory with clause “SELECT” in sql?

a)

FROM

b)

WHERE

c)

Both FROM and WHERE

d)

None of the mentioned

7.

Which among the following can also be included with “SELECT” clause while writing query in sql?

a)

Literals

b)

Expressions

c)

User defined functions

d)

All of the mentioned

8.

Which among the following is an optional Keyword?

a)

Distinct

b)

All

c)

AS

d)

None of these

9.

SQL stand for_________________?

a)

Structure Query Language

b)

Structured Query Language

c)

Structured Query Learning

d)

Structure Query Learning

10.

What does DML stand for?

a)

Different Mode Level

b)

Data Model Language

c)

Data Mode Lane

d)

Data Manipulation language