Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 14 - Modular_V2.0_SQL_Flipbook
P. 14

    2.  Which of the following keys is used to specify a unique record in a table?
                        a.  Primary key                                  b.  Secondary key

                        c.  Composite key                                d.  None of these
                     3.  Which of the following is an organised way of creating, editing and displaying data from the table?

                        a.  Table                                        b.  Form
                        c.  Query                                        d.  Report
                     4. The ability to query data, as well as insert, delete, and update, is offered by …………………….
                        a.  Transaction Control Language (TCL)           b.  Data Control Language (DCL)

                        c.  Data Definition Language (DDL)               d.  Data Manipulation Language (DML)
                     5. The term "TCL" stands for …………………….
                        a.  Termination Control Language                 b.  Transmission Control Language

                        c.  Transaction Central Language                 d.  Transaction Control Language
                  B.  Write 'T' for true and 'F' for false.

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

                     2.  There can be only one table in a database.                                           ……………………
                     3.  A field represents one related part of a table.                                      ……………………

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

                     5.  All the related information on a topic can be viewed in one single table.            ……………………

                  C.  Fill in the blanks using the words given below:

                                                     E.F. Codd, DBMS, Master Table, record, field

                     1.   A …………………… is a computerised record keeping system whose purpose is to manage the data and
                        make it available as per the requirement.
                     2.  A …………………… represents one related part of a table.

                     3.  The concept of relational database was developed by …………………….
                     4.   A …………………… is a collection of multiple data which is stored in related fields that can be treated as a
                        single unit.
                     5.  The main table of a database is referred to as the …………………….

                  D.  Short answer type questions.

                     1.  What is a database?
                     2.  What is an attribute in a database table?
                     3.  What is SQL?

                     4.  What is a table?
                     5.  Define record.

                    12
                          Touchpad MODULAR (Ver. 2.0)

| 9 10 11 12 13 14 15 16 17 18 19 |