Oracle Interview Questions and Answers

0 votes

Q: You want to create a list of managers and the number of employees reporting to them

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Consider a scenario where the company plans to give a salary raise to employees

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Imagine you want to identify employees who are eligible for promotions based on their years

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Say you’re preparing a report for the management to identify employees who have shown consistently high performance.

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Imagine you’re an HR manager and want to get an overview of the average performance rating for each department

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Case Study: Sales Analysis System. The dataset contains information about sales transactions in a company.

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Imagine you have an Inventory table with product_id and quantity columns

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: In a database containing information about books and authors

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Imagine that you have a students table with the columns student_id, student_name

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: You have an Employees table with columns for employee names and their respective managers

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Write an Oracle SQL query to ensure only users with the manager role can insert rows into the performance_reviews table.

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Write an Oracle SQL query to find the five most common names in the Employee table.

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Write an Oracle SQL query to find the names of employees not assigned to any project.

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Calculate the percentage of total sales each product contributes to the overall revenue.

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Calculate the total revenue generated by each customer in the last three months.

asked Jan 23 in Oracle by SakshiSharma

0 votes

Q: Retrieve the top five highest-rated products based on customer

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: Write an Oracle SQL query to get the date and time of the last 10 logins for a specific user.

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: How would you update the status column of the orders table to set all orders

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: Write an Oracle SQL query to find employees who earn more than their managers.

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: Write an Oracle SQL query to find the average salary of employees within each department.

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: How would you explain database roles and privileges in Oracle SQL security?

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: What are some advantages of using bind variables in Oracle SQL?

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: What do the COMMIT and ROLLBACK statements in Oracle SQL do?

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: What is the key difference between ROW-level and STATEMENT-level triggers in Oracle?

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: How does the Oracle Query Optimizer determine an execution plan for a query?

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: Differentiate between the WHERE clause and the HAVING clause in Oracle SQL.

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: Name one advantage of using indexes in a database.

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: What is the purpose of the UNION operator in Oracle SQL?

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: Explain the difference between RANK and DENSE_RANK functions in Oracle SQL.

asked Jan 21 in Oracle by rajeshsharma

0 votes

Q: Show how functions and procedures are called in a PL SQL block

asked Jan 19 in Oracle by rajeshsharma

Page:

1
2
3
4
5
6
...
9
next »

...