sugasil.blogg.se

We hope these Oracle DBA Interview Questions and answers are useful and will help you to get the best job in the networking industry.

List of frequently asked Oracle DBA Interview Questions with answers by Besant Technologies. Oracle DBA Interview Questions and answers for beginners and experts.

This has been a basic guide to the List Of SQL Interview Questions and answers so that the candidate can crackdown on these SQL Interview Questions easily.Oracle DBA Interview Questions and Answers Select * from table_two Recommended Article Write a SQL query to find the records that are present in one table but missing in another table?

Write a SQL query to find the common records between two tables? Select * into new_table from existing_table where 1=2 Ĭreate table new table like an existing table 11. Select * into new table from an existing table Ĭreate an empty table with the same structure as some other table Write a SQL query to create a new table with data and structure copied from another table, create an empty table with the same structure as some other table?Ĭreate a new table with data and structure copied from another table Let us move to the next SQL Interview Questions. Select * from employee where empno in (select empno from employee group by empno, rownum having mod(rownum,2) != 0) Select * from employee where empno in (select empno from employee group by empno, rownum having mod(rownum,2) = 0) Write the Query to find odd and even records from the table? Delete from Employee where name in (Select name from employee group by age, salary having count(*) > 1)) ĭelete from employee where rowid not in (select max (rowid) from employee group by name) ĩ. This is the advanced SQL Interview Questions asked in an interview. Write the query to remove the duplicates from a table without using a temporary table? You need to execute the below query for finding nth highest salary.Ģnd: Select Salary from employee where salary in (select salary from employee where level = &lownth connect by prior Salary 1 8. Note: This solution is only to find the 2nd lowest salary, if the question gets changed, find the 3rd or 4th lowest salary then this will not work. There are multiple ways to solve this question, below two are the easiest solution for it.ġst: Select min (salary) from employee where salary not in (select min(salary) from employee). write the query to find the 2nd lowest salary in the employee table? Note: If you run the above query it will ask for entering the value of topnth, if you enter 2 it will show the result for 2 and if you enter 3 it will give the result for 3 likewise this query is generic.ģrd: Select salary from employee where salary in (select salary from (select unique salary from employee order by salary desc) group by rownum, salary having rownum = &topnth).Įxecute as same as 2nd query execute. You need to execute the below query for finding nth highest salary.Ģnd: Select Salary from employee where salary in (select salary from employee where level = &topnth connect by prior Salary > Salary group by level). Note: This solution is only to find the 2nd highest salary, if the question gets changed, find the 3rd or 4th highest salary then this will not work. There are multiple ways to solve this question, below three are the easiest solution for it.ġst: Select max (salary) from employee where salary not in (select max(salary) from employee). These is the basic SQL interview questions asked in a SQL interview. write the query to find the 2nd highest salary in the employee table? Select * from employee where salary =(select max(salary) from employee) 3. Select * from table_name where salary = (select max(salary) from table_name) Write the query to find the employee record with the highest salary. This is a standard language used to perform several tasks such as retrieval, updating, insertion, and deletion of data from a database. SQL stands for a structured query language, and it is used to communicate with the database. This first part covers basic interview questions and answers 1. Hadoop, Data Science, Statistics & others Part 1 – SQL Interview Questions (Basic)