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

EN
DE
RU
FR
ES

Books
How To

SQL Basics

1/25 What SQL keyword is applied for sorting the result-set?
- SORT BY
- ORDER
- ORDER BY
- SORT
2/25 Which SQL statement is applied for updating data in a database?
- UPDATE
- SAVE AS
- MODIFY
- SAVE
3/25 The primary - foreign key relations are implemented to
- cross-reference database tables.
- clean-up the database.
- to index the database.
4/25 Once AUTOCOMMIT is set on, changes will be made automatically at the end of every SQL statement.
- True
- False
5/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.
6/25 Which of the following statements is true about embedded SQL?
- Hard-coded SQL statements in a program language such as Java.
- The process of making an application capable of generating specific SQL code on the fly.
- Hard-coded SQL statements in a procedure.
- Hard-coded SQL statements in a trigger.
- Embedded SQL is applied for returning data that will be used in the main query as a condition.
7/25 Which of the following statements is true about systems information in an RDBMS?
- RDBMS stores database definition information in system-created tables.
- Such information can be accessed with SQL.
- Often, such information cannot be updated by a user.
- All of the above.
8/25 What does the TRUNCATE TABLE do?
- Deletes all rows from a table
- Deletes the table
- Checks if the table has primary key specified
9/25 Which SQL data type is used to store fixed-length character strings?
- VARCHAR
- TEXT
- CHAR
- STRING
10/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)
11/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.
12/25 How can you lock a table 'Employees' for read and write operations to maintain data integrity?
- LOCK TABLE Employees READ, WRITE
- SET LOCK ON Employees
- EMPLOYEES LOCK SET READ, WRITE
- TABLE Employees SET LOCK
13/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)
14/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
15/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
16/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
17/25 Which SQL function is used to return the current date and time?
- GETDATE()
- CURRENT_TIMESTAMP
- NOW()
- DATETIME()
- TIMESTAMP()
18/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
19/25 Which SQL clause is used to filter the results of a GROUP BY operation?
- FILTER BY
- HAVING
- WHERE
- GROUP WHERE
20/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
21/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
22/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)
23/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
24/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
25/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
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.