Course: Database systems: design and applications ID100110021003Employee EmployeeNameSalaryenameEmanAliMoosa1004Hessa1005Alaa1006 Mariamsal550600900300600800EmployeePhoneNumberempno399999993999999839999997399999963999999539999994EmpjobDeveloperCSHRNetworkServerSEDepartmentnumberdeptno102040303010Departmentnamedname0000000ITRegistrationAdminEngineeringEngineeringITFrom the above table, Answer the questions:Q 1) Highlight the best answer.1. Select a query that retrieves all of the unique Jobs from the Emp table?a. SELECT DISTINCT Job FROM Emp;b. SELECT UNIQUE Job FROM Emp;c. SELECT DISTINCT Job FROM TABLE Emp;d. SELECT INDIVIDUAL Job FROM Emp;Date ofhieringhiredare3/3/20003/4/20003/5/20003/6/20003/7/20003/8/20002. The correct sql statement syntax that is used to retrieve data from emp table is:a. Select emp where ID=7839b. Select emp from ename where ID=7839c. Select ename sal from emp where ID=7839d. Select where ID=7839 from emp

Employee Employee Name Salary ID 1001 1002 1003 Moosa 1004 Hessa 1005 Alaa 1006 Mariam ename Eman Ali sal 550 600 900 300 600 800 Employee Phone Number empno 39999999 39999998 39999997 39999996 39999995 39999994 Emp job Developer CS HR Network Server SE Department number deptno 10 20 40 30 30 10 Department name dname IT Registration Admin Engineering Engineering IT Date of hiering hiredare 3/3/2000 3/4/2000 3/5/2000 3/6/2000 3/7/2000 3/8/2000

Employee Employee Name Salary ID 1001 1002 1003 Moosa 1004 Hessa 1005 Alaa 1006 Mariam ename Eman Ali sal 550 600 900 300 600 800 Employee Phone Number empno 39999999 39999998 39999997 39999996 39999995 39999994 Emp job Developer CS HR Network Server SE Department number deptno 10 20 40 30 30 10 Department name dname IT Registration Admin Engineering Engineering IT Date of hiering hiredare 3/3/2000 3/4/2000 3/5/2000 3/6/2000 3/7/2000 3/8/2000

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

Relational databases have six key traits.
Explain the significance of database design.
Relational and object-oriented database architectures exist.
Describe a typical Web-enabled database environment.
what are the various kinds of interactions catered by database
Explain the concept of distributed databases and their significance in modern IT systems.
Explain the concept of a database to management and highlight the components of a database
Explain the concept of distributed databases and their advantages in a large-scale enterprise environment.
Explain Flat-File and Relational Database Structures.
Use of a database has what advantages and disadvantages?
What are the main advantages of electronic databases?
Explain why database is important and connected to discrete mathematics/computer science