SQL Interview Questions
- 0of 0 votes
AnswersExplain UNION, MINUS, UNION ALL, INTERSECT ?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display minimum salary of an employee?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to count the number of employees working in the company?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display minimum & maximum salary of employee?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display the total salary of employee based on dept_name?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display the total salary of all employees based on city whose average salary >= 23000?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersHow to fetch common records from two tables?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersHow can you create an empty table from an existing table?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat are aggregate and scalar functions?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is the difference between TRUNCATE and DROP statements?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is an ALIAS command?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is Union, minus and Interact commands?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is CLAUSE?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is Online Transaction Processing (OLTP)?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat are all types of user defined functions?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is user defined functions?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is Cross-Join?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is Self-Join?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is Datawarehouse?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is the difference between Cluster and Non-Cluster Index?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is Auto Increment?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is data Integrity?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is a constraint?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat are local and global variables and their differences?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is the difference between DELETE and TRUNCATE commands?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat are the types of subquery?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is subquery?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is a query?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is a relationship and what are they?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is a Cursor?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL