ITN206 QUIZ

Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG

INF503 WEEK 5 LAB’S

LAB 1 1) 2) 3) 4) 5) 6)  LAB-2 1)  2)  3) 4) 5) LAB-3 1)CREATE INDEX upper_ix ON EMPLOYEE_REC (UPPER(Lname)); 2)SELECT Fname, LnameFROM EMPLOYEE_RECWHERE UPPER(Lname)= “SMITH”; Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on…

INF503 Week-6 LABS

LAB-1 1. 2SELECT COUNT(DISTINCT Dnumber)FROM EMPLOYEE_REC E, EMPLOYEE_DEPARTMENT DWHERE D.Dnumber = E.Dno and E.Salary > 40000; 3SELECT COUNT(*)FROM EMPLOYEE_RECWHERE EMPLOYEE_REC.Dno NOT IN (SELECT EMPLOYEE_DEPARTMENT.DnumberFROM EMPLOYEE_DEPARTMENTWHERE Zipcode =30332); 4SELECT City FROM EMP_CUSTOMERSINTERSECTSELECT City FROM EMP_SUPPLIERSORDER BY City; LAB-2 1 2 LAB-3…

LESSON 7 AND 8 LABS

Lesson – 7 Labs 1. interface Shape{     public void draw(); } class Circle implements Shape{     public void draw(){         System.out.println(“Drawing a circle”);     } } class Square implements Shape{     public void draw(){         System.out.println(“Drawing a square”);     } } public class Demo{     public static…

IS5103 WEEK 4 QUIZ

1. What is the result of the following code? 1. interface Climb { 2. boolean isTooHigh(int height, int limit); 3. } 4. 5. public class Climber { 6. public static void main(String[] args) { 7. check((h, m) -> h.append(m).isEmpty(), 5); 8. } 9. private static void check(Climb climb, int…

INF503 WEEK3 LAB SOLUTIONS

LAB-8 1. SELECT DISTINCT Pnumber, PnameFROM PROJECTWHERE  Pnumber IN(SELECT PnumberFROM PROJECT, EMPLOYEE_DEPARTMENT, EMPLOYEE_RECWHERE Dnum = Dnumber ANDMgr_ssn = Super_ssn AND Lname = ‘Zelaya’)ORPnumber IN(SELECT PnoFROM WORKS_ON, EMPLOYEE_RECWHERE Essn = Ssn AND Lname = ‘Smith’); 2. SELECT Lname, FnameFROM EMPLOYEE_RECWHERE Salary >…