Books
Learn HTML
Learn CSS
Learn Git
Learn Javascript
Learn PHP
Learn python
Learn Java
Exercises
HTML
JavaScript
Git
CSS
PHP
Courses
Quizzes
Snippets
Tools
General Tools
Password Generator
HTML Editor
HTML Encoder
Base 64
Code Diff
JSON Beautifier
CSS Beautifier
Markdown Convertor
Find the Closest Tailwind CSS Color
Phrase encrypt / decrypt
Browser Feature Detection
Number convertor
CSS Maker
CSS Maker
CSS Maker text shadow
CSS Maker Text Rotation
CSS Maker Out Line
CSS Maker RGB Shadow
CSS Maker Transform
CSS Maker Font Face
Color Tools
Color Picker
Colors CMYK
Colors HWB
Colors HSL
Color Hex
Color mixer
Color Converter
Colors RGB
Color Contrast Analyzer
Color Gradient
String Tools
String Length Calculator
MD5 Hash Generator
Sha256 Hash Generator
String Reverse
URL Encoder
URL Decoder
Base 64 Encoder
Base 64 Decoder
Extra Spaces Remover
String to Lowercase
String to Uppercase
Word Count Calculator
Empty Lines Remover
HTML Tags Remover
Binary to Hex
Hex to Binary
Rot13 Transform on a String
String to Binary
Duplicate Lines Remover
Change theme
Dark
Light
System
Books
Learn HTML
Learn CSS
Learn Git
Learn Javascript
Learn PHP
Learn python
Learn Java
How To
How To NodeJs
How To Linux
How To AngularJs
How To PHP
How To HTML
How To CSS
How To Symfony
How To Git
How To Apache
How To JavaScript
How To Java
How To Vue.js
How To Python
SQL Basics
1/25
Which of the following is true about CASE SQL statement?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.
Next >
2/25
How else can the table columns be called?
Attributes
Fields
Records
Next >
3/25
How do you use a subquery to find names of customers who have placed orders in an 'Orders' table?
SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders)
SELECT CustomerID FROM Orders WHERE Name IN (SELECT Name FROM Customers)
SELECT Name FROM Customers WHERE EXISTS (SELECT CustomerID FROM Orders)
SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID
Next >
4/25
How do you create a new table named 'Employees' with columns 'EmployeeID' (integer) and 'EmployeeName' (varchar)?
CREATE TABLE Employees (EmployeeID int, EmployeeName varchar)
NEW TABLE Employees (EmployeeID int, EmployeeName string)
CREATE Employees (EmployeeID integer, EmployeeName text)
TABLE Employees ADD (EmployeeID int, EmployeeName varchar)
Next >
5/25
What is the purpose of constraints in SQL?
To limit the type of data that can be stored in a column.
To join tables together based on a condition.
To sort the data in ascending or descending order.
To group data based on column values.
Next >
6/25
What is the purpose of a view in SQL?
To create a virtual table based on the result-set of an SQL statement.
To insert new rows into a table.
To define new data types.
To permanently store data.
Next >
7/25
What does the SQL statement 'BEGIN TRANSACTION' do?
Starts a new SQL transaction.
Creates a new table called TRANSACTION.
Begins a new subquery.
Starts a new index creation process.
Next >
8/25
How do you use the GROUP BY clause in conjunction with aggregate functions?
SELECT COUNT(EmployeeID), Department FROM Employees GROUP BY Department
GROUP Employees BY Department WITH COUNT(EmployeeID)
SELECT Department, COUNT(EmployeeID) FROM Employees GROUP BY EmployeeID
SELECT Department FROM Employees GROUP BY COUNT(EmployeeID)
Next >
9/25
How can you combine results from multiple SELECT statements in SQL?
USING UNION
WITH COMBINE
USING UNION ALL
USING JOIN
USING UNION or UNION ALL
Next >
10/25
In SQL, what does the 'BETWEEN' operator do?
Checks whether a value lies within a specified range.
Compares two values for equality.
Sorts the result set between two columns.
Divides the result set into two parts.
Next >
11/25
Which SQL statement is used to return the number of records in the 'Employees' table?
COUNT(Employees)
SELECT COUNT(*) FROM Employees
GET NUMBER OF Employees
SELECT ROWS FROM Employees
Next >
12/25
How do you perform a LEFT JOIN between 'Employees' and 'Departments' tables on the 'DepartmentID' column?
SELECT * FROM Employees LEFT JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID
JOIN Employees, Departments USING (DepartmentID)
SELECT * FROM Employees, Departments WHERE Employees.DepartmentID = Departments.DepartmentID
SELECT * FROM Employees JOIN Departments ON DepartmentID
Next >
13/25
What is the result of the following query: SELECT COUNT(DISTINCT EmployeeName) FROM Employees?
The total number of rows in the Employees table
The number of unique employee names in the Employees table
A syntax error
The first unique employee name in the Employees table
Next >
14/25
Which SQL clause is used to filter the results of a GROUP BY operation?
FILTER BY
HAVING
WHERE
GROUP WHERE
Next >
15/25
Which of the following is NOT a valid aggregate function in SQL?
SUM()
AVERAGE()
MAX()
COUNT()
Next >
16/25
Which statement is used to add a new row to a table in SQL?
ADD ROW INTO tableName (column1, column2) VALUES (value1, value2)
INSERT INTO tableName (column1, column2) VALUES (value1, value2)
CREATE ROW IN tableName (column1, column2) VALUES (value1, value2)
APPEND INTO tableName (column1, column2) VALUES (value1, value2)
Next >
17/25
In SQL, which command is used to change the structure of a table such as adding a column or changing a column type?
MODIFY TABLE
CHANGE TABLE
ALTER TABLE
UPDATE TABLE
Next >
18/25
How can you retrieve unique values from the column 'EmployeeName' of the 'Employees' table?
SELECT DISTINCT EmployeeName FROM Employees
SELECT UNIQUE EmployeeName FROM Employees
GET ALL UNIQUE EmployeeName FROM Employees
SELECT EmployeeName FROM Employees DISTINCT
Next >
19/25
Which SQL function is used to return the largest value of the selected column?
MAX()
BIG()
UPPER()
TOP()
Next >
20/25
Which of the following is a valid type of SQL join?
CROSS JOIN
REVERSE JOIN
OUTER JOIN
LINK JOIN
RIGHT JOIN
Next >
21/25
What is the purpose of the 'GROUP BY' clause in SQL?
To group rows that have the same values in specified columns into summary rows
To group the output of a SQL query by the values of a specific column
To sort the result set of a query by the specified column values
To filter rows based on the condition specified by the aggregate function
Next >
22/25
How do you select all records from a table named 'Customers' where the 'CustomerName' starts with 'A'?
SELECT * FROM Customers WHERE CustomerName LIKE 'A%'
SELECT * FROM Customers WHERE CustomerName = 'A*'
SELECT * FROM Customers WHERE CustomerName STARTS WITH 'A'
SELECT * FROM Customers WHERE CustomerName BEGINS WITH 'A'
Next >
23/25
How can you insert multiple rows into a table named 'Orders'?
INSERT INTO Orders VALUES (value1, value2), (value3, value4)
INSERT MULTIPLE INTO Orders VALUES (value1, value2), (value3, value4)
ADD INTO Orders VALUES (value1, value2), (value3, value4)
INSERT INTO Orders VALUES (value1, value2) AND (value3, value4)
Next >
24/25
Which SQL clause is used to sort the result set in ascending or descending order?
SORT BY
ORDER BY
ARRANGE BY
SEQUENCE BY
Next >
25/25
What is the function of the 'HAVING' clause in SQL?
To specify a search condition for a group or an aggregate function used in SELECT statement
To filter records before the GROUP BY clause
To join multiple tables based on a condition
To specify the order of records
Next >
To get the result of the quiz, please provide your email address (optional)..
Get Certificate
It seems you haven't answered any questions yet. Please provide your answers to proceed.