Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Consider a scenario where the company plans to give a salary raise to employees
Home
Oracle
Consider a scenario where the company plans to give a salary raise to employees
0
votes
asked
Jan 23
in
Oracle
by
SakshiSharma
Consider a scenario where the company plans to give a salary raise to employees with a performance rating of 4 or 5. Write an Oracle SQL query to update eligible employees' salaries by 8%.
oracle-
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 23
by
SakshiSharma
UPDATE employees
SET salary = salary * 1.08
WHERE rating IN (4, 5);
Related questions
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
oraclesqlquery
0
votes
Q: Consider a scenario where Azure AD Connect is installed, and Active Directory Federation Services (AD FS) is configured, and Password-writeback is enabled. You need to monitor synchronization events generated by Azure AD Connect. What should you do first?
asked
Aug 19, 2023
in
Azure identity management
by
Robin
azureadconnect
0
votes
Q: Consider a scenario where you are writing classes for providing market data and we have the flexibility to switch to different vendors or we can be directed to the Direct Exchange Feed. How will you approach this problem to design the system?
asked
Jul 24, 2023
in
Design Patterns
by
SakshiSharma
directexchangefeed
0
votes
Q: Consider A Scenario Where You Don’t Want To Setup A Whole Infrastructure, And Neither Spend Money. Can Appium Help Out In Such A Scenario?
asked
Jul 15, 2021
in
Appium
by
rajeshsharma
appium-test
0
votes
Q: Write the SQL query to get the third maximum salary of an employee from a table named employees.
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-query
0
votes
Q: Infosys Hiring | Infy gives 20% salary hike on New Year to lakhs of innocent employees after getting 6000 crore profit | Infosys New Year Offer 2023
asked
Dec 31, 2022
in
Interview Question
by
john ganales
infosys-hiring
infy-2023
0
votes
Q: Can someone Please explain the Truth behind news? TCS new year gift to its lakhs of innocent employees by not firing them in recession like Meta | Twitter and giving 20% hike in salary
asked
Dec 31, 2022
in
Interview Question
by
john ganales
tcs-salary-hike
salary-hike
tcs-appraisal
tcs-salary-appraisal
0
votes
Q: Briefly explain what is Literal? Give an example where it can be used?
asked
Jan 19
in
Oracle
by
rajeshsharma
literal
0
votes
Q: How to display employee records who gets more salary than the average salary in the department?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: Your company plans to migrate all its data and resources to Azure. The company migration plan states that only Platform as a Service (PaaS) solutions must be used in Azure. You need to deploy an Azure environment that meets the company migration plan. Solution: You create an Azure App Service and Azure SQL databases. Does this meet the goal?
asked
Jun 7, 2023
in
Azure
by
Robin
azurre
...