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

When have you encountered databases being used?
Explain deleting database contents?
Server and database administrators back up data.
Both database administrators and server administrators are responsible for data backup.
Explain file processing and database processing system.
List the functions of a database management system.
Describe the importance of indexing in relation to the use of databases.
What are the benefits of using mobile databases?
Define the terms "DBMS" (Database Management System) and "RDBMS" (Relational Database Management System). Explain why relational databases are widely used.
Explain how databases utilize complex datatypes for data storage and retrieval.
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.
Ability to describe and work on simple database using database software.