SQL Server MCQs with answers Page - 27

Dear candidates you will find MCQ questions of SQL Server here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

R

Rajeev Malhotra • 3.97K Points
Extraordinary 

Q. What is a MULTI_USER in sql server?

  • (A) users that have the appropriate permissions to connect to the database are allowed
  • (B) One user at a time is allowed to connect to the database
  • (C) Only some members are allowed to access the database
  • (D) Only the system admin and some members are allowed to access the database

R

Rajeev Malhotra • 3.97K Points
Extraordinary 

Q. What is the difference between adhoc queries from stored procedures?

  • (A) Adhoc queries are placed embedded in the business logic code
  • (B) Stored procedures are placed embedded in the business logic code
  • (C) There is no difference as both are fired on the databases
  • (D) None of the above

R

Rajeev Malhotra • 3.97K Points
Extraordinary 

Q. A candidate key cannot be regarded as a possible primary key

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

S

Shivam • 8.86K Points
Tutor III 

Q. Which keyword is used in SQL Server to implement the auto increment?

  • (A) UNIQUE
  • (B) IDENTITY
  • (C) INCREMENT
  • (D) ADD

Loding content...

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.