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
JTW Decoder

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

Books
How To

SQL Basics

1/25 The OR operator shows a record if any conditions listed are true. The AND operator shows a record if all of the conditions listed are true.
- True
- False
2/25 Which SQL statement is applied for returning only different values?
- SELECT UNIQUE
- SELECT INDENTITY
- SELECT DIFFERENT
- SELECT DISTINCT
3/25 Which SQL statement is used to delete data from a table?
- TRUNCATE
- DELETE
- REMOVE
4/25 Which of the terms below is used to describe a database that occupies magnetic storage in the terabyte range, as well as to describe a database that contains billons of table rows?
- Very Large Database
- Cold Fusion
- Holographic storage
5/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
6/25 Which SQL data type is used to store fixed-length character strings?
- VARCHAR
- TEXT
- CHAR
- STRING
7/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)
8/25 Which SQL statement adds a 'Salary' column to the 'Employees' table?
- ALTER TABLE Employees ADD COLUMN Salary int
- UPDATE TABLE Employees ADD Salary int
- MODIFY TABLE Employees ADD Salary int
- INSERT INTO Employees (Salary) VALUES (int)
9/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.
10/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
11/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.
12/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
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
14/25 Which SQL function is used to return the current date and time?
- GETDATE()
- CURRENT_TIMESTAMP
- NOW()
- DATETIME()
- TIMESTAMP()
15/25 How do you rename a column 'EmployeeName' to 'FullName' in the 'Employees' table?
- ALTER TABLE Employees RENAME COLUMN EmployeeName TO FullName
- UPDATE TABLE Employees CHANGE EmployeeName FullName
- ALTER TABLE Employees MODIFY COLUMN EmployeeName AS FullName
- RENAME COLUMN EmployeeName TO FullName IN Employees
16/25 What does the following SQL statement do: SELECT EmployeeName, SUM(Salary) OVER (PARTITION BY DepartmentID) FROM Employees?
- Summarizes the total salary for each department
- Displays an error as the syntax is incorrect
- Displays the sum of salaries within each department for each employee
- Calculates the overall sum of salaries in the Employees table
17/25 What is the purpose of the SQL 'WITH' clause?
- To provide a temporary name to a table or a set of columns
- To define a temporary subquery block that can be used in a SELECT statement
- To specify the conditions for a join
- To initialize variables within an SQL query
18/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)
19/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
20/25 Which SQL function is used to return the largest value of the selected column?
- MAX()
- BIG()
- UPPER()
- TOP()
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
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'
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)
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
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
To get the result of the quiz, please provide your email address (optional)..

It seems you haven't answered any questions yet. Please provide your answers to proceed.

Quizzes
Snippets
Our Books
- Learn HTML
- Learn CSS
- Learn Git
- Learn Javascript
- Learn PHP
- Learn python
- Learn Java
- Exercises
- HTML
- JavaScript
- Git
- CSS
- PHP
Our Tools

About Us
Privacy Policy for W3Docs

Follow Us

Company © W3docs. All rights reserved.