AI in Interviews – Friend or Foe?
Job interviews have always been nerve-wracking, but now there’s a new player in the room: Artificial Intelligence. Companies are increasingly […]
AI, Interview Questions
Interview Questions
Interview Questions
SQL Joins Tricky Interview Questions
In this article, I have tried to explain the SQL Join concepts with the help of the Interview questions which interview candidate faces regularly.
Interview question – Is Clustered index on column with duplicate values possible?
Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can
Interview question – Is Clustered index on column with duplicate values possible? Read Post »
Question of the Month (July)
Question of the Month Suppose we have a table emp_plan which contains 4 columns “Empid” (employeeid), Planid (Projectid), Startdate(Allocation Start date)
Interview Questions, SQL Basic, SQL Server
Script to find complete months between two given dates
Complete months between two given dates Below script will help in finding the complete months within the 2 given dates.
Script to find complete months between two given dates Read Post »
Interview Questions, SQL Basic, SQL Server, SQL Tips
Script to find the complete weeks within two given dates
Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below
Script to find the complete weeks within two given dates Read Post »
Interview questions for database developer
Technical Round Database Interview Questions 1) What are the different types of Trace flags which we used for detecting the
SQLTea – New SQL tutorial app in Google play store
SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial
SQLTea – New SQL tutorial app in Google play store Read Post »
Question of the Week -08/04/2014
Suppose we need to find out the name of all the months in a given year (Year will be given
Answer – Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)
Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server? Options:- a) 1
Question of the Week – 11/1/2014
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record
Answer – Objective Question (In which database temporary tables are created in SQL Server)
Question :- In which database temporary tables are created in SQL Server? 1) User database (where temporary table are defined)
Answer -Question of the Week – 2/1/2014 – Question 1
Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation
Answer -Question of the Week – 2/1/2014 – Question 1 Read Post »
Answer – Objective Question (Which table is called Heap table in SQL Server)
Question:- Which table is called Heap table in SQL Server. 1) Table without any indexes 2) Table without any
Answer – Objective Question (Which table is called Heap table in SQL Server) Read Post »
Question of the Week – 2/1/2014 – Question 1
Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation