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