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

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

ADD COLUMN column_name data_type;

INSERT COLUMN column_name data_type;

ALTER TABLE table_name ADD column_name data_type;

MODIFY TABLE table_name ADD column_name data_type;

2 / 20

How do you remove a column from a table?

ALTER TABLE table_name DROP COLUMN column_name;

DELETE COLUMN column_name;

DROP COLUMN column_name;

REMOVE COLUMN column_name;

3 / 20

What does the TRUNCATE statement do?

Deletes specific rows from a table

Deletes the table structure

Deletes all rows from a table and can be rolled back

Deletes all rows from a table and cannot be rolled back

4 / 20

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

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

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

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

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

5 / 20

Which SQL statement is used to create a new table?

ADD TABLE table_name (column1 data_type, column2 data_type);

NEW TABLE table_name (column1 data_type, column2 data_type);

CREATE TABLE table_name (column1 data_type, column2 data_type);

INSERT TABLE table_name (column1 data_type, column2 data_type);

6 / 20

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

GROUP BY

ORDER BY

SORT BY

ARRANGE BY

7 / 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;

8 / 20

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

DIFFERENT

UNIQUE

SEPARATE

DISTINCT

9 / 20

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

DROP TABLE table_name;

DELETE TABLE table_name;

ERASE TABLE table_name;

REMOVE TABLE table_name;

10 / 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

11 / 20

Which function is used to find the minimum value in a column?

A) MIN()
B) LEAST()
C) LOWEST()
D) SMALLEST()

MIN()

LEAST()

LOWEST()

SMALLEST()

12 / 20

What does the IS NULL condition do?

Checks if a column has no value

Checks if a column is zero

Checks if a column has a value

Checks if a column is empty

13 / 20

Which SQL statement is used to create a view?

A) CREATE VIEW view_name AS SELECT column1, column2 FROM table_name;
B) ADD VIEW view_name AS SELECT column1, column2 FROM table_name;
C) NEW VIEW view_name AS SELECT column1, column2 FROM table_name;
D) INSERT VIEW view_name AS SELECT column1, column2 FROM table_name;

ADD VIEW view_name AS SELECT column1, column2 FROM table_name;

INSERT VIEW view_name AS SELECT column1, column2 FROM table_name;

CREATE VIEW view_name AS SELECT column1, column2 FROM table_name;

NEW VIEW view_name AS SELECT column1, column2 FROM table_name;

14 / 20

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

ADD NEW

INSERT NEW

ADD INTO

INSERT INTO

15 / 20

What does the SUM() function do?

Adds up all the values in a column

Counts the number of rows in a table

Finds the average value in a column

Finds the highest value in a column

16 / 20

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

UPDATE table_name SET column1 = value1 WHERE condition;

ALTER table_name SET column1 = value1 WHERE condition;

CHANGE table_name SET column1 = value1 WHERE condition;

MODIFY table_name SET column1 = value1 WHERE condition;

17 / 20

What does the COALESCE() function do?

Converts a value to a different data type

Returns the first non-null value in a list

Combines multiple columns into one

Splits a string into multiple parts

18 / 20

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

MODIFY COLUMN column_name data_type;

ALTER COLUMN column_name data_type;

ALTER TABLE table_name ALTER COLUMN column_name data_type;

CHANGE COLUMN column_name data_type;

19 / 20

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

To sort the results

To specify the table to be queried

To filter records based on a condition

To specify the columns to be displayed

20 / 20

How do you delete a record from a table?

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 0%

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.