Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 84 - 2629_Devagiri_C-8
P. 84

    LEARNING LOGS

                      A.  Tick ( ) the correct option.
                         1.  Identify the key used to specify a unique record in a table.
                                    (i)  Primary key                               (ii)  Secondary key

                                   (iii)  Composite key                           (iv)  None of these
                         2.   Choose the SQL operators that returns TRUE if the subquery returns one or more records.

                                    (i)  ALL                                       (ii)  ANY

                                   (iii)  EXISTS                                  (iv)  BETWEEN

                         3.  Mark the constraint that is used to specify a default value for a column.

                                    (i)  Default Constraint                        (ii)  NOT NULL Constraint

                                   (iii)  Check Constraint                        (iv)  NULL Constraint
                         4.   Select the method used to organise the creation, editing and display of data in a table.

                                    (i)  Table                                     (ii)  Form

                                   (iii)  Query                                   (iv)  Report

                         5.   Which SQL command is used to create a new table in MySQL?
                                    (i)  FORM TABLE                                (ii)  MAKE TABLE

                                   (iii)  EXECUTE TABLE                           (iv)  CREATE TABLE

                      B.  Fill in the blanks using the given hints:
                         1.   The                command describes the structure of the table.                      Hints

                                                                                                                   SHOW
                         2.                  are used to restrict the types of data that can be entered into a table.
                                                                                                                 DATABASES
                         3.   The                command retrieves zero or more rows from a table.                 SELECT
                                                                                                                    DESC
                         4.  The                 command is used to view a list of existing databases.            Database
                                                                                                                  Constraints
                         5.   A                is defined as an organised collection of data that is stored and
                             accessed electronically.

                      C.  Write ‘T’ for true and ‘F’ for false.

                         1.  A row in a table is also called a tuple.

                         2.  There can be more than one primary key in a table.

                         3.  The TIMESTAMP data type stores only hour, minute and second values.

                       82
                            Premium Edition-VIII

| 79 80 81 82 83 84 85 86 87 88 89 |