Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 38 - Modular_V2.0_SQL_Flipbook
P. 38

    Test Sheet-1

                          (Based on chapters 1 to 3)

                                                               Section A

                  A.  Tick ( ) the correct option.

                      1.  Which of the following keys is used to specify a unique field in a table?
                        a.  Primary key                                   b.  Secondary key
                        c.  Composite key                                 d.  None of these
                      2.  The term “TCL” stands for …………………… .

                        a.  Termination Control Language                  b.  Transmission Control Language
                        c.  Transaction Central Language                  d.  Transaction Control Language

                      3.  Which SQL command is used to create a new table in MySQL?
                        a.  FORM TABLE                                    b.  MAKE TABLE

                        c.  EXECUTE TABLE                                 d.  CREATE TABLE
                      4.  Which of the following data types is used to include decimal numbers?

                        a.  Integer                                       b.  Float
                        c.  Date                                          d.  Bool
                      5.  The wildcard characters used in LIKE operator are …………………… and …………………… .

                        a.  (_), *                                        b.  %, *

                        c.  (_), %                                        d.  _ , %
                      6.  Which of the following does not fall under the relational operators?

                        a.  <,<=                                          b.  >,>=
                        c.  <,>                                           d.  AND, OR

                  B.  Write ‘T’ for true and ‘F’ for false.
                      1.  There can be only one table in a database.                                          ……………………

                      2.  There can be more than one primary key in a table.                                  ……………………
                      3.  The TIMESTAMP data type stores hour, minute and second values.                      ……………………

                      4.  SQL constraints are used to define rules for table data.                            ……………………
                      5.  The DELETE command is used to remove columns from a table.                          ……………………

                      6.   WHERE specifies the criteria according to which rows are retrieved.                ……………………

                  C.  Fill in the blanks.
                      1.  The concept of relational database was developed by …………………… .
                      2.  The main table of a database is referred to as the …………………… .

                    36
                          Touchpad MODULAR (Ver. 2.0)

| 33 34 35 36 37 38 39 40 41 42 43 |