Scenario-Based SQL Interview Questions 1) Scenario: Fetch the third-highest salary without using LIMIT Solution: SELECT Salary FROM Employees e1 WHERE 2 = (SELECT COUNT(DISTINCT Salary) FROM Employees e2 WHERE e
Make sure you have administrator permissions on the computer where SQL Server will be installed. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share. Back up your current installation of SQL Server if you are...
13. Explain different types of BACKUPs available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan? Types of backups you can create in SQL Sever 7.0+ are Full database backup, differential database backup, transaction log backup, filegroup backup. Chec...
Don’t be dumb when you don’t aware of something. See I have seen people kept silent or try to cover with the false answers. If you are asked a scenario based question in replication, but you don’t know answer then you can accept that by saying “I am really not sure how to ha...
Days passed before I was able to work with the Server team member to resolve the problem—that is, we missed creating an SPN for the Report Service server using the Server name. The problem was fixed by adding the SPN made for the service using HTTP and the Servername. We also had to...
at nearly every scale of operation. The advice in this guide will help you navigate the major milestones of the hiring process, including crafting an attractive and relevant job description and conducting an effective technical interview. Ultimately, the right SQL developer can be instrumental to you...
I went back to work asking if we could consider using Enterprise SQL Server, I was told that we have too many cores on our Nutanix hardware to make the features we would use worth it. You see, SQL Server pricing is based on the number of cores the underlying hardware has, not the nu...
Both the client and SQL Server must have connectivity to the HGS environment, and we’ll be using SSMS as the client. SSMS 18.0+ is required because it has the ability to alter the connection string to support Always Encrypted. We’ll be using VMs for this scenario, and we could use SS...
Real Life Scenario: Kindly consider following table.We need to find aggregate results departmentwise in form of rows. Employee table: Employee_numEmployee_nameDepartment IDSalary 1Amit100680000 2Rohan100550000 3Rohit101430000 Query used: select Department_ID,listagg(Employee_name,’,’) within group(...
SQL-based technologies have a lot in common, and all SQL developers need certain skills to succeed. However, there are many aspects specific to a given SQL engine (like PostgreSQL or MySQL), role (administrator or architect), or optimization scenario (data marts, data lakes, or data warehouse...