Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 70 - Modular_V2.0_SQL_Flipbook
P. 70

    Test Sheet-2

                          (Based on chapters 4 & 5)

                                                               Section A

                  A.  Tick ( ) the correct option.

                     1.   If you have not specified ASC or DESC after a SQL ORDER BY clause, the ……………………  is used by
                        default.
                        a.  DESC                                         b.  ASC

                        c.  Default                                      d.  None of these
                     2.   Which of the following function helps to count the number of records or values in a specified column/
                        expression?

                        a.  Min()                                        b.  Max()
                        c.  Count()                                      d.  Sum()

                     3. Which of the following clauses allow the sorting of query results by one or more columns?

                        a.  Update                                       b.  Drop
                        c.  Alter                                        d.  Order By

                     4. Which of the following is the correct syntax for CREATE INDEX command?

                        a.  INSERT INDEX index_name ON table_name;
                        b.  INSERT INDEX index_name ON database_name;

                        c.  CREATE INDEX index_name ON database_name;
                        d. CREATE INDEX index_name ON table_name;

                     5.  Which of the following index types can be applied to multiple columns to uniquely identify rows?

                        a.  Primary Index                                b.  Unique Index
                        c.  Composite Index                              d.  Spatial Index

                     6.  Which of the following can be defined as a query within another query?
                        a.  Index                                        b.  Subquery

                        c.  Join                                         d.  View

                  B.  Write ‘T’ for true and ‘F’ for false.
                     1.  The Desc attribute is used to describe the table structure.                          ……………………
                     2.  Alias is a temporary name given to a table.                                          ……………………

                     3.  SIGN() function returns the sign of a given number.                                  ……………………

                     4.  The operator used in an equi join is = to match values.                              ……………………
                     5.  Views are virtual and can be dropped; they are not permanent like tables.            ……………………

                     6.  A join query produces a Cartesian product with a join condition.                     ……………………

                    68
                          Touchpad MODULAR (Ver. 2.0)

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