SQL Server DBA Interview Questions and Answers

SQL Server DBA Interview Questions and Answers

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.

Q1) What is fundamental unit of SQL DB?

Q2) What is size of page?

Q3) What is the size of page header?

Q4) What are contains in page header?

Q5) How many types of pages are available?

Q6) What is Extent?

Q7) What is the size of extent?

Q8) How many system databases are there?

Q9) List the system Databases?

Q10)What is the basic syntax for create database?

Q11) How to create database with specific file location?

Q12) List few methods of HA technologies in SQL?

Q13) What is the syntax for drop database?

Q14) What is database backup?

Q15) How many types of backup is there?

Q16) List the backup types?

Q17)What are the methods for backup?

Q18) What is SSMS?

Q19) What are the services are available along with SQL server?

Q20) How to create new user in SQL server?

Q21) How to provide access to particular access?

Q22) What is SQL server monitoring?

Q23) What are main services for SQL server?

Q24) What are the methods to start services?

Q25) What are the methods to stop services?

Q26) Why we cannot start services via SSMS?

Q27) Whether can we stop SQL services without SQL Agent stop?

Q28) What is Replication?

Q29) What are the terminology used for Replication?

Q30) What is log shipping?

Q31) What are the terminology used in log shipping?

Q32) What is mirroring?

Q33) What are the terminology used for mirroring?

Q34) What is clustering?

Q35) What are the terminology used for clustering?

Q36) What is Always ON Availability Groups?

Q37) What are the terminology used for Always ON Availability Groups?

Q38) What is the usage of reporting services?

Q39) What are the environments used for reports?

Q40) What is execution plan?

Q41) What are types of query estimation plans there?

Q42) How many types of execution plans formats are available?

Q43) hat is the command to see the execution plan by user?

Q44) what is the syntax to get top 60 records in a table?

Q45) What is syntax to insert data into a table?

Q46) How to delete current day records in a table which has timestamp column?

Q47) How to clear all records including data types in a table?

Q48) What is SSIS?

Q49) What is the usage of SSIS?

Q50) What is the usage of Analysis service?

Besant Technologies – Chennai & Bangalore Branch Locations

Besant Technologies - Velachery Branch
Plot No. 119, No.8, 11th Main road, Vijaya nagar,
Velachery, Chennai - 600 042
Tamil Nadu, India
Landmark - Reliance Digital Opposite Street
+91-996 252 8294 / 996 252 8293

Besant Technologies - Tambaram Branch
No.2A, 1st Floor, Duraisami Reddy Street,
West Tambaram, Chennai - 600 045
Tamil Nadu, India
Landmark - Near By Passport Seva
+91-970 725 0260

Besant Technologies - OMR Branch
No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,
OMR, Okkiyam Thoraipakkam, Chennai - 600 097
Tamil Nadu, India
Landmark - Behind Okkiyampet Bus Stop,
+91-887 038 4333

Besant Technologies - Porur Branch
No. 180/84, 1st Floor, Karnataka Bank Building
Trunk Road, Porur,
Chennai - 600 116
Tamilnadu, India
Land Mark: Opposite to Gopalakrishna Theatre
+91-755 022 6990

Besant Technologies - Anna Nagar Branch
Plot No:1371, 28th street kambar colony,
I Block, Anna Nagar ,
Chennai - 600 040
Tamil Nadu, India
Landmark - Behind Reliance Fresh
+91-938 404 0493

Besant Technologies - T.Nagar Branch
Old No:146/2- New No: 48,
Habibullah Road,T.Nagar,
Chennai - 600 017
Tamil Nadu, India
Landmark - Opposite to SGS Sabha
+91-984 025 8377

Besant Technologies - Thiruvanmiyur Branch
22/67, 1st Floor,
North mada street, Kamaraj Nagar
Thiruvanmiyur, Chennai 600041
Tamil Nadu, India
Landmark - Above Thiruvanmiyur ICICI Bank
+91-938 404 0493

Besant Technologies - Siruseri Branch
No. 4/76, Ambedkar Street,
OMR Road, Egatoor, Navallur,
Siruseri, Chennai 600130
Tamil Nadu, India
Landmark - Near Navallur Toll Gate, Next to Yamaha Showroom
+91-7338 810 550

Besant Technologies - Maraimalai Nagar Branch
No.37, Ground Floor,
Thiruvalluvar Salai,
Maraimalai Nagar,Chennai 603209
Tamil Nadu, India
Landmark - Near to Maraimalai Nagar Arch
+91-979 123 7373

Besant Technologies - BTM Layout Branch
No 2, Ground floor,
29th Main Road, Kuvempu Nagar,BTM Layout 2nd Coming from Silkboard, take left at AXA company signal,
Stage, Bangalore - 560 076
Karnataka, India
Landmark - Next to OI Play School
+91-762 494 1772 / 74

Besant Technologies - Marathahalli Branch
No. 43/2, 2nd Floor, VMR Arcade,
Varthur Main Road, Silver Springs Layout,
Munnekollal, Marathahalli, Bengaluru - 560037
Karnataka, India
Landmark - Near Kundalahalli Gate Signal
+91-910 812 6341

Besant Technologies - Rajaji Nagar Branch
No. 309/43, JRS Ecstasy, First Floor,
59th Cross, 3rd Block, Bashyam Circle,
Rajaji Nagar, Bangalore - 560 010
Karnataka, India
Landmark - Near Bashyam Circle
+91- 734 916 0004

Besant Technologies - Jaya Nagar Branch
No. 2nd Floor,1575,11th Main Road,
4th T-Block, Pattabhirama Nagar, Jaya Nagar,
karnataka, India
Land Mark: Opposite to Shanthi Nursing Home
+91-733 783 7626

Besant Technologies - Kalyan Nagar Branch
No.513, 4th Cross Rd
2nd Block, HRBR Layout, Kalyan Nagar,
karnataka, India
Land Mark: Opposite to kalayan nagar Axis Bank
+91-938 404 0495

Besant Technologies - Electronic City Branch
No. 7, 3rd Floor, Ganga Enclave,
Neeladri Road, Karuna Nagar, Doddathoguru Village,
Electronics City Phase 1, Electronic City,
Bangalore - 560100, karnataka, India
Land Mark: Adjacent to HDFC Bank and State Bank Of India
+91-782 392 2180

Besant Technologies - Indira Nagar Branch
No.54, 1st Floor,
5th Main kodihalli,
Bengaluru, Karnataka 560008, India
Landmark: Behind Leela Palace Hotel,
+91-910 812 6339

Besant Technologies - HSR Layout Branch
Plot No. 2799 & 2800, 27th Main,
1st Sector, HSR Layout,
Bengaluru, Karnataka 560102, India
+91-733 783 7626

Besant Technologies - Hebbal Branch
No.29, 2nd Floor, SN Complex,
14th Main Road, E-Block Extention, Sahakara Nagar,
Bengaluru, Karnataka -560092, India
+91-938 404 0496