Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 141 - CodePilot V5.0 C8
P. 141

    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.

                                                                                                                      139
                                                                                              MySQL: My First Database

| 136 137 138 139 140 141 142 143 144 145 146 |