Advertisement

Advertisement

Advertisement

10th Grade SQL & Querying Quizzes, Questions & Answers

Recent SQL & Querying Quizzes

Questions: 44 | Attempts: 889 | Last updated: Mar 22, 2025

Sample Question
Which of the following statemens are true?

Procedures and functions must return values

Procedures and functions may return value

Procedures may return values

Functions must return values

Test Your DDL and DML Knowledge

Questions: 10 | Attempts: 4215 | 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',");

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

Sample Question
You issue the following query: SELECT salary "Employee Salary" FROM employees; How will the column heading appear in the result?

EMPLOYEE SALARY

EMPLOYEE_SALARY

Employee Salary

Employee_salary

Questions: 15 | Attempts: 1335 | Last updated: Mar 22, 2025

Sample Question
Which SELECT statement will the result 'ello world' from the string 'Hello World'?

SELECT SUBSTR ('Hello',) FROM dual;

SELECT INITCAP (TRIM ('Hello World',1,1) FROM dual;

SELECT LOWER (SUBSTR ('Hello World',1,1) FROM dual;

SELECT LOWER (SUBSTR ('Hello World',2,1) FROM dual;

SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

The SQL Procedure: Trivia Quiz

Questions: 6 | Attempts: 1112 | Last updated: Mar 20, 2025

Sample Question
A query that joins a table to itself

Outer join

Self-join

Inner join

SQL Data Manipulation Language Trivia Quiz!

Questions: 20 | Attempts: 1479 | Last updated: Mar 21, 2025

Sample Question
A DML command that inserts, updates, or deletes database data

Alias

Inner join

Action query

PHP Level 3, Sql

Questions: 6 | Attempts: 366 | Last updated: Mar 20, 2025

Sample Question
If you're in an SQL command line environment (like "mysql"), which SQL statement would be useful if you wanted to add two numbers together, like 540 + 232? With what word would your SQL statement begin?

SELECT

SUM()

PRINT

ADD

SQL Test For Mappers

Questions: 10 | Attempts: 364 | Last updated: Mar 21, 2025

Sample Question
1. What does SQL stand for?

Structured Question Language

Structured Query Language

Strong Question Language

Tias QA MySQL Quiz

Questions: 5 | Attempts: 415 | Last updated: Mar 21, 2025

Sample Question
The only way to join two tables is by using standard, ANSI syntax

TRUE

FALSE

Test Your Concepts About Database and MS Access Application!

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

Sample Question
The most suitable validation rule that can be entered for the DOB(Date of Birth) field in a table that restricts the date from 1/1/1950 to 1/1/1990 is

Greater than 1/1/1950 And less than 1/1/1990

>1/1/1950 And

>=#1/1/1950 And

From 1/1/1950 to 1/1/1990

« Previous 1 2 3 456 Next »

Advertisement