Infosys Database Interview Questions

  • What is the SQL statement to query two tables at once?
  • Write a sql query to select duplicates in a Table.
  • What is triggering in sql
  • How to get results of any query which is sorted in any order?
  • Stored Proc vs Normal Query. Which is faster and why?
  • What are different DCL commands used?
  • How will you select all name,salary of all employees having 4th highest salary from Employee table.
  • How to get distinct entries from the database?
  • What would you do if your Stored Procedure starts performing badly overnight?
  • Which command is used to delete a record from a database?
  • What is outer join?
  • How can you compare a part of name rather than the entire name?

Shared by: Subrat Kumar