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 is the correct syntax for inserting multiple rows into a table?

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

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

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

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

2 / 20

Which SQL statement is used to create a new table?

NEW TABLE table_name (column1 data_type, column2 data_type);

INSERT TABLE table_name (column1 data_type, column2 data_type);

ADD TABLE table_name (column1 data_type, column2 data_type);

CREATE TABLE table_name (column1 data_type, column2 data_type);

3 / 20

Which SQL statement is used to change the data type of a column?

MODIFY COLUMN column_name data_type;

CHANGE COLUMN column_name data_type;

ALTER COLUMN column_name data_type;

ALTER TABLE table_name ALTER COLUMN column_name data_type;

4 / 20

What does the SUM() function do?

Finds the average value in a column

Adds up all the values in a column

Finds the highest value in a column

Counts the number of rows in a table

5 / 20

How do you rename a table in SQL Server?

RENAME TABLE old_name TO new_name;

MODIFY TABLE old_name TO new_name;

EXEC sp_rename ‘old_name’, ‘new_name’;

ALTER TABLE old_name RENAME TO new_name;

6 / 20

What does the IS NULL condition do?

Checks if a column has a value

Checks if a column has no value

Checks if a column is empty

Checks if a column is zero

7 / 20

What is the purpose of the HAVING clause?

To specify the columns to be displayed

To sort the results

To filter records before the GROUP BY clause

To filter records after the GROUP BY clause

8 / 20

Which SQL Server clause is used to sort the result set?

ORDER BY

GROUP BY

SORT BY

ARRANGE BY

9 / 20

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

ADD NEW

INSERT NEW

ADD INTO

INSERT INTO

10 / 20

What does the ROUND() function do?

Finds the absolute value of a number

Finds the nearest integer

Rounds a number to a specified number of decimal places

Calculates the square root of a number

11 / 20

What does the TRUNCATE statement do?

Deletes specific rows from a table

Deletes the table structure

Deletes all rows from a table and cannot be rolled back

Deletes all rows from a table and can be rolled back

12 / 20

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

ERASE TABLE table_name;

DELETE TABLE table_name;

REMOVE TABLE table_name;

DROP TABLE table_name;

13 / 20

Which of the following is the correct syntax to update a record in a table?

MODIFY table_name SET column1 = value1 WHERE condition;

ALTER table_name SET column1 = value1 WHERE condition;

UPDATE table_name SET column1 = value1 WHERE condition;

CHANGE table_name SET column1 = value1 WHERE condition;

14 / 20

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

SELECT * FROM table_name WHERE column_name IS NOT NULL;

SELECT * FROM table_name WHERE column_name IS NOT BLANK;

SELECT * FROM table_name WHERE column_name IS NOT EMPTY;

SELECT * FROM table_name WHERE column_name IS NOT ZERO;

15 / 20

How do you concatenate two strings in SQL Server?

string1 & string2

string1 || string2

string1 + string2

CONCAT(string1, string2)

16 / 20

How do you retrieve the first 10 records from a table?

SELECT * FROM table_name FETCH FIRST 10 ROWS ONLY;

SELECT * FROM table_name LIMIT 10;

SELECT FIRST 10 * FROM table_name;

SELECT TOP 10 * FROM table_name;

17 / 20

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

CURRENT_DATE()

SYSDATE()

GETDATE()

NOW()

18 / 20

How do you add a new column to an existing table?

ALTER TABLE table_name ADD column_name data_type;

ADD COLUMN column_name data_type;

INSERT COLUMN column_name data_type;

MODIFY TABLE table_name ADD column_name data_type;

19 / 20

What does the LEN() function do?

Returns the length of a row

Returns the length of a string

Returns the length of a table

Returns the length of a column

20 / 20

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

Finds the highest salary among employees

Calculates the total salary of all employees

Finds the lowest salary among employees

Calculates the average salary of all employees

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.