Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 39 - Modular_V2.0_SQL_Flipbook
P. 39

    3.  …………………… is also known as a relation.

                        4.  …………………… are used to restrict the types of data that can be entered into a table.

                        5.  A UNIQUE constraint is automatically added to a …………………… constraint.
                        6.  The …………………… wildcard denotes the multiple characters.

                                                                  Section B
                     A.  Short answer type questions.

                        1.  What do you mean by foreign key?
                        2.  Define record.

                        3.  What is a table?
                        4.  Write the syntax of the DROP TABLE command.

                        5.  What do you mean by operators?
                        6.  Define SELECT command.
                     B.  Long answer type questions.

                        1.  Write any four features of a database.
                        2.  Explain any two commands of SQL.

                        3.  Write the steps to install MySQL.

                        4.  What do you mean by UPDATE command? Write its syntax.
                        5.  Explain any five logical operators with example.

                        6.  Differentiate between Select and Update command with an example.

                                                                                                                         37
                                                                                                           Tes t Sheet-1

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