SQL Server MCQ Questions with answers and solutions Page 18

Q. ________________ is not a category of SQL command.

(A) DDL
(B) DCL
(C) SCL
(D) TCL

💬 Discuss

✅ Correct Answer: (C) SCL

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 07:51 pm in SQL Server

Q. Which of the following are TCL commands?

(A) ROLLBACK and SAVEPOINT
(B) GRANT and REVOKE
(C) SELECT and INSERT
(D) UPDATE and TRUNCATE

💬 Discuss

✅ Correct Answer: (A) ROLLBACK and SAVEPOINT

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 07:52 pm in SQL Server

Q. Which of the following is not a DDL command?

(A) ALTER
(B) UPDATE
(C) TRUNCATE
(D) None of the Mentioned

💬 Discuss

✅ Correct Answer: (B) UPDATE

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 07:52 pm in SQL Server

Q. ___________removes all rows from a table without logging the individual row deletions.

(A) TRUNCATE
(B) DROP
(C) REMOVE
(D) DELETE

💬 Discuss

✅ Correct Answer: (A) TRUNCATE

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 07:53 pm in SQL Server

Q. The UPDATE SQL clause can _____________

(A) update only one row at a time
(B) update more than one row at a time
(C) delete more than one row at a time
(D) delete only one row at a time

💬 Discuss

✅ Correct Answer: (B) update more than one row at a time

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:21 pm in SQL Server

Q. The UNION SQL clause can be used with _____________

(A) SELECT clause only
(B) DELETE and UPDATE clauses
(C) UPDATE clause only
(D) All of the mentioned

💬 Discuss

✅ Correct Answer: (A) SELECT clause only

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:22 pm in SQL Server

Q. Which SQL statement is used to return only different values?

(A) SELECT DIFFERENT
(B) SELECT UNIQUE
(C) SELECT DISTINCT
(D) SELECT ALL

💬 Discuss

✅ Correct Answer: (C) SELECT DISTINCT

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:23 pm in SQL Server

Q. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

(A) UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
(B) MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
(C) MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
(D) UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

💬 Discuss

✅ Correct Answer: (D) UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:23 pm in SQL Server

Q. Which TCL command undo all the updates performed by the SQL in the transaction?

(A) DELETE
(B) TRUNCATE
(C) COMMIT
(D) ROLLBACK

💬 Discuss

✅ Correct Answer: (C) COMMIT

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:24 pm in SQL Server

Q. SQL query to find all the cities whose humidity is 95.

(A) SELECT city WHERE humidity = 95
(B) SELECT city FROM weather WHERE humidity = 95
(C) SELECT humidity = 89 FROM weather
(D) SELECT city FROM weather

💬 Discuss

✅ Correct Answer: (B) SELECT city FROM weather WHERE humidity = 95

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:25 pm in SQL Server

SQL Server MCQs with answers Page - 18

Q. ________________ is not a category of SQL command.

Q. Which of the following are TCL commands?

Q. Which of the following is not a DDL command?

Q. ___________removes all rows from a table without logging the individual row deletions.

Q. The UPDATE SQL clause can _____________

Q. The UNION SQL clause can be used with _____________

Q. Which SQL statement is used to return only different values?

Q. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

Q. Which TCL command undo all the updates performed by the SQL in the transaction?

Q. SQL query to find all the cities whose humidity is 95.

Programming Categories

📱 Download Our App