12th Grade SQL & Querying Quizzes, Questions & Answers

Recent SQL & Querying Quizzes

Questions: 25 | Attempts: 204 | Last updated: Mar 19, 2025

Sample Question
SQL < select name ,sal from Emp where name like m%;

True

False

SQL Exam: trivia questions quiz! The structured query language is designed to help a programmer manipulate databases. It helps in retrieval and editing of data from the database with ease. This computer language is one of the...

Questions: 25 | Attempts: 621 | Last updated: Mar 20, 2025

Sample Question
SQL < select name ,sal from Emp where name like m%;

True

False

Oracle Test 5

Oracle Test 5 assesses knowledge in SQL queries, table operations, and data manipulation within Oracle databases. It evaluates understanding of complex SQL statements, table creation, rollback operations, and conditional data...

Questions: 50 | Attempts: 2212 | Last updated: Mar 22, 2025

Sample Question
1. Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a.sal < b.maxsal; What is the result of the statement?

The statement produces an error at line 1.

The state ment produces an error at line 3.

The statement produces an error at line 6.

The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

Quiz Questions Over Oracle Software

Quiz questions over oracle software

This quiz focuses on Oracle software, assessing knowledge on database structures, integrity constraints, and PL\/SQL syntax. It is designed to validate understanding of Oracle database management, essential for IT professionals...

Questions: 20 | Attempts: 213 | Last updated: Mar 17, 2025

Sample Question
Databases overall structure is maintained in a file called

Redolog file

Data file

Control file

All of the above

Pl/SQL Questions Exam Quiz!

PL/SQL Questions Exam Quiz!

The 'PL\/SQL Questions Exam Quiz!' assesses knowledge in PL\/SQL, covering topics from basic syntax to advanced database functions. It evaluates understanding of SQL functions, exception handling, and date manipulation, crucial...

Questions: 10 | Attempts: 4760 | Last updated: Apr 20, 2025

Sample Question
How many tables may be included with a join?

One

Two

Three

All the above

SQL Technology Quiz: Can You Solve?

SQL Technology quiz: can you solve?

SQL is the standard and acceptable language for storing, manipulating and retrieving data in databases. This technology helps the specialists in undertaking their work. How good are you with different SQL concepts? Find out...

Questions: 20 | Attempts: 142 | Last updated: Aug 7, 2025

Sample Question
You can add a row using SQL in a database with which of the following?

ADD

CREATE

INSERT

MAKE

SQL Quiz-2 By "The Cloud9"

SQL Quiz-2 by "The Cloud9"

SQL Quiz-2 by 'The Cloud9' assesses advanced SQL skills through practical questions on table structures, data manipulation, and procedural SQL. It's designed for learners to enhance their database management capabilities.

Questions: 16 | Attempts: 474 | Last updated: Mar 20, 2025

Sample Question
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHARD2(25) LAST_NAME VARCHARD2(25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which UPDATE statement is valid?

UPDATE new_employees SET name = (Select last_name|| first_name FROM employees Where employee_id =180) WHERE employee_id =180;

UPDATE new_employees SET name = (SELECT last_name||first_name FROM employees) WHERE employee_id =180;

UPDATE new_employees SET name = (SELECT last_name|| first_name FROM employees WHERE employee_id =180) WHERE employee_id =(SELECT employee_id FROM new employees);

UPDATE new_employees SET name = (SELECT last name|| first_name FROM employees WHERE employee_id= (SELECT employee_id FROM new_employees)) WHERE employee_id =180;

SQL Quiz By "The Cloud 9"

SQL Quiz by "The Cloud 9"

The SQL Quiz by 'The Cloud 9' assesses knowledge in SQL commands and concepts, focusing on operations like DELETE, understanding constraints, Oracle interfaces, and performance optimization. It's designed for learners to test and...

Questions: 18 | Attempts: 277 | Last updated: Mar 21, 2025

Sample Question
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

1. DELETE ROW FirstName='Peter' FROM Persons

2. DELETE FirstName='Peter' FROM Persons

3. DELETE FROM Persons WHERE FirstName = 'Peter'

4. None

SQL & Pl/SQL

SQL & PL/SQL

This SQL & PL\/SQL quiz assesses knowledge on block-structured language specifics, executable sections, table security through views, handling of null values, DCL statements, and efficient data retrieval methods. It's tailored...

Questions: 16 | Attempts: 1470 | Last updated: Mar 21, 2025

Sample Question
PL/SQL is a _______ language?

Object oriented

Block structured

Object structured

All the above

SQL Test: Trivia Quiz Questions!

Dive into the fundamentals of software development with this SQL Test: Trivia Quiz Questions! Assess your understanding of pointers, memory allocation, system calls, and more. Enhance your skills in handling various programming...

Questions: 20 | Attempts: 1043 | Last updated: Mar 20, 2025

Sample Question
A pointer is

A keyword used to create variables

A variable that stores address of an instruction

A variable that stores address of other variable

All of the above

« Previous 1 2 3 456 7 Next »