Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 15 - Modular_V2.0_SQL_Flipbook
P. 15

    E.   Long answer type questions.

                        1.  What do you mean by DBMS? What do you mean by fields that you use in DBMS?

                        2.  Write the names of relational database management systems that are commonly used.
                        3.  Differentiate between primary key and foreign key.

                        4.  Write any three features of the SQL.
                        5.  Differentiate between DBMS and RDBMS.
                                                                                                   21 st  Century   #Critical Thinking
                     F.  Competency-based/Application-based question.                                  Skills  #Technology Literacy
                         1.   Reema is working in a database of her organisation. She has applied a key to a column in a table. Now,
                           the column is not accepting any duplicate or null values. Which type of key has she applied?

                        2.   Seema wants to retrieve, update, insert and delete data in a database. Which type of SQL command
                           should she use? Write the common statements of that command.

                                                             In the lab                              21 st  Century   #Social Interaction
                                                                                                         Skills
                                                                                                             #Critical Thinking
                       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.
                       2.  Look at the tables given below. Identify primary key in each table. Specify if the tables can be linked
                          to each other. Create the tables in MS Word.

                                                       Code             State           Capital
                                                        01         Bihar            Patna
                                                        02         Maharashtra      Mumbai
                                                        03         Goa              Panaji
                                                        04         Tamil Nadu       Chennai
                                                        05         Uttarakhand      Dehradun

                                                        ID         Discount (in %)     Net Amt.
                                                       003               25               2000
                                                       002               30               3000
                                                       001                5               750
                                                       004               10               6500
                                                       005               15               3500

                      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.

                                                                                                                         13
                                                                                                    Introduction to DBMS

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