Login
Remember
Register
Ask a Question
Recent questions in Oracle
0
votes
1
answer
You want to create a list of managers and the number of employees reporting to them
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
sql-query
0
votes
1
answer
Consider a scenario where the company plans to give a salary raise to employees
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-
0
votes
1
answer
Imagine you want to identify employees who are eligible for promotions based on their years
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-query
0
votes
1
answer
Say you’re preparing a report for the management to identify employees who have shown consistently high performance.
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
sql-query
0
votes
1
answer
Imagine you’re an HR manager and want to get an overview of the average performance rating for each department
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
sql-query
0
votes
1
answer
Case Study: Sales Analysis System. The dataset contains information about sales transactions in a company.
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-query
0
votes
1
answer
Imagine you have an Inventory table with product_id and quantity columns
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-query
0
votes
1
answer
In a database containing information about books and authors
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
databaseinfog
0
votes
1
answer
Imagine that you have a students table with the columns student_id, student_name
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
sql-query
0
votes
1
answer
You have an Employees table with columns for employee names and their respective managers
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-query
0
votes
1
answer
Write an Oracle SQL query to ensure only users with the manager role can insert rows into the performance_reviews table.
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oraclesqlquery
0
votes
1
answer
Write an Oracle SQL query to find the five most common names in the Employee table.
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-query
0
votes
1
answer
Write an Oracle SQL query to find the names of employees not assigned to any project.
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-sql
0
votes
1
answer
Calculate the percentage of total sales each product contributes to the overall revenue.
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
query-sql
0
votes
1
answer
Calculate the total revenue generated by each customer in the last three months.
asked
Jan 23, 2024
in
Oracle
by
SakshiSharma
oracle-query
0
votes
1
answer
Retrieve the top five highest-rated products based on customer
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
sql-query
0
votes
1
answer
Write an Oracle SQL query to get the date and time of the last 10 logins for a specific user.
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
1
answer
How would you update the status column of the orders table to set all orders
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
oracle-query
0
votes
1
answer
Write an Oracle SQL query to find employees who earn more than their managers.
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
1
answer
Write an Oracle SQL query to find the average salary of employees within each department.
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
1
answer
How would you explain database roles and privileges in Oracle SQL security?
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
privileges-roles
oraclesqlsecurity
0
votes
1
answer
What are some advantages of using bind variables in Oracle SQL?
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
oraclesql
0
votes
1
answer
What do the COMMIT and ROLLBACK statements in Oracle SQL do?
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
rollback-statement
commit0statement
0
votes
1
answer
What is the key difference between ROW-level and STATEMENT-level triggers in Oracle?
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
statement-level-triggers
0
votes
1
answer
How does the Oracle Query Optimizer determine an execution plan for a query?
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
oracle-query-optimizer
0
votes
1
answer
Differentiate between the WHERE clause and the HAVING clause in Oracle SQL.
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
havingclause
0
votes
1
answer
Name one advantage of using indexes in a database.
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
indexes
0
votes
1
answer
What is the purpose of the UNION operator in Oracle SQL?
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
unionoperator
0
votes
1
answer
Explain the difference between RANK and DENSE_RANK functions in Oracle SQL.
asked
Jan 21, 2024
in
Oracle
by
rajeshsharma
dense_rank
0
votes
1
answer
Show how functions and procedures are called in a PL SQL block
asked
Jan 19, 2024
in
Oracle
by
rajeshsharma
plsqlblock
Page:
1
2
3
4
5
6
...
9
next »
Recent questions in Oracle
...
