Exercises
Tools
General Tools
CSS Maker
Color Tools
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
SQL Basics
-
1/25 How to select a column named "ProductName" from a table named "Products" with SQL?
-
2/25 With SQL, how do you select all the columns from a table named "Products"?
-
3/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.
-
4/25 Which SQL statement is applied for updating data in a database?
-
5/25 Which SQL statement is applied for returning only different values?
-
6/25 The primary - foreign key relations are implemented to
-
7/25 How else can the table columns be called?
-
8/25 Can the SELECT clause list have a computed value like in the example below? SELECT CustomerName, UnitPrice * NumberofUnits FROM Sale.
-
9/25 Which of the following is an open standard application programming interface(API) for accessing a database?
-
10/25 How do you use a subquery to find names of customers who have placed orders in an 'Orders' table?
-
11/25 Which SQL statement adds a 'Salary' column to the 'Employees' table?
-
12/25 What is the purpose of constraints in SQL?
-
13/25 How do you create an index on the 'EmployeeName' column of the 'Employees' table for faster queries?
-
14/25 How can you lock a table 'Employees' for read and write operations to maintain data integrity?
-
15/25 Which of the following is a valid SQL aggregate function?
-
16/25 What is the result of the following query: SELECT COUNT(DISTINCT EmployeeName) FROM Employees?
-
17/25 Which SQL function is used to return the current date and time?
-
18/25 What does the following SQL statement do: SELECT EmployeeName, SUM(Salary) OVER (PARTITION BY DepartmentID) FROM Employees?
-
19/25 Which of the following is NOT a valid aggregate function in SQL?
-
20/25 Which SQL statement is used to change the data type of a column in an existing table?
-
21/25 Which statement correctly shows the use of an alias in SQL?
-
22/25 In SQL, which command is used to change the structure of a table such as adding a column or changing a column type?
-
23/25 Which of the following is a valid type of SQL join?
-
24/25 How can you insert multiple rows into a table named 'Orders'?
-
25/25 Which SQL clause is used to sort the result set in ascending or descending order?
-
It seems you haven't answered any questions yet. Please provide your answers to proceed.