Interview Questions

AJAX Interview Questions Android Interview Questions Angular 2 Interview Questions AngularJs Interview Questions Apache Presto Interview Questions Apache Tapestry Interview Questions Arduino Interview Questions ASP.NET MVC Interview Questions Aurelia Interview Questions AWS Interview Questions Blockchain Interview Questions Bootstrap Interview Questions C Interview Questions C Programming Coding Interview Questions C# Interview Questions Cakephp Interview Questions Cassandra Interview Questions CherryPy Interview Questions Clojure Interview Questions Cobol Interview Questions CodeIgniter interview Questions CoffeeScript Interview Questions Cordova Interview Questions CouchDB interview questions CSS Buttons Interview Questions CSS Interview Questions D Programming Language Interview Questions Dart Programming Language Interview Questions Data structure & Algorithm Interview Questions DB2 Interview Questions DBMS Interview Questions Django Interview Questions Docker Interview Questions DOJO Interview Questions Drupal Interview Questions Electron Interview Questions Elixir Interview Questions Erlang Interview Questions ES6 Interview Questions and Answers Euphoria Interview Questions ExpressJS Interview Questions Ext Js Interview Questions Firebase Interview Questions Flask Interview Questions Flex Interview Questions Fortran Interview Questions Foundation Interview Questions Framework7 Interview Questions FuelPHP Framework Interview Questions Go Programming Language Interview Questions Google Maps Interview Questions Groovy interview Questions GWT Interview Questions Hadoop Interview Questions Haskell Interview Questions Highcharts Interview Questions HTML Interview Questions HTTP Interview Questions Ionic Interview Questions iOS Interview Questions IoT Interview Questions Java BeanUtils Interview Questions Java Collections Interview Questions Java Interview Questions Java JDBC Interview Questions Java Multithreading Interview Questions Java OOPS Interview Questions Java Programming Coding Interview Questions Java Swing Interview Questions JavaFX Interview Questions JavaScript Interview Questions JCL (Job Control Language) Interview Questions Joomla Interview Questions jQuery Interview Questions js Interview Questions JSF Interview Questions JSP Interview Questions KnockoutJS Interview Questions Koa Interview Questions Laravel Interview Questions Less Interview Questions LISP Interview Questions Magento Interview Questions MariaDB Interview Questions Material Design Lite Interview Questions Materialize CSS Framework Interview Questions MathML Interview Questions MATLAB Interview Questions Meteor Interview Questions MongoDB interview Questions Moo Tools Interview Questions MySQL Interview Questions NodeJS Interview Questions OpenStack Interview Questions Oracle DBA Interview Questions Pascal Interview Questions Perl interview questions Phalcon Framework Interview Questions PhantomJS Interview Questions PhoneGap Interview Questions Php Interview Questions PL/SQL Interview Questions PostgreSQL Interview Questions PouchDB Interview Questions Prototype Interview Questions Pure CSS Interview Questions Python Interview Questions R programming Language Interview Questions React Native Interview Questions ReactJS Interview Questions RequireJs Interview Questions RESTful Web Services Interview Questions RPA Interview Questions Ruby on Rails Interview Questions SAS Interview Questions SASS Interview Questions Scala Interview Questions Sencha Touch Interview Questions SEO Interview Questions Servlet Interview Questions SQL Interview Questions SQL Server Interview Questions SQLite Interview Questions Struts Interview Questions SVG Interview Questions Swift Interview Questions Symfony PHP Framework Interview Questions T-SQL(Transact-SQL) Interview Questions TurboGears Framework Interview Questions TypeScript Interview Questions UiPath Interview Questions VB Script Interview Questions VBA Interview Questions WCF Interview Questions Web icon Interview Questions Web Service Interview Questions Web2py Framework Interview Questions WebGL Interview Questions Website Development Interview Questions WordPress Interview Questions Xamarin Interview Questions XHTML Interview Questions XML Interview Questions XSL Interview Questions Yii PHP Framework Interview Questions Zend Framework Interview Questions Network Architect Interview Questions

Top 15 SQL Server Interview Question for 2020

1) Describe SQL Server?

SQL server is a DataBase Management System developed by Microsoft. It was first introduced in year 2008 since, then many version has been introduced such as : SQL Server 2008 SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016.

2) Enlist different editions of SQL Server.

Mainstream Edition are
  • Enterprise
  • Standard
  • Web
  • Business Intelligence
  • Workgroup
  • Specialised Edition
  • Azure
  • Compact
  • Embedded
  • Fast track

3) What are the different authentication modes in SQL server.

SQL server consist of two modes
  • Windows Mode
  • Mixed Mode

4) What is the default port of SQL server and how can we change?

Default port is 1433 and we can change it from Network Utility Properties.

5) How many types of Index Configuration a table can have.

No Index
Clustered Index
Non-Clustered Index
Clustered Index with many non-clustered index
Many Non-clustered index

6) Enlist different types of Collation Sensitivity.

  • Case Sensitivity
  • Accent Sensitivity
  • Width Sensitivity

7) Define Standby Server.

Standby server are those server which comes online when our Primary Server goes offline due to some error. Yet application should be running properly need some server called as standby server.

8) Enlist the type of Standby server.

  • Hot standby- In this primary and secondary backup server run simultaneously due to which secondary server is also have real time data updation.
  • Warm standby- In this secondary server runs in background of primary server and update database at time intervals.
  • Cold standby- Backup server is only called when primary server fails.

9) Enlist some SQL server addon services.

Service Broker
Replication Services
Transaction Services
Merge Replication
Snapshot Replication
Analysis Services
Reporting Services
Notification Services

10) What is CHECK Constraint?

CHECK Constraint provide integrity to the SQL server. It limits the value that can be placed in the column of the database.

11) Give some DBCC comaand and its use?

DBCC (DataBase Consistency Checker) as the name suggest it checks whether there is consistency inside database through following commands.
  • DBCC CHECKDB : It ensures table in Database and Indexes are correctly linked.
  • DBCC CHECKALLOC: It checks allocation of different pages.
  • DBCC CHECKFILEGROUP: It checks for the damage in file group.

12) What is SQL Profiler?

It is a tool which allows administrator to monitor different event in SQL. Basically, it is used to capture and save data about each event for analysis.

13) Write a SQL query to return first non-null expression within the argument.

Select COALESCE(empno, empname, salary) from employee;

14) What is an Server Agent.

It consist of full-function scheduling engine which helps in scheduling of our own jobs and scripts.

15) Enlist the different types of replication in SQL Server.

  • Snapshot replication
  • Transnational replication
  • Merge replication