Mark

Mark

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…

IS5103 WEEK 3 QUIZ

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 ” +…

IS5103 Post Assessment

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…

IS5103 LESSON 6 QUIZ

1.  Which of the following statements can be inserted in the blank so that  the code will compile successfully? abstract class Snake {} class Cobra extends Snake {} class GardenSnake extends Cobra {} public class SnakeHandler { private Snake snakey; public void setSnake(Snake mySnake) { this.snakey…

IS5103 Week 3 Solutions

1. Which of the following can fill in the blank in this code to make it  compile?  public class Ant {  _______ void method() {}  }  Each correct answer represents a complete solution. Choose all that apply.  A) Final Private  2. Which…

IS5103 Lesson-15

1.Which is the first line containing a compiler error?String url = “jdbc:hsqldb:file:zoo”;try (var conn = DriverManager.getConnection(url);var ps = conn.prepareStatement();var rs = ps.executeQuery(“SELECT * FROM swings”)) {while (rs.next()) {System.out.println(rs.getInteger(1));}}A) Line 3 2.Which interfaces or classes are in a database-specific JAR file?Each…