SQL Quizzes, Questions & Answers

Recent Quizzes

Explore the fundamentals of SQL through this engaging quiz. Test your knowledge on key SQL commands like SELECT, UPDATE, DELETE, and INSERT INTO. Ideal for learners seeking to enhance their database management skills.

Questions: 10 | Attempts: 134 | Last updated: Apr 16, 2024

Sample Question
What does SQL stand for?

Strong Question Language

Structured Query Language

Structured Question Language

Modern Database Systems SQL Quiz

modern database systems sql quiz

This Quiz is all about testing the basics skills in SQL.It covers SQL Server architecture, tools, security and datatypes, Implementing data integrity, subqueries, joins and T-SQL Enhancements.

Questions: 30 | Attempts: 1831 | Last updated: Mar 22, 2023

Sample Question
The primary - foreign key relations are used to

Cross-reference database tables

To index the database.

Clean-up the database

SQL Complete Test 2008

sql complete test 2008

This advanced SQL quiz, titled 'sql complete test 2008', evaluates knowledge on XML instances, catalog views, stored procedures, cursors, and triggers. It's designed to assess understanding of complex SQL features and their...

Questions: 73 | Attempts: 287 | Last updated: Mar 17, 2023

Sample Question
How do XML instances work with respect to a computed column?

A computed columns can have XML instances as a source as well as a type

Computed columns can have XML instances only as a source

Computed columns can have a XML instancesonly as a type.

Computed columns cannot have XML instances

SQL Interview Questions And Answers

SQL interview questions and answers

SQL is modern database system, which is used in programming and designed for managing data. Take this quiz and learn more about it!

Questions: 27 | Attempts: 399 | Last updated: Sep 6, 2023

Sample Question
"Consider the following statement: Select title_id, price, type from titles where price > dbo.AverageBookPrice('comp_science') What kind of a User Defined Function is used in the above statement?"

A) Scalar function

B) In-line table valued function

C) Multi-statement table valued function

D) None of the listed options

SQL Data Base 2

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

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

True

False

SQL Exam: Trivia Questions! Quiz

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: 618 | Last updated: Mar 20, 2023

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

True

False

Oracle Constraints By Blue Blaze

ORACLE CONSTRAINTS BY BLUE BLAZE

Explore the intricacies of Oracle constraints with the 'ORACLE CONSTRAINTS BY BLUE BLAZE' quiz. Assess your understanding of SQL constraints, including check constraints, transaction control commands, and more, enhancing database...

Questions: 20 | Attempts: 131 | Last updated: Mar 4, 2024

Sample Question
WHERE clauses allows alias names.

True

False

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, 2024

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, 2023

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: 276 | Last updated: Mar 21, 2023

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

« Previous 1 2 345 6 Next »