SQL Server DBA Interview Questions and answers
SQL Server DBA Interview Questions and answers for beginners and experts. List of frequently asked SQL Server DBA Interview Questions with answers by Besant Technologies. We hope these SQL Server DBA Interview Questions and answers are useful and will help you to get the best job in the networking industry. This SQL Server DBA Interview Questions and answers are prepared by SQL Server DBA Professionals based on MNC Companies expectation. Stay tuned we will update New SQL Server DBA Interview questions with Answers Frequently. If you want to learn Practical SQL Server DBA Training then please go through this SQL Server DBA Training in Chennai.
Best SQL Server DBA Interview Questions and answers
Besant Technologies supports the students by providing SQL Server DBA Interview Questions and answers for the job placements and job purposes. SQL Server DBA is the leading important course in the present situation because more job openings and the high salary pay for this SQL Server DBA and more related jobs. We provide the SQL Server DBA online training also for all students around the world through the Gangboard medium. These are top SQL Server DBA Interview Questions and answers, prepared by our institute experienced trainers.
SQL Server DBA Interview Questions and answers for the job placements
Here is the list of most frequently asked SQL Server DBA Interview Questions and answers in technical interviews. These questions and answers are suitable for both freshers and experienced professionals at any level. The questions are for intermediate to somewhat advanced SQL Server DBA professionals, but even if you are just a beginner or fresher you should be able to understand the answers and explanations here we give.
Ans : Page
Ans : 8 Kb
Ans : 96 bytes.
Ans: Index of data, free space
Ans : 9
Ans : Extents are basic unit where space is allocated to tables and indexes
Ans: 8 contiguous pages or 64KB
Ans : 4+2
Ans : Create database <databasename>
Ans : Restore Database <database name> from disk='<Backup file location + file name>’
Ans : Backup, Restore, Replication, Mirroring, Log shipping, Clustering, etc,..
Ans : Drop database <database name>
Ans : Backup is copy of data/database.
Transactional Log /Log
Ans : T-SQL & SSMS
Ans : SQL Server Management Studio.
Ans : Reporting services, Analysis Services, Management Studio, Integration services, Full text search, browser, etc..
Ans : Create user <username> for login <loginname>
Ans : Use <database name>
Grant <permissionname> on <objectname> to <username>
Ans : Monitoring refers to check database status, settings which may be the owner’s name, file names, file sizes, schedules, etc.
Ans : SQL Server and SQL Server Agent
Ans : Services.msc and SQL Server Configuration Manager
Ans : Services.msc, SQL Server Configuration Manager and SSMS
Ans : Due to services already stopped state, we cannot access services via SSMS.
Ans : Agent Service is a dependent service, so it will stop first agent and then SQL services.
Ans : The source data will be copied to destination through replication agents (jobs). Object level technology
Ans : Publisher server
Ans : The source data will be copied to destination via Transaction Log backup jobs. Database level tech.
Ans : Primary server.
Monitor server (Optional)
Ans : The primary data will be copied to secondary via network. Database level tech.
Ans : Principal server.
Ans : The data will be stored in shared location which is used by both primary and secondary servers based on availability of the server. Instance level tech.
Ans : Active node.
Ans : The primary data will be copied to secondary via network. Group of database level tech.
Ans : Primary is source server.
Secondary is destination server
Ans: To create and publish various kinds of reports.
Ans : The BIDS and SSDT
Ans : Helps to statistics and processor tree. It is the result of query optimizer.
Ans : there are two types of query estimation plans are there.
Ans : there are three formats of execution plans are there.
Ans : SHOWPLAN
Ans : “Select top 60 * from table”
Ans : Insert into table(Column1, column2,etc)
Ans : Delete from table where datediff(day,timestamp,getdate())=0
Ans : Truncate table Tablename
Ans : SQL Server Integration services
Ans : It is used to carry out (Extraction, Transform, Load data)ETL
Ans : To analyse huge amounts of data and apply to business decisions.