What are the basic interview questions in SQL DBA?

Common SQL Server DBA interview questions and answers

• What types of replication are supported in SQL server?
• How do you troubleshoot a performance issue on your SQL server?
• What is blocking and what’s the best way to deal with it?
• What is DBCC?
• What kind of recovery models are there in SQL server?

What are the role of DBA which skills are required for DBA?

Database administrators (DBAs) design, write and take care of computer database systems so that the right person can get the information they need at the right time. working with database software to find ways to store, organise and manage data. troubleshooting. keeping databases up to date.

What are responsibilities of DBA?

The Key Responsibilities of a Database Administrator

• Software installation and Maintenance.
• Data Extraction, Transformation, and Loading.
• Specialised Data Handling.
• Database Backup and Recovery.
• Security.
• Authentication.
• Capacity Planning.
• Performance Monitoring.

What are the types of DBA?

Types of Database Administrator (DBA) :

• Administrative DBA – Their job is to maintain server and keep it functional.
• Data Warehouse DBA – Assigned earlier roles, but held accountable for merging data from various sources into data warehouse.
• Development DBA –
• Application DBA –
• Architect –
• OLAP DBA –

What is the difference between MS SQL DBA and Oracle SQL DBA?

The Oracle DBAs present were hard-core DBAs while the SQL Server DBAs were mostly developer DBAs or originally Windows system administrators. The Oracle RDBMS DBAs tends to use a more siloed approach. The production DBA would not also be expected to be a development DBA.

Is SQL Server required?

SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article.

What is SQL Server English query?

SQL Server English Query helps to build applications that can accept query in questions form (in English). The application passes the questions string to the English query engine. English Query then returns to the application a SQL statement or a Multi-Dimensional Expression ( MDX )…

How do I find the SQL Server version?

Method 1 – to find SQL Server version. The first is by using either Enterprise Manager or SQL Server Management Studio and right clicking on the instance name and selecting Properties. In the general section you will see information such as on the following screenshots.

What is a SQL Server query?

Structured Query Language (SQL) is a specialized language for updating, deleting, and requesting information from databases. SQL is an ANSI and ISO standard, and is the de facto standard database query language. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server.