SQL Server Interview Questions and Answers

SQL Server Interview Questions and Answers

SQL Server Interview Questions and answers

SQL Server Interview Questions and answers for beginners and experts. List of frequently asked SQL Server Interview Questions with answers by Besant Technologies. We hope these SQL Server Interview Questions and answers are useful and will help you to get the best job in the networking industry. This SQL Server Interview Questions and answers are prepared by SQL Server Professionals based on MNC Companies expectation. Stay tuned we will update New SQL Server Interview questions with Answers Frequently.

Best SQL Server Interview Questions and answers

Besant Technologies supports the students by providing SQL Server Interview Questions and answers for the job placements and job purposes. SQL Server is the leading important course in the present situation because more job openings and the high salary pay for this SQL Server and more related jobs. We provide the SQL Server online training also for all students around the world through the Gangboard medium. These are top SQL Server Interview Questions and answers, prepared by our institute experienced trainers. If you want to learn Practical SQL Server Training then please Join our SQL Server Training in Chennai .

SQL Server Interview Questions and answers for the job placements

Here is the list of most frequently asked SQL Server 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 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 are the different types of backup

Q2) What is the difference between a Full and Full – Copy the only backup

Q3) Which are the available recovery models?

Q4) What does ACID stand for?

Q5) Which are the different isolation levels

Q6) What happens when you Update STATISTICS ?

Q7) Which trace flags should be turned On to write more information about the deadlock to the log

Q8) How to run on Trace flag, provide an example

Q9) Which events should you choose in profiler to capture Deadlock ?

Q10) What is termed as a deadlock victim

Q11) Which are the system databases?

Q12) Where is the backup history and SQL agent job history saved?

Q13) What is the use of Resource database?

Q14) What is the purpose of Model database?

Q15) Provide some examples of catalog views

Q16) List at least three server level roles

Q17) List at least three fixed database roles

Q18) Which statement can be used to grant permission to a user or role

Q19) Which statement is used to remove a previously granted permission

Q20) Which are some of the new features of SQL Server 2016

Q21) Does Log shipping provide for Automatic failover?

Q22) Give one difference between Log shipping and replication

Q23) Which are the different modes of configuring Mirroring

Q24) Is it compulsory to have Witness instance in database Mirroring

Q25) Does the database need to be in Full recovery mode for Mirroring to be configured?

Q26) Which are the different types of SQL server Cluster setup

Q27) List SQL Server services that are cluster aware

Q28) What is a table without a clustered index called?

Q29) How many clustred indexes can we have on a table

Q30) Which dynamic management function can we use to get the fragmentation level of an index

Q31) When do we generally Rebuild and Re-organise index ?

Q32) List some of commonly used DBCC statements

Q33) Whats I ste default port number for SQL Server instance, if it has not been chnaged during installation

Q34) What are Ghost Records

Q35) When a database is created , what is the minimum number of files that it will have?

Q37) What is the difference between a Login and a User in SQL Server

Q38) What is an Orphan user

Q39) What is the minimum level of permission required for a login to be able to change the password of another login?

Q40) List the SQL server startup parameters

Q41) List at least three major wait events:

Q42) How can you send email notification on completion of SQL server agent jobs

Q43) How to check if SQL Instance is configured to use Database Mail XPs ?

Q44) List the available editions for SQL Server 2016/17

Q45) Transparent data encryption (TDE) is a new feature in SQL Server that is available with which all editions?

Q46) What is the limitation of Developer Edition?

Q47) List some of the new features of SQL Server 2017

Q48) Starting with which version, can we install SQL Server on Linux

Q49) Which are the jobs that are created while setting up log shipping

Q50) What is the difference between MySQL Server and MS SQL Server?

Q51) What is the model database server intended for?

Q52) How do you find a SQL Server looking for traffic hitting?

Q53) What types of replication are supported in SQL Server?

Q54) Utility of SQL Agent.

Q55) Utility of checkpoints.

Q56) Explain about DBCC.

Q57) How do you control the amount of free space on your index pages?

Q58) Why would you call Update Statistics?

Q59) What is a correlated sub-query in SQL?

Q60) Authentication modes supported by SQL Server.

Q62) How many SQL Server published Versions you worked on till date?

Q63) How many Indexes available in SQL Server?

Q64) Dissimilarities between Clustered and Non-Clustered Index.

Q65) What are the extra added features in SQL Server 2005 than SQL Server 2000?

Q66) What are the high-availability solutions of SQL Server and what distinguishes them briefly.

Q67) How do you troubleshoot a SQL Server Agent Job?

Q68) What is the default Port no for SQL Server listening?

Q69) What number files will an information contains in the SQL Server? How many types of data forms exist on SQL Server? How many of these files can exist for a single database?

Q70) Fullform of DCL.

Q71) Commands used in DCL.

Q72) Describe about Fill Factor.

Q73) Value of default fill factor.

Q74) Where do you find the default index fill element and how to change it?

Q75) What is a system database and what is a user database?

Q76) Available recovery models for a database?

Q77) Importance of a recovery model in SQL server.

Q78) Describe about Replication and its advantages.

Q79) Types of Replication and their uses.

Q80) Types of Replication components and their use.

Q81) What are the different topologies where replication can be configured?

Q82) If you were given access to an SQL server, how would you discover if the SQL instance is a named instance or a default instance?

Q83) What are the various authentication methods on SQL Server and how can you change authentication mode?

Q84) What are the differences between the clustering of SQL Server 2005 and 2008 or 2008 R2?

Q85) Describe Active-Passive and Active-Active clustering setup.

Q86) List the number of SQL Server failover cluster you want to set up.

Q88) At the time of transmission data across network does Transparent Data Encryption provide encryption?

Q89) What is the difference between the High-Safety and Superior operating modes of Database Mirroring

Q90) what’s the distinction between dropping info and taking an info offline?

Q91) Which auto growth database setting is better?

Q92) SQL server 2008 introduced different types of data compression what are they?

Q93) How many types of Upgradation can be performed in SQL Server?

Q94) On a Windows Server 2003 Active – Passive failover cluster, how do you find the node which is active?

Q95) Procedure of opening a Cluster Administrator.

Q96) The SQL Server on a failover cluster needs to be brought down. What is the procedure?

Q97) What are the various ways in which you can create databases on SQL Server?

Q98) What are operating modes maintained by Database Mirroring?

Q99) Once the transcript is set, is it possible to own a publisher as a distributor or subscriber, as a twenty-four bit SQL server and thirty-bit bit SQL server?

For Any Queries Please Contact : Chennai : 8099 770 770 | Bangalore : 8767 260 270 | Online Training : 9707 250 260
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

Call Now Button