SQL Server Basic Data Manipulation – Beginner-Level Quiz

SQL Server Basic Data Manipulation - Beginner Level Quiz

This quiz tests your knowledge of basic data manipulation in SQL Server. It covers basic operations such as inserting, updating, deleting data, and using basic functions. Each question is multiple-choice, with one correct answer.

1 / 20

What does the SQL statement SELECT AVG(salary) FROM employees;do?

Finds the lowest salary among employees

Calculates the total salary of all employees

Finds the highest salary among employees

Calculates the average salary of all employees

2 / 20

What does the ROUND() function do?

Calculates the square root of a number

Finds the nearest integer

Rounds a number to a specified number of decimal places

Finds the absolute value of a number

3 / 20

What does the COALESCE() function do?

Returns the first non-null value in a list

Combines multiple columns into one

Splits a string into multiple parts

Converts a value to a different data type

4 / 20

How do you change the name of a column in SQL Server?

A) RENAME COLUMN old_name TO new_name;
B) ALTER COLUMN old_name RENAME TO new_name;
C) EXEC sp_rename ‘table_name.old_name’, ‘new_name’, ‘COLUMN’;
D) MODIFY COLUMN old_name TO new_name;

ALTER COLUMN old_name RENAME TO new_name;

MODIFY COLUMN old_name TO new_name;

EXEC sp_rename ‘table_name.old_name’, ‘new_name’, ‘COLUMN’;

RENAME COLUMN old_name TO new_name;

5 / 20

Which SQL statement is used to remove a table from the database?

DROP TABLE table_name;

DELETE TABLE table_name;

REMOVE TABLE table_name;

ERASE TABLE table_name;

6 / 20

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

CURRENT_DATE()

NOW()

GETDATE()

SYSDATE()

7 / 20

What is the purpose of the HAVING clause?

To filter records after the GROUP BY clause

To specify the columns to be displayed

To filter records before the GROUP BY clause

To sort the results

8 / 20

What is the purpose of the WHERE clause in SQL Server?

To specify the table to be queried

To filter records based on a condition

To sort the results

To specify the columns to be displayed

9 / 20

What does the TRUNCATE statement do?

Deletes all rows from a table and can be rolled back

Deletes specific rows from a table

Deletes all rows from a table and cannot be rolled back

Deletes the table structure

10 / 20

Which function is used to count the number of rows in a table?

COUNT(*)

NUMBER(*)

TOTAL(*)

SUM(*)

11 / 20

What does the SUM() function do?

Counts the number of rows in a table

Adds up all the values in a column

Finds the average value in a column

Finds the highest value in a column

12 / 20

Which SQL statement is used to create a new table?

CREATE TABLE table_name (column1 data_type, column2 data_type);

ADD TABLE table_name (column1 data_type, column2 data_type);

NEW TABLE table_name (column1 data_type, column2 data_type);

INSERT TABLE table_name (column1 data_type, column2 data_type);

13 / 20

Which of the following SQL keywords is used to retrieve unique values?

DIFFERENT

UNIQUE

SEPARATE

DISTINCT

14 / 20

What is the correct syntax for inserting multiple rows into a table?

INSERT INTO table_name VALUES (value1, value2) AND (value3, value4);

ADD INTO table_name VALUES (value1, value2), (value3, value4);

INSERT INTO table_name VALUES (value1, value2), (value3, value4);

INSERT INTO table_name (value1, value2), (value3, value4);

15 / 20

How do you remove a column from a table?

ALTER TABLE table_name DROP COLUMN column_name;

DROP COLUMN column_name;

REMOVE COLUMN column_name;

DELETE COLUMN column_name;

16 / 20

How do you retrieve records where a column value is not null?

SELECT * FROM table_name WHERE column_name IS NOT EMPTY;

SELECT * FROM table_name WHERE column_name IS NOT ZERO;

SELECT * FROM table_name WHERE column_name IS NOT BLANK;

SELECT * FROM table_name WHERE column_name IS NOT NULL;

17 / 20

What does the IS NULL condition do?

Checks if a column has a value

Checks if a column is zero

Checks if a column is empty

Checks if a column has no value

18 / 20

How do you concatenate two strings in SQL Server?

string1 & string2

string1 + string2

string1 || string2

CONCAT(string1, string2)

19 / 20

Which SQL statement is used to insert new data into a table?

INSERT NEW

ADD NEW

INSERT INTO

ADD INTO

20 / 20

How do you delete a record from a table?

DELETE FROM table_name WHERE condition;

ERASE FROM table_name WHERE condition;

REMOVE FROM table_name WHERE condition;

DELETE FROM table_name WHERE condition;

Your score is

The average score is 49%

Use this beginner-level quiz on fundamental SQL Server basic data manipulation to improve your data manipulation skills. This quiz covers fundamental functions like COUNT, SUM, and AVG and important SQL operations like INSERT, UPDATE, and DELETE.

The quiz is ideal for beginners who want to solidify their understanding of SQL Server data manipulation techniques. Our carefully selected multiple-choice questions will help you test your knowledge and improve your skills.

All the best.