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 rename a table in SQL Server?

RENAME TABLE old_name TO new_name;

ALTER TABLE old_name RENAME TO new_name;

MODIFY TABLE old_name TO new_name;

EXEC sp_rename ‘old_name’, ‘new_name’;

2 / 20

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

INSERT INTO

ADD NEW

INSERT NEW

ADD INTO

3 / 20

Which SQL statement is used to create a new table?

ADD TABLE table_name (column1 data_type, column2 data_type);

CREATE 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);

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

NEW VIEW view_name AS SELECT column1, column2 FROM table_name;

ADD VIEW view_name AS SELECT column1, column2 FROM table_name;

CREATE VIEW view_name AS SELECT column1, column2 FROM table_name;

INSERT VIEW view_name AS SELECT column1, column2 FROM table_name;

5 / 20

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

NUMBER(*)

SUM(*)

TOTAL(*)

COUNT(*)

6 / 20

What is the purpose of the HAVING clause?

To filter records before the GROUP BY clause

To sort the results

To filter records after the GROUP BY clause

To specify the columns to be displayed

7 / 20

What does the SUM() function do?

Finds the highest value in a column

Counts the number of rows in a table

Adds up all the values in a column

Finds the average value in a column

8 / 20

How do you concatenate two strings in SQL Server?

CONCAT(string1, string2)

string1 || string2

string1 + string2

string1 & string2

9 / 20

How do you delete a record from a table?

REMOVE FROM table_name WHERE condition;

ERASE FROM table_name WHERE condition;

DELETE FROM table_name WHERE condition;

10 / 20

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

SELECT * FROM table_name WHERE column_name IS NOT ZERO;

SELECT * FROM table_name WHERE column_name IS NOT NULL;

SELECT * FROM table_name WHERE column_name IS NOT EMPTY;

SELECT * FROM table_name WHERE column_name IS NOT BLANK;

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

CHANGE table_name SET column1 = value1 WHERE condition;

UPDATE table_name SET column1 = value1 WHERE condition;

12 / 20

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

GETDATE()

SYSDATE()

CURRENT_DATE()

NOW()

13 / 20

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

SEPARATE

DISTINCT

UNIQUE

DIFFERENT

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

RENAME COLUMN old_name TO new_name;

MODIFY COLUMN old_name TO new_name;

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

15 / 20

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

ALTER TABLE table_name ADD column_name data_type;

MODIFY TABLE table_name ADD column_name data_type;

ADD COLUMN column_name data_type;

INSERT COLUMN column_name data_type;

16 / 20

What does the TRUNCATE statement do?

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

Deletes specific rows from a table

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

18 / 20

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

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

MIN()

LOWEST()

SMALLEST()

LEAST()

19 / 20

What does the COALESCE() function do?

Combines multiple columns into one

Splits a string into multiple parts

Returns the first non-null value in a list

Converts a value to a different data type

20 / 20

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

ARRANGE BY

SORT BY

GROUP BY

ORDER BY

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.