Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 7 - Modular_V2.0_SQL_Flipbook
P. 7

    Assessment Resources

                                            Exercise: This section has objective and subjective questions.
                                                       Exercise             D.  Short answer type questions.
                                                                             1.  What is a database?

                                                 A.   Tick ( ) the correct option.     2.  What do you mean by foreign key?
                                                    1.  Which SQL command is used to create a new table in MySQL?      3.  What is SQL?
                                                    a.  FORM TABLE       b.  MAKE TABLE       4.  What is a table?
                                                    c.  EXECUTE TABLE      d.  CREATE TABLE      5.  Define record.
                                                    2.  Which of the following data types is used to include decimal numbers?   E.   Long answer type questions.
                                                    a.  Integer      b.  Float       1.  What do you mean by DBMS? Write the name of the fields in which DBMS are used.
                                                    c.  Date      d.  Bool      2.  Write the names of relational database management systems that are commonly used.
                                                    3.  The …………………… constraint restricts the value range that can be placed in a column.     3.  Differentiate between primary key and foreign key.
                                                    a.  DEFAULT      b.  UNIQUE      4.  Write any three features of the SQL.
                                                    c.  CHECK      d.  None of these      5.  Differentiate between DBMS and RDBMS.
                                                    4.  Which of the following clause is used to delete column?   F.  Application based question.  Experiential Learning
                                                    a.  REMOVE COLUMN       b.  DROP COLUMN    1.  Reema is working in a database of her organisation. She has applied a key to a column in a table. Now,
                                                    c.  DELETE COLUMN        d.  ERASE COLUMN    the column is not accepting any duplicate or null values. Which type of key has she applied?
                                                    5.  Which of the following data types is used to include character string with variable length of n?     2.  Seema wants to retrieve, update, insert and delete data in a database which SQL command should she
                                                                             use. Write the common statements of that command.
                                                    a.  CHARACTER (n)       b.  VARCHAR (n)
                                                    c.  FLOAT( p)       d.  None of these   In the lab  Subject Enrichment
                                                 B.  Write 'T' for true and 'F' for false.  1.  Collect the details of any 10 students of your class and write them in MS Word document in the form
                                                                             of rows and columns. Identify the column that can be used as a primary key.
                                                    1.  In a database table, every column must have a name and data type.   ……………………  Code  State  Capital
                                                    2.  A data type defines a sort of value that a column will contain.   ……………………  01  Bihar  Patna
                                                    3.  The TIMESTAMP data type stores hour, minute and second values.    ……………………  02  Maharashtra  Mumbai
                                                    4.  Primary keys must have unique values and may have NULL values.   ……………………  03 04  Goa Tamil Nadu  Panjima
                                                                                      Chennai
                                                    5.  SQL constraints are used to define rules for table data.   ……………………  05C  Uttarakhand  Dehradun
                                                 C.  Fill in the blanks using the words given below.
                                                                             2.  Look at the tables given below. Identify primary key in each table. Specify can the tables be linked
                                                                             to each other. Create the tables in MS Word.
                                                       Table, One, Modifying, Constraints, SQL  ID  Discount (in %)  Net Amt.
                                                                                  003  25  2000
                                                    1.  …………………… constraints are used to define rules for table data.  002  30  3000
                                                    2.  …………………… is also known as a relation.  001  5  750
                                                    3.  A table can only have …………………… primary key.  004  10  6500
                                                                                  005  15  3500
                                                    4.  …………………… a table means making a change in the base structure of the table.
                                                    5.  …………………… are used to restrict the types of data that can be entered into a table.  Teacher's Corner
                                                                            1.   Before starting the chapter, ask the students name of any two database software.
                                                                            2.  Explain the students about differences between DBMS and RDBMS with example.
                                                  20  Touchpad MODULAR (Version 1.0)  12  Touchpad MODULAR (Version 1.0)
                                          Test Sheet: This section                Project Work: This is an
                                          has questions to assess                 assessment to challenge
                                                 students.                       the students to apply the
                                                                                      concepts learn.
                                                       Test Sheet-1
                                                       (Based on chapters 1 to 3)          PROJECT WORK
                                                    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   Project 1  Creativity
                                                2.  The term “TCL” stands for …………………… .  Bharat Associates Pvt. Ltd. wants to design a database which can store the details of its
                                                a.  Termination Control Language      b.  Transmission Control Language   Customers and make their billing details. The table name and its structure are as follows:
                                                c.  Transaction Central Language      d.  Transaction Control Language
                                                3.  Which SQL command is used to create a new table in MySQL?   Table Name : CUSTOMER  Table Name : BILLDETAILS
                                                a.  FORM TABLE       b.  MAKE TABLE    Field Name   Data Type   Field Name  DataType
                                                c.  EXECUTE TABLE      d.  CREATE TABLE
                                                                                     CustId   Number[NUMERIC]   CustID   Number[NUMERIC]
                                                4.  Which of the following data types is used to include decimal numbers?
                                                                                     CName   Text[VARCHAR]   Quotation   Number[NUMERIC]
                                                a.  Integer      b.  Float
                                                                                     Add1   Text[VARCHAR]  Challan  Number[NUMERIC]
                                                c.  Date       d.  Bool
                                                                                     STATEID   Number[NUMERIC]   Bill  Number[NUMERIC]
                                                5.  The wildcard characters used in Like operator are …………………… and …………………… .
                                                a.  (_), *      b.  %, *             Phone   Number[NUMERIC]   Amount_Billed  Number[NUMERIC]
                                                c.  (_), %      d.  *, $             Mobile       Number[NUMERIC]   Amount_Paid   Number[NUMERIC]
                                                6.  Which of the following does not fall under the relational operators?
                                                                                     ContactPerson   Text[VARCHAR]
                                                a.  <,<=       b.  >,>=              CreditLimit   Number[NUMERIC]
                                                c.  <,>      d.  AND, OR
                                             B.  Write ‘T’ for true and ‘F’ for false.
                                                                                           Table Name : STATE
                                                1.  In a database, data can be simultaneously accessed by many users.   ……………………
                                                                                         Field Name   Data Type
                                                2.  There can be more than one primary key in a table.   ……………………
                                                                                       StateID   Number[NUMERIC]
                                                3.  The TIMESTAMP data type stores hour, minute and second values.    ……………………
                                                4.  SQL constraints are used to define rules for table data.   ……………………  StateName   Text[VARCHAR]
                                                5.  The DELETE command is used to remove columns from a table.   ……………………    Generate a query that will display the records of Customer Table along with Statename and Billing
                                                6.   WHERE specifies the criteria according to which rows are retrieved.   ……………………  details of the customer.
                                             C.  Fill in the blanks.                   Update any CustID in CUSTOMER table and verify if the same gets updated in BILLDETAILS table.
                                                1.  The concept of relational database was developed by …………………… .
                                                2.  The main table of a database is referred to as the …………………… .
                                                         Test Sheet-1  31
                                                                                                 Project Work  55
                                                      Teacher's Resources
                        Teacher’s Resources facilitate the teaching learning process. This includes:
                          Teacher’s Note: This section provides notes for extended teaching.
                          Teacher’s Resource Material: This includes complete answer key to the coursebook and worksheets.

| 2 3 4 5 6 7 8 9 10 11 12 |