What do you mean by Extent in an SQL Server Database?
Extents in an SQL server database are the basic unit of measuring space for indexes and tables in the database.
What are the contents of the page header in an SQL server database?
The contents of the page header are - Index of Data and Free Space.
What are the different types of System databases?
The different types of System Databases include:
- Resource
- TempDB
- Distribution
- Model
- Master
- MSDB
What is the Syntax used to create an SQL database?
The syntax used to create an SQL database is - Create database <databasename>
How do you create databases with specific file locations in SQL?
This is one of the most common SQL Server DBA interview questions asked in technical interviews. To create a database with a specific file location, the following command is used:
Restore Database <database name> from disk='<Backup file location + file name>’
What are some third-party tools used to create and support SQL Server databases?
Some third-party tools that are commonly used to create and support SQL server databases include:
- SQL Doc2 - Used to document SQL databases
- SQL Check - USed to monitor memory and server activities
- SQL Backup5 - This is used to backup SQL databases
- Litespeed 5.0 - Used mainly to restore and backup databases
- SQL Prompt - used to provide IntelliSense for SQL databases
What is SSMS?
The SSMS, or SQL Server Management Studio, is a popular software application used for designing, creating, configuring, and managing components inside the Microsoft SQL database. It is one of the widely used applications for Microsoft SQL databases.
What are the Methods used to backup SQL databases?
The methods used to backup SQL databases include SSMS and T-SQL
What are some benefits of employing SQL third-party tools to maintain and support SQL Server databases?
This is a common SQL Server DBA interview question asked at technical interviews. Some benefits of using third-party tools include:
- Backups are secured through encryption
- Security of databases is maintained
- Memory is allocated uniformly and consistently
- Faster recovery options
- Individual database objects can be easily recovered
- Backup histories and schedules can be viewed seamlessly
What is the typical role of an SQL Database Administrator?
SQL Database Administrators are typically involved with designing and managing the SQL server, allocating memory, organizing data, enabling user interaction with the server, and ensuring that data contained in the server is secure.
