SQL Server MCQ Questions with answers and solutions Page 8

Q. What does the ALTER TABLE clause do?

(A) The SQL ALTER TABLE clause is used to delete a database table
(B) THE SQL ALTER TABLE deletes data from database table
(C) The SQL ALTER TABLE clause is used to insert data into database table
(D) The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

✅ Correct Answer: (D) The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

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

Q. What do the letters in CRUD stand for?

(A) Crunch Read Uptime Downtime
(B) Create Run Unrun Data
(C) Craft Run Upload Database
(D) Create Read Update Delete

💬 Discuss

✅ Correct Answer: (D) Create Read Update Delete

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

Q. SQL views can be used to hide?

(A) Complicated SQL syntax
(B) Columns
(C) Rows
(D) All of the above

💬 Discuss

✅ Correct Answer: (D) All of the above

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

Q. The SQL SELECT statement is capable of

(A) Projection
(B) Selection
(C) Protection & Security
(D) Both A & B

💬 Discuss

✅ Correct Answer: (D) Both A & B

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

Q. Embedded SQL is which of the following?

(A) The process of making an application capable of generating specific SQL code on the fly.
(B) Hard-coded SQL statements in a program language such as Java.
(C) Hard-coded SQL statements in a procedure.
(D) Hard-coded SQL statements in a trigger.

💬 Discuss

✅ Correct Answer: (B) Hard-coded SQL statements in a program language such as Java.

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

Q. The arranging of data in a logical sequence is called

(A) Summarizing
(B) Sorting
(C) Classifying
(D) Rearranging

💬 Discuss

✅ Correct Answer: (B) Sorting

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

Q. Which of the SQL Server RTM included native support for managing XML data? Codename for SQL Server 2012 is __________

(A) 7.0Kilimanjaro
(B) 6.5Katmai
(C) 8Denali
(D) 9Hekaton

💬 Discuss

✅ Correct Answer: (D) 9Hekaton

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

Q. SQL Server 2005 has the following features?

(A) Dynamic Management Views
(B) FILESTREAM
(C) Powerpivot
(D) In-memory capability

💬 Discuss

✅ Correct Answer: (A) Dynamic Management Views

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

Q. _________ is a software application first launched with the Microsoft SQL Server 2005.

(A) Enterprise Manager
(B) Query Analyzer
(C) Business Intelligence Development Studio
(D) SQL Server Management Studio

💬 Discuss

✅ Correct Answer: (D) SQL Server Management Studio

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

Q. LocalDB was introduced in which of the following versions of SQL Server?

(A) 2008 R2
(B) 2014
(C) 2008
(D) 2012

💬 Discuss

✅ Correct Answer: (D) 2012

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

SQL Server MCQs with answers Page - 8

Q. What does the ALTER TABLE clause do?

Q. What do the letters in CRUD stand for?

Q. SQL views can be used to hide?

Q. The SQL SELECT statement is capable of

Q. Embedded SQL is which of the following?

Q. The arranging of data in a logical sequence is called

Q. Which of the SQL Server RTM included native support for managing XML data? Codename for SQL Server 2012 is __________

Q. SQL Server 2005 has the following features?

Q. _________ is a software application first launched with the Microsoft SQL Server 2005.

Q. LocalDB was introduced in which of the following versions of SQL Server?

Programming Categories

📱 Download Our App