Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

A Guide to SQL
A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter7: Database Administration
Section: Chapter Questions
Problem 4CAT: Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be...
See similar textbooks
icon
Related questions
Question

Course: Database systems: design and applications

ID 1001 1002 1003 Employee Employee Name Salary ename Eman Ali Moosa 1004 Hessa 1005 Alaa 1006 Mariam 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 0000000 IT Registration Admin Engineering Engineering IT From 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 of hiering hiredare 3/3/2000 3/4/2000 3/5/2000 3/6/2000 3/7/2000 3/8/2000 2. The correct sql statement syntax that is used to retrieve data from emp table is: a. Select emp where ID=7839 b. Select emp from ename where ID=7839 c. Select ename sal from emp where ID=7839 d. Select where ID=7839 from emp
Transcribed Image Text:ID 1001 1002 1003 Employee Employee Name Salary ename Eman Ali Moosa 1004 Hessa 1005 Alaa 1006 Mariam 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 0000000 IT Registration Admin Engineering Engineering IT From 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 of hiering hiredare 3/3/2000 3/4/2000 3/5/2000 3/6/2000 3/7/2000 3/8/2000 2. The correct sql statement syntax that is used to retrieve data from emp table is: a. Select emp where ID=7839 b. Select emp from ename where ID=7839 c. Select ename sal from emp where ID=7839 d. Select where ID=7839 from emp
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Web Page
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
SEE MORE TEXTBOOKS