SQL Quizzes, Questions & Answers

Recent Quizzes

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

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

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"

Questions: 16 | Attempts: 470 | 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"

Questions: 18 | Attempts: 275 | 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

SQL Test: Trivia Quiz Questions!

Questions: 20 | Attempts: 1037 | Last updated: Mar 20, 2023

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

Sybase Quiz :: 1

Quiz for SQL, T-SQL

Questions: 5 | Attempts: 473 | Last updated: Mar 20, 2023

Sample Question
Can Index be created on temp tables?

Yes

No

Oracle Mock Test 2 (SQL +arch)

Oracle Mock Test 2 (SQL +Arch)

Are you learning the Oracle software? Do you want to test your knowledge about Oracle? Try this interesting and well-researched Oracle mock test 2 (SQL + Arch). With this test, you'll get the chance to test your understanding...

Questions: 23 | Attempts: 6997 | Last updated: May 10, 2023

Sample Question
Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

SELECT DISTINCT position, manager FROM employee;

SELECT position, manager DISTINCT FROM employee;

SELECT position, manager FROM employee;

SELECT position, DISTINCT manager FROM employee;

SQL And Relational Database Management

SQL and Relational Database Management

This quiz covers chapter 1 of The Practical SQL Handbook.

Questions: 39 | Attempts: 137 | Last updated: Mar 14, 2024

Sample Question
SQL is used for three kinds of operations:

Data Manipulation

Data definition

Data administration

Data projection

Data Selection

Data Convergence

SQL Course 1 70-431

End of course assessment

Questions: 19 | Attempts: 150 | Last updated: Aug 23, 2024

Sample Question
Your application must access data that is located on two SQL Server 2005 computers. One ofthese servers is named SQL1 and the other is SQL2. You have permissions to create a storedprocedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 byusing the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do?

Join the two servers by using the four-part syntax of server.database.schema.table.

Reference SQL2 by using an alias.

Add SQL2 as a remote server to SQL1.

Add SQL2 as a linked server to SQL1.

Access Interrogation: MS Access Queries Quiz

MS Access has all that it takes to manage a whole database with its tools and features to face modern world data-related problems. Challenge yourself with scenarios that mimic real-world data challenges, from sorting and grouping...

Questions: 10 | Attempts: 1138 | Last updated: Jul 29, 2024

Sample Question
Give the correct expression operator - Numbers between 1 to 10.

Between 1 or 10

Between 1 to 10

Between 1 and 10

Between 1 - 10

« Previous 1 2 3 456 Next »