SQL Server – Intermediate

Home
Quizzes
Blogs

SQL SERVER QUIZ - Intermediate

Welcome to your SQL Server Intermediate Quiz

1. What is the purpose of an SQL JOIN operation?

To filter rows in a table.

To combine rows from two or more tables.

To sort the result set.

To insert new rows into a table.

None

2. Which SQL command is used to retrieve unique values from a column?

SELECT DISTINCT

SELECT UNIQUE

SELECT UNIQUEVALUES

SELECT UNIQUE RECORDS

None

3. In SQL, what is the purpose of the GROUP BY clause?

To sort the result set.

To combine multiple tables.

To group rows with similar values and perform aggregate functions.

To filter rows based on a condition.

None

4. Which SQL command is used to change existing data in a table?

MODIFY

UPDATE

ALTER

CHANGE

None

5. What does the SQL term "Normalization" refer to?

The process of making data more complex.

The process of organizing data in a database to reduce redundancy and improve data integrity.

The process of creating indexes on columns.

The process of sorting data in ascending order.

None

6. Which SQL function is used to return the current date and time?

NOW()

GETDATE()

CURRENT_TIMESTAMP

DATE()

None

7. What is the purpose of the SQL ORDER BY clause?

To specify the table's primary key.

To filter rows based on a condition.

To sort the result set in ascending and descending order.

To group rows based on a common column.

None

8. Which SQL command is used to add a new table to an existing database?

INSERT TABLE

CREATE TABLE

ADD TABLE

NEW TABLE

None

9. What is the purpose of the SQL HAVING clause?

To specify a filter condition for rows.

To sort the result set.

To specify conditions for grouping rows.

To filter rows after grouping based on aggregate functions.

None

10. Which SQL data type is used to store variable-length character strings of a maximum length?

INT

VARCHAR

DATE

DECIMAL

None

1 out of 10

Please fill out the form to view your results!

We appreciate your participation in the Knowledge Challenge. Please complete the form to view your results. A copy will also be sent to your email shortly after submission.

Name

Phone

Time's up