Page 33 - ipp11
P. 33

14.  Which method is used to get all the keys from a dictionary?                             (1)
                      (a)  get_keys()                          (b)  keys()
                      (c)  allKeys()                           (d)  dict_keys()
                Ans.   (b)  keys()
                 15.  What will be the output of the following code?                                          (1)
                    my_dictt = {}
                     print(my_dictt.get("M", "Message Not Sent"))
                      (a)  Message Not Sent                    (b)  M
                      (c)  (M, Message Not Sent)               (d)  Error
                Ans.   (c)  Message Not Sent
                 16.  Which SQL command is used to create a new table?                                        (1)
                      (a)  ALTER TABLE                         (b)  CREATE TABLE
                      (c)  MAKE TABLE                          (d)  ADD TABLE

                Ans.   (b)  CREATE TABLE
                 17.  How many primary keys can a table have?                                                 (1)
                      (a)  Zero                                (b)  Two
                      (c)  Unlimited                           (d)  One
                Ans.   (d)  One
                 18.  Which operator is used to check if a value is within a given range in SQL?              (1)
                      (a)  IN                                  (b)  BETWEEN
                      (c)  LIKE                                (d)  NOT

                Ans.   (b)  BETWEEN
                 19.  Which SQL command is used to retrieve only unique values from a column?                 (1)
                      (a)  SELECT UNIQUE                       (b)  SELECT DIFFERENT
                      (c)  SELECT DISTINCT                     (d)  SELECT ONLY
                Ans.   (c)  SELECT DISTINCT

               Q. 20 and 21 are Assertion (A) and Reason (R) based questions. Mark the correct choice as:
                      (a)  Both A and R are true and R is the correct explanation of A.
                      (b)  Both A and R are true but R is not the correct explanation of A.
                      (c)  A is true but R is false.
                      (d)  A is false but R is true.
                 20.  Assertion (A): Artificial Intelligence  (AI) is revolutionizing industries by automating processes,
                    optimizing decision-making and increasing efficiency.
                    Reasoning (R): AI operates solely on predefined instructions and lacks the ability to learn or adapt to new
                    information.                                                                              (1)
                Ans.   (c)  A is true but R is false.
                 21.  Assertion (A): In Python, input() function is used to take user input from the console.
                    Reasoning (R): print() function in Python is used to display the output on the screen.    (1)
                Ans.   (b)  Both A and R are true but R is not the correct explanation of A.

                                                   SECTION B (7 × 2 = 14 Marks)
                 22.  (a)  What are the basic components of CPU?                                              (2)
                                                               OR
                      (b)  What are the various applications of AI?
                Ans.   (a)  The basic components of CPU are:
                          (i)  Arithmetic Logic Unit (ALU)
                          (ii)  Control Unit (CU)
                         (iii)  Registers
                                                               OR
                                                              M.3
   28   29   30   31   32   33   34   35   36   37   38