Advertisement

Advertisement

Advertisement

SQL & Querying Quizzes, Questions & Answers

Recent SQL & Querying Quizzes

SQL Technology Quiz: Can You Solve?

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"

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"

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

Questions: 16 | Attempts: 1492 | 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!

Questions: 20 | Attempts: 1055 | 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

Sort Quiz Over SQL And T-SQL

Questions: 10 | Attempts: 306 | Last updated: Mar 20, 2025

Sample Question
You can fetch only one row at a time.

True

False

Sybase Quiz :: 2

Questions: 10 | Attempts: 434 | Last updated: Mar 16, 2025

Sample Question
Which SQL command is used to extract data from tables?

EXTRACT

SELECT

FIND

None of above

T-SQL And General SQL: Unit 1 - Introduction To SQL Queries

Questions: 26 | Attempts: 246 | Last updated: Mar 20, 2025

Sample Question
T-SQL: You have a table with a colum entitled 'job', whose values are all lower case. If you execute the following query: SELECT ename, job, deptno FROM dbo.emp WHERE job = 'CLERK' you will not get any results back buecase the match is case sensitve and so because all values of the 'job' colum are lowercase, uppercase 'CLERK' will not be found.

True

False

Questions: 34 | Attempts: 545 | Last updated: Mar 22, 2025

Sample Question
Which /SQL*Plus feature can be used to replace values in the WHERE clause?

Substitution variables

Replacement variables

Prompt variables

Instead-of variables

This feature cannot be implemented through /SQL*Plus.

Oracle Mock Test

Questions: 20 | Attempts: 1157 | Last updated: Mar 18, 2025

Sample Question
Which two statements are true regarding the default behavior of the ORDER BY clause? (Choose two.)

Null values are left out of the sort.

Character values are displayed from Z to A.

Date values are displayed with the earliest value first.

Null values are displayed last for descending sequences.

Numeric values are displayed with the lowest values first.

« Previous 1...3 4 5 678 9 Next »

Advertisement