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
The primary - foreign key relations are implemented to
cross-reference database tables.
clean-up the database.
to index the database.
Next >
2/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 >
3/25
How else can the table columns be called?
Attributes
Fields
Records
Next >
4/25
Which SQL data type is used to store fixed-length character strings?
VARCHAR
TEXT
CHAR
STRING
Next >
5/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 >
6/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 >
7/25
How do you update the 'Salary' column in the 'Employees' table for an employee with 'EmployeeID' 123 to 50000?
UPDATE Employees SET Salary = 50000 WHERE EmployeeID = 123
CHANGE Employees SET Salary = 50000 WHERE EmployeeID = 123
MODIFY Employees SET Salary = 50000 WHERE EmployeeID = 123
EDIT Employees SET Salary = 50000 FOR EmployeeID = 123
Next >
8/25
Which SQL statement is used to set a default value for a column?
SET DEFAULT
ALTER TABLE ... SET DEFAULT
MODIFY COLUMN ... DEFAULT
UPDATE COLUMN ... SET DEFAULT
Next >
9/25
Which SQL function is used to return the current date and time?
GETDATE()
CURRENT_TIMESTAMP
NOW()
DATETIME()
TIMESTAMP()
Next >
10/25
Which SQL clause is used to filter the results of a GROUP BY operation?
FILTER BY
HAVING
WHERE
GROUP WHERE
Next >
11/25
How do you delete a table named 'TemporaryData' only if it exists in the database?
DROP TABLE IF EXISTS TemporaryData
DELETE TABLE TemporaryData IF EXISTS
REMOVE TABLE TemporaryData WHEN EXISTS
DROP TABLE TemporaryData ONLY IF EXISTS
Next >
12/25
Which SQL statement is used to change the data type of a column in an existing table?
ALTER TABLE table_name MODIFY column_name new_data_type
UPDATE TABLE table_name SET column_name TYPE new_data_type
CHANGE TABLE table_name column_name new_data_type
MODIFY TABLE table_name column_name SET TYPE new_data_type
Next >
13/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 >
14/25
What is the primary purpose of the SQL 'INNER JOIN' clause?
To combine rows from two or more tables based on a related column between them
To retrieve rows that exist in one table but not in another
To select all rows from both tables regardless of the match between columns
To update records in one table based on values in another table
Next >
15/25
How do you find the total number of entries in a table named 'Orders'?
FIND COUNT(*) FROM Orders
SELECT COUNT(*) FROM Orders
COUNT ALL FROM Orders
TOTAL COUNT(*) IN Orders
Next >
16/25
Which statement correctly shows the use of an alias in SQL?
SELECT EmployeeID AS ID FROM Employees
SELECT EmployeeID RENAME ID FROM Employees
SELECT EmployeeID -> ID FROM Employees
SELECT EmployeeID NAME ID FROM Employees
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
What does the SQL 'UNION' operator do?
Joins the contents of two tables side by side
Combines the results of two or more SELECT statements into a single result set
Updates one table based on the contents of another
Deletes records in one table based on the contents of another
Next >
19/25
Which of the following is a valid type of SQL join?
CROSS JOIN
REVERSE JOIN
OUTER JOIN
LINK JOIN
RIGHT JOIN
Next >
20/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 >
21/25
In SQL, what is a subquery?
A query within another query
A function used to pass parameters to a query
A method to rename a query
A special operator to join queries
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
Which SQL clause is used to sort the result set in ascending or descending order?
SORT BY
ORDER BY
ARRANGE BY
SEQUENCE BY
Next >
24/25
In SQL, which command is used to add a new column to an existing table?
ADD COLUMN column_name TO table_name
INSERT COLUMN column_name INTO table_name
ALTER TABLE table_name ADD column_name column_type
UPDATE TABLE table_name SET ADD column_name column_type
Next >
25/25
What does the SQL 'CROSS JOIN' clause do?
Joins two tables in such a way that each row of the first table is combined with each row of the second table
Joins only the matching rows between two tables
Creates a join that can be filtered using a WHERE clause
Combines rows from two tables based on a related column
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.