Tables and Views
1.

SQL Views are also known as
A.  

Complex tables

 B.  

Simple tables

 C.  

Virtual tables

 D.  

Actual Tables
2.

What is the full form of SQL?
A.  

Structured Query List

 B.  

Structure Query Language

 C.  

Sample Query Language

 D.  

None of these.
3.

Which of the following is not a DDL command?
A.  

TRUNCATE

 B.  

ALTER

 C.  

CREATE

 D.  

UPDATE
4.

Which of the following are TCL commands?
A.  

COMMIT and ROLLBACK

 B.  

UPDATE and TRUNCATE

 C.  

SELECT and INSERT

 D.  

GRANT and REVOKE
5.

SQL Views are also known as
A.  

Simple tables

 B.  

Virtual tables

 C.  

Complex tables

 D.  

Actual Tables
6.

How many Primary keys can have in a table?
A.  

Only 1

 B.  

Only 2

 C.  

Depends on no of Columns

 D.  

Depends on DBA
7.

Which datatype can store unstructured data in a column ?
A.  

CHAR

 B.  

RAW

 C.  

NUMERIC

 D.  

VARCHAR
8.

Which of the following is not Constraint in SQL?
A.  

Primary Key

 B.  

Not Null

 C.  

Check

 D.  

Union
9.

Which data manipulation command is used to combines the records from one or more tables?
 
A.  

SELECT

 B.  

PROJECT

 C.  

JOIN

 D.  

PRODUCT
10.

In which of the following cases a DML statement is not executed?
A.  

When existing rows are modified.

 B.  

When a table is deleted.

 C.  

When some rows are deleted.

 D.  

All of the above