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…
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 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…
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…
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 >…
1. CREATE TABLE EMPLOYEE_UC(Ssn VARCHAR(5) NOT NULL PRIMARY KEY,Fname VARCHAR(15) NOT NULL,Minit VARCHAR(15) NOT NULL,Lname VARCHAR(15) NOT NULL,Bdate DATE,Address VARCHAR(30),Gender CHAR,Salary Decimal(10,2),Age INT); 2. CREATE TABLE DEPARTMENT_UC(Dptname VARCHAR(15),Dptnmbr INT NOT NULL PRIMARY KEY,Mgr_ssn CHAR(9),Mgr_start_date DATE,Mgr_last_date DATE,Ssn VARCHAR(5) FOREIGN KEY REFERENCES…
1. Which of the following statements can be inserted in the blank line sothat the code will compile successfully? interface CanHop {}public class Frog implements CanHop {public static void main(String[] args) {_ frog = new TurtleFrog();}}class BrazilianHornedFrog extends Frog {}class…
Lesson – 9 1. import java.util.*; import java.util.ArrayList; import java.util.Collection; public class Demo{ public static void main(String[] args){ Collection<String> city = new ArrayList<>(); city.add(“Chicago”); city.add(“Boston”); city.add(“Austin”); city.add(“Seattle”); city.add(“Nashville”); city.remove(“Austin”); city.remove(“Chicago”); System.out.print(city); …
Lesson-5 public int add(int x, int y){ int sum = x + y; return sum; } public static void main(String args[]){ Addition obj = new Addition(); int sum = obj.add(10, 20); System.out.println(“The sum of 10 and 20 is ” +…
1.How many of the following lines contain a compiler error?long min1 = 123.0, max1 = 987L;final long min2 = 1_2_3, max2 = 9 _ 8 _ 7;long min3 = 123, int max3 = 987;long min4 = 123L, max4 = 987;long…
