1. Explain about your SQL Server DBA Experience?Answer: This is a generic question often asked by many interviewers. Explain what are the different SQL Server Versions you have worked on, what kind of administration of those instances has been done by you. Your role and responsibilities carried out in your earlier projects that would be of significance …
1. What is a deadlock and what is a live lock?Answer: A livelock is one, where a request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. SQL Server detects the situation after four denials and refuses further shared locks. A livelock also occurs when read transactions monopolize …
Sql Server Developer Interview Questions And Answers Pdf Read More »
Are you looking for SQL Server Dba Interview Questions for Fresher’s or experienced? You are at accurate place. There are loads of chances from various reputed corporations in the business. According to analysis, SQL Server Dba has a business share of around 1.6%. So, you, however, have a chance to move forward in your career in SQL Server …
Sql Server Dba Interview Questions And Answers Pdf Read More »
1. What is BCP? When is it used?Answer: It is a tool used to duplicate an enormous quantity of information from tables and views. It does not facsimile the structures the same as a foundation to target.BULK INSERT command helps to bring in a data folder into a record, table or view in a user-specific …
1. Explain the difference between a hot backup and a cold backup and the benefits associated with each?Answer: A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it …
1. What is PL/SQL?Answer: Oracle PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. 2. How can you Rollback a particular part of a procedure or any PL/SQL Program?Answer: It can be done using Savepoints during the definition of a PL/SQL program. 3. What …
1. What are the properties of the transaction?Answer: Properties of the transaction are known as ACID properties, such asAtomicity: Ensures the completeness of all transactions performed. Checks whether every transaction is completed successfully if not then transaction is aborted at the failure point and the previous transaction is rolled back to its initial state as …
1. What is Failover clustering overview?Answer: Failover clustering is mainly used for data availability. Typically, in a failover cluster, there are two machines.One machine provides the basic services and the second is available to run the service when the primary system fails.The primary system is monitored periodically to check if it works. This monitoring may …
Advanced SQL Interview Questions And Answers Pdf Read More »
