SQL interview questions

Rakesh Patil

SQL Server installation and upgrade troubleshooting interview questions

September 21, 2018 by

1. Can a Service Pack or Cumulative Update be uninstalled to roll back in case of failures?

We cannot uninstall a service pack or Cumulative Update on SQL Server 2005 or lower.

Starting with SQL Server 2008, we can uninstall a service pack or Cumulative Update from control panel Add or remove programs a view installed updates window.

Read more »
Prashanth Jayaram

SQL interview questions on database backups, restores and recovery – Part I

July 30, 2018 by

So far, we’ve discussed a lot about database backup-and-restore process. The backup database command is an online database copy of the SQL Server database and restore database command gives an option to test the consistency and integrity of the backup file.

As we all know, the backup database command bound with many database options. Indeed, it facilitates the execution of specific backup database command that meets the business requirement.

Read more »
Dejan Sarka

Interview questions and answers about data science, data understanding and preparation

July 27, 2018 by

Q1: In the data science terminology, how do you call the data that you analyze?

In data science, you analyze datasets. Datasets consists of cases, which are the entities you analyze. Cases are described by their variables, which represent the attributes of the entities. The first important question you need to answer when you start a data science project is what exactly is your case. Is this a person, a family, an order? Then you collect all of the knowledge about each case you can get and store this information in the variables.

Read more »