SQL Server MCQs with answers Page - 15

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. You want to track date and time of the last write access per row. Select the suitable option among the below.

  • (A) Add TIMESTAMP column to the table
  • (B) Add a DATETIME column to the table and assign getdate() as the default value
  • (C) Add a DATETIME column to the table and write a trigger that sets its value
  • (D) Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions

A

Admin • 833.24K Points
Coach

Q. ________ is a spatial data type.

  • (A) geometry
  • (B) sql_variant
  • (C) cursor
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. _____________ is monetary data type in SQL Server.

  • (A) Smallmoney
  • (B) sql_variant
  • (C) Cursor
  • (D) None of the Mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the data type has a storage size of 8 bytes?

  • (A) timestamp
  • (B) uniqueidentifier
  • (C) real
  • (D) smallmoney

A

Admin • 833.24K Points
Coach

Q. ______________ function returns current date and time.

  • (A) SET DATEFIRST
  • (B) SYSDATETIME
  • (C) Cert_ID
  • (D) GETDATE

A

Admin • 833.24K Points
Coach

Q. Which of the following function checks whether the expression is a valid date or not?

  • (A) ISDATE
  • (B) ISDAY
  • (C) ISVALID
  • (D) ISYEAR

A

Admin • 833.24K Points
Coach

Q. SQL server supports

  • (A) Permission system
  • (B) DDL triggers, aggregates & synonyms support
  • (C) XML Indexes
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Extended GUI feature supported by SQL server 2005 includes.

  • (A) Floating window & MDI
  • (B) Database explorer
  • (C) Powerful visual options
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. BLOB viewer /editor & master-detail view & card view all comes under.

  • (A) DML
  • (B) DDL
  • (C) Data manipulation tools
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. What is the standard form of RDBMS.

  • (A) Relational database management system
  • (B) Report database management system
  • (C) Relational data management system
  • (D) None of these

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.