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

Books
How To

SQL Basics

1/25 With SQL, how do you select all the columns from a table named "Products"?
- SELECT [all] FROM Products
- SELECT All Products
- SELECT *.Products
- SELECT * FROM Products
2/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
3/25 Which SQL statement is applied for returning only different values?
- SELECT UNIQUE
- SELECT INDENTITY
- SELECT DIFFERENT
- SELECT DISTINCT
4/25 The primary - foreign key relations are implemented to
- cross-reference database tables.
- clean-up the database.
- to index the database.
5/25 Once AUTOCOMMIT is set on, changes will be made automatically at the end of every SQL statement.
- True
- False
6/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.
7/25 Which of the SQL statements below deletes all the rows in a table called PricesData?
- DELETE ALL PricesData
- DELETE PricesData
- DELETE FROM PricesData
- DELETE rows FROM PricesData
8/25 Can the SELECT clause list have a computed value like in the example below? SELECT CustomerName, UnitPrice * NumberofUnits FROM Sale.
- No
- Yes
9/25 What does the TRUNCATE TABLE do?
- Deletes all rows from a table
- Deletes the table
- Checks if the table has primary key specified
10/25 Which of the following is an open standard application programming interface(API) for accessing a database?
- Topic Map Query Language
- Open Database Connectivity
- Open Data-Link Interface
- Universal Data Access
11/25 Which SQL data type is used to store fixed-length character strings?
- VARCHAR
- TEXT
- CHAR
- STRING
12/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)
13/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.
14/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
15/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
16/25 Which of the following is NOT a valid aggregate function in SQL?
- SUM()
- AVERAGE()
- MAX()
- COUNT()
17/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
18/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
19/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
20/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
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 Which SQL statement is used to return only distinct (different) values?
- SELECT UNIQUE column_name FROM table_name
- SELECT DISTINCT column_name FROM table_name
- SELECT DIFFERENT column_name FROM table_name
- SELECT column_name FROM table_name DISTINCT
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 How do you find the minimum value in a column named 'Price' from the 'Products' table?
- SELECT MIN(Price) FROM Products
- FIND MINIMUM(Price) IN Products
- SELECT LOWEST(Price) FROM Products
- GET MIN(Price) FROM Products
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.