SQL Online Test

sql tutorial

SQL Fundamentals

SQL Online Test

SQL Online Practice Test for Database Developers, Database Testers and Database Administrators. Structured Query Language Fundamentals, Data Definition Language, Database Manipulation Language, Database Control Language, SQL Data Types,  SQL Operators and SQL Functions.

SQL Online Practice Test

1) SQL (Structured Query Language) was initially developed at……

a) Micro Soft

b) Oracle

c) IBM

d) HP

2) SQL is not used for……

a) Create New Databases

b) Create New Tables in a Database

c) Join Tables to Retrieve data

d) Join Databases

3) Which is not a subset of SQL?

a) Data Definition Language

b) PL/SQL

c) Data Manipulation Language

d) Data Control Language

4) ……is not a SQL – Data Definition Language Command

a) Insert

b) Create

c) Rename

d) Truncate

5) ……is not a SQL – Data Manipulation Language Command

a) Select

b) Insert

c) Update

d) Alter

6) ……is not a SQL – Data Control Language Command

a) Drop

b) Grant

c) Revoke

d) Deny

7) The Result of a SQL SELECT statement is a(n) ……

a) Report

b) Form

c) File

d) Table

8) Which one of the following sorts rows in SQL?

a) SORT BY

b) ALIGN BY

c) ORDER BY

d) GROUP BY

9) Which of the following SQL Command is used to DELETE data from a database table?

a) CLEAR

b) DROP DATA

c) DELETE

d) REMOVE

10) Database Table rows are also known as……

a) Fields

b) Attributes

c) Records

d) Elements

11) Which SQL keyword is used to specify conditional search?

a) SELECT

b) SEARCH

c) WHERE

d) FIND

12) Which SQL keyword is used to retrieve a minimum value?

a) LOW

b) LOWER

c) MIN

d) DOWN

13) Can we use both HAVING and WHERE SQL clauses in one SQL statement?

a) Yes.

b) No.

14) The LIKE SQL keyword is used along with …..

a) JOIN clause.

b) WHERE clause.

c) ORDER BY clause.

d) GROUP BY clause.

15) Which SQL statement is used to insert new data in a database?

a) ADD RECORD

b) INSERT NEW

c) INSERT INTO

d) ADD NEW

16) SQL statements are case sensitive.

a) True

b) False

17) Null is a blank space.

a) True

b) False

18) Which of the following is not a SQL aggregate function?

a) SUM

b) AVG

c) MOD

d) MAX

19) A table can have more than one primary key column.

a) True

b) False

20) SQL – Data manipulation language statements access and manipulate data in existing schema objects.

a) True

b) False


Structured Query Language Fundamentals, SQL – Data Definition Language, Data Manipulation Language, Data Control Language, SQL Syntax, SQL Data Types, SQL Operators and SQL Functions.

SQL is for Database Developers, Database Testers and Database Administrators.

SQL Data Definition Language is mainly used by Database Developers, Data Manipulation Language by Database Testers and Data Control Language by Database Administrators. Using SQL Commands Software Testers conduct Database Testing Manually as well as Automated.

SQL Step by Step Videos 

(1067)

You may also like...

%d bloggers like this: