SQL Server MCQs with answers Page - 14

Here, you will find a collection of MCQ questions on SQL Server. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. T-SQL provides enhancement regarding

  • (A) Error handling & recursive query
  • (B) Relational operator & pivot row number
  • (C) Both A and B
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. ADO stands for

  • (A) ActiveX data object
  • (B) Active data object
  • (C) Animated data object
  • (D) All of the above.

A

Admin • 833.24K Points
Coach

Q. Microsoft SQL Server is a

  • (A) DBMS
  • (B) RDBMS
  • (C) Both A and B
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. Database software focus on

  • (A) Data of a database
  • (B) Structure of the database
  • (C) Data structure of the database
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. SQL server operators on the operating system platform.

  • (A) Windows server 2003 SP1
  • (B) Windows 2000 edition SP4
  • (C) Windows XP professional sp2
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. To display all the view in SQL 2005 to launch …… expand the database, system database & select master, view system view.

  • (A) SQL management
  • (B) SQL management studio
  • (C) Management studio
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. Three-tier architecture include.

  • (A) Server client & middle tier
  • (B) Server middle tier
  • (C) Client middle tier
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. SQL server 2005 supports fields line

  • (A) Varchar
  • (B) Navarchar
  • (C) Varbinary fields
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Exact Numeric data type is ___________

  • (A) bigint
  • (B) int
  • (C) smallmoney
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. ntext data type falls under which category?

  • (A) Exact numerics
  • (B) Character strings
  • (C) Unicode character strings
  • (D) None of the mentioned

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.