GYAN with ANJAAN

                             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...