SQL Online Test Time limit: 0 Quiz-summary 0 of 20 questions completed Questions: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Information 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. You have already completed the quiz before. Hence you can not start it again. Quiz is loading... You must sign in or sign up to start the quiz. You have to finish following quiz, to start this quiz: Results 0 of 20 questions answered correctly Your time: Time has elapsed You have reached 0 of 0 points, (0) Categories Not categorized 0% 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Answered Review Question 1 of 20 1. Question SQL (Structured Query Language) was initially developed at…… Micro Soft Oracle IBM HP Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 2 of 20 2. Question SQL is not used for…… Create New Databases Create New Tables in a Database Join Tables to Retrieve data Join Databases Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 3 of 20 3. Question Which is not a subset of SQL? DDL PL/SQL DML DCL Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 4 of 20 4. Question ……is not a SQL – Data Definition Language Command Insert Create Rename Truncate Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 5 of 20 5. Question ……is not a SQL – Data Manipulation Language Command Select Insert Update Alter Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 6 of 20 6. Question ……is not a SQL – Data Control Language Command Drop Grant Revoke Deny Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 7 of 20 7. Question The Result of a SQL SELECT statement is a(n) …… Report Form File Table Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 8 of 20 8. Question Which one of the following sorts rows in SQL? SORT BY ALIGN BY ORDER BY GROUP BY Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 9 of 20 9. Question Which of the following SQL Command is used to DELETE data from a database table? CLEAR DROP DATA DELETE REMOVE Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 10 of 20 10. Question Database Table rows are also known as…… Fields Attributes Records Elements Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 11 of 20 11. Question Which SQL keyword is used to specify conditional search? SELECT SEARCH WHERE FIND Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 12 of 20 12. Question Which SQL keyword is used to retrieve a minimum value? LOW LOWER MIN DOWN Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 13 of 20 13. Question Can we use both HAVING and WHERE SQL clauses in one SQL statement? Yes No Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 14 of 20 14. Question The LIKE SQL keyword is used along with ….. JOIN clause. WHERE clause. ORDER BY clause. GROUP BY clause. Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 15 of 20 15. Question Which SQL statement is used to insert new data in a database? ADD RECORD INSERT NEW INSERT INTO ADD NEW Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 16 of 20 16. Question SQL statements are case sensitive. True False Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 17 of 20 17. Question Null is a blank space. True False Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 18 of 20 18. Question Which of the following is not a SQL aggregate function? SUM AVG MOD MAX Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 19 of 20 19. Question A table can have more than one primary key column. True False Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect… Question 20 of 20 20. Question SQL – Data manipulation language statements access and manipulate data in existing schema objects. True False Correct Yes, Your Answer is Correct… Incorrect No, Your Answer is Incorrect…

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 

Follow me on social media:

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
•