You have a table Employee(emplD,name,salary,address). What is the SQL command used to add JD10 for employees who live in Amman? Select one: a. update employee set address='Amman' where salary=salary+10; O b. update employee set salary=salary+10 where address='Amman'; O c. update employee set address='Amman' where salary=10; O d. update employee set salary=10 where address='Amman';

You have a table Employee(emplD,name,salary,address). What is the SQL command used to add JD10 for employees who live in Amman? Select one: a. update employee set address='Amman' where salary=salary+10; O b. update employee set salary=salary+10 where address='Amman'; O c. update employee set address='Amman' where salary=10; O d. update employee set salary=10 where address='Amman';

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Database
DBMS (q Database management
DATABASE
Database
Course : Database system
Database question:
database multiple choice question pls
Database
Explain how indexing and querying work with complex data types, such as geospatial data or arrays, in a database system. Provide examples and optimization techniques.
Database Managenemnt systems
33 database
Explain the concept of spatial data types in a database system. Provide examples of applications where spatial data types are crucial.