Database | Eklavya Online

Database

PLSQL Intermediate Interview Questions

Prepare Sample Data To Practice SQL Skill. Sample Table – Worker WORKER_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT 001 Monika Arora 100000 2014-02-20 09:00:00 HR 002 Niharika Verma 80000 2014-06-11 09:00:00 Admin 003 Vishal Singhal 300000 2014-02-20 09:00:00 HR 004 Amitabh Singh 500000 2014-02-20 09:00:00 Admin 005 Vivek Bhati 500000 2014-06-11 09:00:00 Admin 006 Vipul Diwan 200000 …

PLSQL Intermediate Interview Questions Read More »

SQL Advance Interview Questions

1: Explain the meaning of ‘index’. Indexes help retrieve information from the database faster and with higher efficiency. In other words, it’s a method that enhances performance and there are 3 types of indexes: Clustered – reorders the table and searches for information with the use of key values Non-clustered – maintains the order of the table Unique – …

SQL Advance Interview Questions Read More »

SQL Intermediate Interview Questions

1: Explain the meaning of ‘index’. Indexes help retrieve information from the database faster and with higher efficiency. In other words, it’s a method that enhances performance and there are 3 types of indexes: Clustered – reorders the table and searches for information with the use of key values Non-clustered – maintains the order of the table Unique – …

SQL Intermediate Interview Questions Read More »

SQL Basic Interview Questions

RDBMS is one of the most commonly used databases to date, and therefore SQL Skills are indispensable in most of the job roles. In this SQL Interview Questions article, I will introduce you to the most frequently asked questions on SQL (Structured Query Language). This article is the perfect guide for you to learn all …

SQL Basic Interview Questions Read More »

PLSQL Basic Interview Questions

Q1) What is the difference between PL SQL and SQL? Ans.  PL SQL vs SQL Comparison SQL PL/SQL Execution Single command at a time Block of code Application Source of data to be displayed Application created by data acquired by SQL Structures include DDL and DML based queries and commands Includes procedures, functions, etc Recommended …

PLSQL Basic Interview Questions Read More »

PLSQL Advanced Interview Questions

1.What is query to Find Second Highest Salary Of Employee? | Find 2nd Highest salary examples Select distinct Salary from Employee e1 where 2=Select count(distinct Salary) from Employee e2 where e1.salary<=e2.salary; Alternative: select min(salary)from(select distinct salary from emp order by salary desc)where rownum<=2; 2.Query to find Duplicate Records in Table? Select * from Employee a …

PLSQL Advanced Interview Questions Read More »