SQL Server MCQ Questions with answers and solutions Page 26

Q. CREATE DATABASE has how many mandatory parameters?

(A) 1
(B) 2
(C) 3
(D) None of these

💬 Discuss

✅ Correct Answer: (A) 1

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:15 pm in SQL Server

Q. For every unique constraint on a column, SQL server will create

(A) Does not create any index
(B) clustered index for that column
(C) index for that column
(D) non-clustered index for that column

💬 Discuss

✅ Correct Answer: (D) non-clustered index for that column

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:16 pm in SQL Server

Q. Which operation, when performed on a database can throw an error

(A) “The database could not be exclusively locked to perform the operation”
(B) DELETE database
(C) DROP database
(D) Rename database

💬 Discuss

✅ Correct Answer: (D) Rename database

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:16 pm in SQL Server

Q. What is the syntax for creating new login on the SQL sevrer?

(A) USE LOGIN login_id WITH PASSWORD password
(B) CREATE LOGIN login_id WITH USE password
(C) CREATE LOGIN login_id USE password
(D) CREATE LOGIN login_id WITH PASSWORD password

💬 Discuss

✅ Correct Answer: (D) CREATE LOGIN login_id WITH PASSWORD password

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:16 pm in SQL Server

Q. An index can be defined for a single column

(A) True
(B) False
(C) NA
(D) NA

💬 Discuss

✅ Correct Answer: (B) False

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:17 pm in SQL Server

Q. Why type of user is the default in sql server?

(A) SINGLE_USER
(B) MULTI_USER
(C) RESTRICTED_USER
(D) ROOT_USER

💬 Discuss

✅ Correct Answer: (B) MULTI_USER

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:17 pm in SQL Server

Q. When SQL server is installed, which of the following databases are created by default?

(A) Master
(B) Model
(C) Both a and b
(D) Root

💬 Discuss

✅ Correct Answer: (C) Both a and b

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:17 pm in SQL Server

Q. Stored procedures are safe from SQL injection attacks

(A) True
(B) False
(C) NA
(D) NA

💬 Discuss

✅ Correct Answer: (A) True

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:17 pm in SQL Server

Q. Which of the following below are valid database states?

(A) OFFLINE
(B) SUSPECT
(C) EMERGENCY
(D) All of the above

💬 Discuss

✅ Correct Answer: (D) All of the above

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:18 pm in SQL Server

Q. Can we temporarily disable a login name?

(A) Yes
(B) No
(C) NA
(D) NA

💬 Discuss

✅ Correct Answer: (A) Yes

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:18 pm in SQL Server

Previous
First
26
27
Last
Next

Jump to