GYAN with ANJAAN

                Problem Statement :  ---------------------->>>>    Click Here : Subscribe to click   <<<<< -------------------------- Create a class Team  and make attributes : int TeamID; String TeamName; String Location; int TotalRunsByTeam; int numberOfWicketsInTeam; Write  constructor and their getter and setter of all the attributes and make the attributes private . Write a Solution class and a main method inside it. Inside main method , create a method teamWithHighestRuns . In this method you have to pass array object and one String input and one integer value that will return integer value . we needs to check every object and if objects which has the location matched to string value taken by user and  numberOfWicketsInTeam  should be more than integer value then find the team with highest runs for the above mentioned condition .  It returns the sum and if sum is gr...

                             Multiple Choice Question On PYTHON                                              Part - 01   Some Important Points :   -->   Developed by :  Guido van Rossum -->   Extesion : .py  -->   Case Sensitive  : yes  -->   Support : oops  yes  1.  Like the else, the elif statement is optional      a. True                             b. False  2.  Suppose s is “\t\tWorld\n”, what is s.strip() ?      a. World                          b. world       c. WORLD         ...

       Problem Statement : Create a class  Resort  and make attributes : int resortID; String resortName; String category; double rating; double price; Write  constructor and their getter and setter of all the attributes and make the attributes private . Write a Solution class and a main method inside it. Inside main method , create a method avgPriceOfGivenCategory . in this method you have to pass array object and one String input that will return integer value . we needs to check every object and if any object which has the category matched to string value taken by user and rating should be more than 4 then find then find the average price of the resorts .  It returns the average price and print it  and if  returns 0 and print "No any resort" . Input : 1001 abc resort 4 star 4.5 2000 1002 xyz resort 3 star 4.7 4000 1003 pqr resort 3 star 4.3 6000 1004 efg resort 3 star 4.9 5000 Code : import java . util .*; class Resort {   ...

              Multiple Choice Questions on PL/SQL PLSQL - Procedural Language/SQL Advantage :  It offers extensive error checking ,              numerous data types and               a variety of programming structures. Q1.  What is wrong in the following code snippet? DECLARE    x number := 1; BEGIN    LOOP       dbms_output.put_line(x);       x := x + 1;       IF x > 10 THEN          exit;       END IF;      dbms_output.put_line('After Exit x is: ' || x); END; A - There is nothing wrong. B - The IF statement is not required. C - There should be an END LOOP statement. D - The exit statement should be in capital letters. Ans : c Q2.  Consider the following code snippet: how many times the loop will run? DECLARE    a number(2); BEGIN ...

                     Multiple Choice Questions on SQL  ---------------------->>>>    Click Here : Subscribe to click   <<<<< --------------------------  SQL --  Structured Query Language Table Create -   create table CREATE   TABLE  STUDENTS (   ID  INT                             NOT   NULL ,   NAME   VARCHAR  (20)  NOT   NULL ,   AGE  INT                           NOT   NULL ,   ADDRESS  CHAR  (25),   PRIMARY   KEY  (ID)   );   Insert Values :   INSERT INTO Stu...