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); …
1.You are a team facilitator mentoring a junior team member. You are showing this team member a chart that shows what user stories are yet to start, what has been started, and what has been finished. What chart are you…
1. Match the terms on the left to the scenarios on the right. A). 2. You notice that one of the machines on the production line is working inefficiently and has produced several defects. Some of the defects need to…
Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG
Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG
Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG
Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG
