< Back To Sql Tests

SQL Basic Test

1. SQL to access and manipulate data in which of the following databases ?

MS Access
Mysql
Oracle
All

2. Full form of SQL ?

Standard Query Language
Structured Query Language
Simple Query Language
None

3. Which of the following function cannot be performed by SQL ?

Update Tables
Get data from tables
Create UI
Update records

4. The command to eliminate a table from a database is ?

DELETE TABLE USERS;
REMOVE TABLE USERS;
DROP TABLE USERS;
UPDATE TABLE USERS;

5. Which command is used to add a new column to an existing table ?

ALTER
UPDATE
ADD
CREATE

6. Which one of the following sorts rows in SQL?

SORT BY
ORDER BY
GROUP BY
ALIGN BY

7. Count function in SQL returns the number of ____ ?

Unique Values
Values
Columns
Rows

8. You can add a row using SQL in a database with which of the following ?

ADD
INSERT
UPDATE
CREATE

9. The primary key is selected from the

Composite keys
Foreign keys
Candidate keys
None

10. SQL data definition commands make up a(n) ?

DML
DDL
DCL
DPL

11. The SQL keywords(s) _____ is used with wildcards.

LIKE ONLY
IN NOT
NOT ONLY
ONLY IN