Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - Modular_V2.0_SQL_Flipbook
P. 35

    C.  Write 'T' for true and 'F' for false.

                        1.  WHERE specifies the criteria according to which rows are retrieved.                 ……………………
                        2.  The % wildcard denotes a single character.                                          ……………………

                        3.  The OR logical operator is used when all conditions should be satisfied.            ……………………
                        4.  The DELETE command is used to remove columns from a table.                          ……………………
                        5.  The All operator returns FALSE if all of the subquery values meet the condition.    ……………………

                     D.  Short answer type questions.
                        1.  Define SELECT command.
                        2.  Write the syntax of the DISTINCT clause.

                        3.  What do you mean by operators?
                        4.  Define LIKE operator.

                        5.  Write the syntax to execute the SELECT queries.

                     E.  Long answer type questions.
                        1.  How do you insert records in a table? Give an example.

                        2.  How do you update records in a table? Write the syntax of UPDATE command.
                        3.  Explain any five relational operators with example.
                        4.  Explain the BETWEEN operator.

                        5.  Differentiate between Select and Update command with an example.
                                                                                                   21 st  Century   #Creativity
                     F.  Competency-based/Application-based question.                                  Skills  #Technology Literacy
                        1.   Ananya has created a table of marks of her four friends. Now, she wants to add the marks of her one
                           more friend. How can she do so?

                        2.   Neha has created a table with states and their capitals in SQL. Now, she wants to retrieve the capital of
                           a state. Which operator should she use?

                                                             In the lab                           21 st  Century   #Critical Thinking
                                                                                                      Skills
                                                                                                          #Technology Literacy
                       1.  Create the following table:

                             Admn_no         Name          Subject       Gender        Average
                                101       Amit          Maths               M            85.5
                                102       Sweta         English             F             90
                                103       Khushboo      Science             F             92
                          Now add one more row with:
                          Admn_no = 104
                          Name = Viraj

                          Subject = Computer
                          Gender = M
                          Average = 94

                                                                                                                         33
                                                                                              Handling Records in MySQL

| 30 31 32 33 34 35 36 37 38 39 40 |