Answered: 1.1 Suppose you want to retrieve data…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

1.1 Suppose you want to retrieve data from the studentlist table, and the following error occurs
SELECT *
FROM studentlst;
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 2 Column: 6
Explain the error message and what is the possible cause of the error

1.2 Write a query to display the information of students whose last name contains letter ‘y’ and
were admitted from year 2020 and above.

1.3 The DISTINCT keyword removes duplicate rows from your results, not duplicate values
from each column. Write a query to implement DISTINCT keyword on Studentlist table to
find unique last names.

1.4 Write a query to find unique first names and last names of the students contained in the
Studentlist table

1.5 Use the IN keyword to find the students whose first names are Evelyn, Samson, and Paul
from the Studentlist