Wipro Talent Next 2023-2024

 

login URL  :            https://talentnext.wipro.com/PBLApp

login credential file:        login ids 

Quiz Questions:

day 2 : Operators

Day 3: Operators

Day 4: Java Fundamental Quiz

Day 5: java Basics

day 6 Java Arrays Basic

day 7 class (Variables, methods, static....)

day 8 Access Modifiers Inheritance & Polymorphism

day 9 :Packages, Interfaces & Exception Handling

Problem Solving:

level1

level2

level3

level4

CREATE TABLE SAILORS(SID NUMBER,SNAME VARCHAR2(10),RATING NUMBER(2),AGE NUMBER(4,2));

ALTER TABLE SAILORS ADD CONSTRAINT PK_SAILORS PRIMARY KEY(SID);

DESC SAILORS;

CREATE TABLE BOATS (BID NUMBER,BNAME VARCHAR2(10),COLOR VARCHAR2(10));

ALTER TABLE BOATS ADD CONSTRAINT PK_BOATS PRIMARY KEY(BID);

CREATE TABLE RESERVES(SID NUMBER,BID NUMBER,DAY DATE);

ALTER TABLE RESERVES ADD CONSTRAINT PK_RESERVES PRIMARY KEY(SID,BID,DAY);

ALTER TABLE RESERVES ADD CONSTRAINT FK_RESERVES FOREIGN KEY(SID) REFERENCES SAILORS(SID);

ALTER TABLE RESERVES ADD CONSTRAINT FK_RESERVES1 FOREIGN KEY(BID) REFERENCES BOATS(BID);

DESC RESERVES;

DESC BOATS;

INSERT INTO SAILORS VALUES(22,'DUSTIN',7,45.0);

INSERT INTO SAILORS VALUES(29,'BRUTUS',1,33.0);

INSERT INTO SAILORS VALUES(31,'LUBBER',8,55.5);

INSERT INTO SAILORS VALUES(32,'ANDY',8,25.5);

INSERT INTO SAILORS VALUES(58,'RUSTY',10,35.5);

INSERT INTO SAILORS VALUES(64,'HORATIO',7,35.0);

INSERT INTO SAILORS VALUES(71,'ZORBA',10,16.0);

INSERT INTO SAILORS VALUES(74,'HORATIO',9,35.0);

INSERT INTO SAILORS VALUES(85,'ART',3,25.0);

INSERT INTO SAILORS VALUES(95,'BOB',3,63.5);

COMMIT;

SELECT * FROM SAILORS;

INSERT INTO BOATS VALUES(101,'INTERLAKE','BLUE');

INSERT INTO BOATS VALUES(102,'INTERLAKE','RED');

INSERT INTO BOATS VALUES(103,'CLIPPER','GREEN');

INSERT INTO BOATS VALUES(104,'MARINE','RED');

SELECT * FROM BOATS;

INSERT INTO RESERVES VALUES(22,101,'10-OCT-1998');

INSERT INTO RESERVES VALUES(22,102,'10-OCT-1998');

INSERT INTO RESERVES VALUES(22,103,'10-AUG-1998');

INSERT INTO RESERVES VALUES(22,104,'10-JUL-1998');

INSERT INTO RESERVES VALUES(31,102,'11-OCT-1998');

INSERT INTO RESERVES VALUES(31,103,'11-JUN-1998');

INSERT INTO RESERVES VALUES(31,104,'11-DEC-1998');

INSERT INTO RESERVES VALUES(64,101,'09-MAY-1998');

INSERT INTO RESERVES VALUES(64,102,'09-AUG-1998');

INSERT INTO RESERVES VALUES(74,103,'09-AUG-1998');

SELECT * FROM RESERVES;

Thread Notes

SQL Videos Link:

https://www.youtube.com/watch?v=YO_lK4kpO6o&list=PL3HCtAHf9xFelx51jf-b9vfCBgZkVcS35&index=1&pp=gAQBiAQB