SQL Server DBA Interview Questions and Answers

SQL Server DBA Interview Questions and Answers

Microsoft SQL Server DBA Interview Questions and Answers for freshers & experienced.

Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It’s one of the three market-leading database technologies, along with Oracle Database and IBM’s DB2.

The SQL Server Database system from Microsoft Corporation has gained popularity over the last years, and it is believed to be one of the few surviving relational database systems in this marketplace (the others being Oracle and DB2 from IBM).

The original SQL Server code was developed in the 1980s by the former Sybase Inc., which is now owned by SAP. Sybase initially built the software to run on UNIX systems and minicomputer platforms. It, Microsoft and Ashton-Tate Corp., then the leading vendor of PC databases, teamed up to produce the first version of what became Microsoft SQL Server, designed for the OS/2 operating system and released in 1989.

DBA is also an abbreviation for doing business as – a term sometimes used in business and legal writing. DBA is an abbreviation for A-weighted decibels.

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. A DBA is expected to stay abreast of emerging technologies and new design approaches. Typically, a DBA has either a degree in Computer Science or some on-the-job training with a particular database product or more extensive experience with a range of database products.

Microsoft SQL Server begins with the first Microsoft SQL Server product – SQL Server 1.0, a 16-bit server for the OS/2 operating system in 1989 – and extends to the current day 2017.

What is the work of SQL Server DBA?

What are SQL Server DBA Responsibilities?

Explain the different types of Indexes available in SQL Server?

What is the difference between Clustered and Non-Clustered Indexes in SQL Server?

Why sql server is better than other databases?

What is SQL DUMP? Have you ever dealt with this?

Explain how database snapshots works?

What are the primary differences between an index reorganization and an index rebuild?

How many different types of pages exist in SQL Server?

Do you know about Resource Database?

What is a trace flag?

What is RAID?

What is the difference between memory and disk storage?

What is the Hotfixes and Patches?

What are the different Authentication modes in SQL Server and how can you change authentication mode?

What the different types of Replication and why are they used?

What is a system database?

What is a user database?

What are the different SQL Server Versions you have worked on?

How do you troubleshoot errors in a SQL Server Agent Job?

What are the different ways you can create Databases in SQL Server?

What is Transparent Data Encryption?

What are the operating modes in which Database Mirroring runs?

Can we hot add CPU to sql server?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

SQL Server is not responding. What is action plan?

Why Shrink file/ Shrink DB/ Auto Shrink is really bad?

What are the different log files and how to access it?

How to know the number of VLF created on a given database log file?

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

What is DML, DDL, DCL and TCL in SQL Server?

What is fill factor?

Where do you find the default Index fill factor and how to change it?

What are the High-Availability solutions in SQL Server?

Explain about your SQL Server DBA Experience?

What is RDMS?

What is the port numbers used for SQL Server services?

What is your experience with third party applications and why would you use them?