Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 71 - Modular_V2.0_SQL_Flipbook
P. 71

    C.  Fill in the blanks.
                        1.  The …………………… keyword sorts the data in a table in ascending or descending order.

                        2.  The …………………… clause is same as “Having” clause in MySQL.

                        3.  Date functions operate on values of the …………………… data type.
                        4.  Common columns are the columns that have …………………… name in both the tables.

                        5.  The join where all possible row combinations are produced is called …………………… .
                        6.  The equi join uses …………………… operator to join two tables.

                                                                  Section B

                     A.  Short answer type questions.
                        1.  What is the use of Group By command?

                        2.  What are aggregate functions in MySQL?
                        3.  What is the purpose of NOW() function?

                        4.  What is the purpose of an Index in a database?

                        5.  What is the difference between INNER JOIN and OUTER JOIN?
                        6.  What is the syntax for creating a View in SQL?

                     B.  Long answer type questions.
                        1.  Differentiate between Group By and Order by clause?

                        2.  Differentiate between DATE, MONTH and YEAR functions.
                        3.   Describe the different types of indexes. Provide examples for each.

                        4.   Design two tables named as Bank and Customer with at least 4 fields. Show Equijoin and Natural join
                           in both the tables through command.

                                                                                                                         69
                                                                                                           Tes t Sheet-2

| 66 67 68 69 70 71 72 73 74 75 76 |