Advertisement

Advertisement

Advertisement

12th Grade SQL & Querying Quizzes, Questions & Answers

12th Grade

Popular SQL & Querying Topics

DCL & TCL

Functions & Expressions

Functions & Expressions

Popular SQL & Querying Quizzes

SQL & Pl/SQL Fundamentals Quiz

Questions: 33 | Attempts: 19752 | Last updated: Nov 21, 2025

Sample Question
Which SQL statement contains an error?

SELECT * FROM emp WHERE empid = 493945

SELECT empid FROM emp

SELECT empid FROM emp WHERE empid = 493945

SELECT empid WHERE empid = 56949 AND lastname='SMITH'

The Ultimate Server Query Language Quiz

Questions: 42 | Attempts: 13003 | Last updated: Mar 22, 2025

Sample Question
Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

SQL Multiple Choice Questions With Answers

Questions: 20 | Attempts: 12623 | Last updated: Jun 17, 2025

Sample Question
Full form of RDBMS is

Regional district management system

Relational database management system

Regular database management system

Regular district machine system

SQL Server Quiz Questions And Answers

Questions: 25 | Attempts: 8381 | Last updated: Jun 22, 2025

Sample Question
Assuming UserProfile is a table containing a column Proession that accepts a NULL value. What is the result of the query below? SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <> NULL).

Gives an error.

Returns all Professions that do not have null values.

<> is not an operator in SQL Server.

None of the above.

Test Your DDL and DML Knowledge

Questions: 10 | Attempts: 4194 | Last updated: Mar 13, 2025

Sample Question
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table?

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

INSERT INTO employees VALUES ('1000','JOHN','NULL');

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

PHP Mysql Basic Test

Questions: 10 | Attempts: 3410 | Last updated: Jun 17, 2025

Sample Question
PHP is Scripting language

Browser Side

Server Side

Home Side

Client Side

Recent SQL & Querying Quizzes

SQL & Pl/SQL Fundamentals Quiz

Questions: 33 | Attempts: 19752 | Last updated: Nov 21, 2025

Sample Question
Which SQL statement contains an error?

SELECT * FROM emp WHERE empid = 493945

SELECT empid FROM emp

SELECT empid FROM emp WHERE empid = 493945

SELECT empid WHERE empid = 56949 AND lastname='SMITH'

The Ultimate Server Query Language Quiz

Questions: 42 | Attempts: 13003 | Last updated: Mar 22, 2025

Sample Question
Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

SQL Multiple Choice Questions With Answers

Questions: 20 | Attempts: 12623 | Last updated: Jun 17, 2025

Sample Question
Full form of RDBMS is

Regional district management system

Relational database management system

Regular database management system

Regular district machine system

SQL Server Quiz Questions And Answers

Questions: 25 | Attempts: 8381 | Last updated: Jun 22, 2025

Sample Question
Assuming UserProfile is a table containing a column Proession that accepts a NULL value. What is the result of the query below? SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <> NULL).

Gives an error.

Returns all Professions that do not have null values.

<> is not an operator in SQL Server.

None of the above.

Test Your DDL and DML Knowledge

Questions: 10 | Attempts: 4194 | Last updated: Mar 13, 2025

Sample Question
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table?

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

INSERT INTO employees VALUES ('1000','JOHN','NULL');

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

PHP Mysql Basic Test

Questions: 10 | Attempts: 3410 | Last updated: Jun 17, 2025

Sample Question
PHP is Scripting language

Browser Side

Server Side

Home Side

Client Side

« Previous12 3 4 5 Next »

Advertisement