Category: SQL MCQs

Yes

No

RAW

CHAR

NUMERIC

VARCHAR

Authorizing Access and other control over Database

Insert, Update or Delete Records and Values

Change the structure of Tables

None of the options are correct

Values

Distinct values

Group by

Columns

SELECT NAME FROM SALES;

SELECT NULL FROM SALES;

SELECT * FROM SALES WHEN PRICE = NULL;

SELECT # FROM SALES;

The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

The AS clause is used with the JOIN clause only

The AS clause defines a search condition

All options are correct

DELETE does not free the space containing the table and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE does not free the space containing the table

DELETE free the space containing the table and TRUNCATE does not free the space containing the table

ASC

DESC

There is no default value

None of the options are correct

ROLLBACK and SAVEPOINT

GRANT and REVOKE

SELECT and INSERT

UPDATE and TRUNCATE

SCL

TCL

DCL

DDL