Page 385 - TP_IT_V1.0_C10_flipbpookl
P. 385

c. To display the details of all students whose MARKS are less than 80.
                       d. Display the list of all students in descending order of MARKS.

                   20.  Create table EMPLOYEE                                                                       [2020]
                       EMPID                                             Char(4)
                       EMPNAME                                           Varchar(15)
                       DESIGN                                            Varchar(20)
                       SALARY                                            Decimal
                   21.               statement is used to add one or more records to a database.                    [2020]
                   22.               statement retrieves zero or more rows from one or more database tables.        [2020]
                   23.  Explain two types of languages used for creating and manipulating the data in databases.    [2020]
                   24.  Explain any three data types in OpenOffice Base.                                            [2020]

                   25.  Explain the following with respect to Databases:                                            [2020]
                       a. Forms                                          b. Reports
                       c. Table                                          d. Primary key?
                       e. Categorise the following commands as DDL and DML :
                                                         SELECT, ALTER, INSERT, DROP
                   26.  What is RDBMS?                                                                              [2019]
                   27.  What is database server ? Explain Primary key and Foreign key.                              [2019]
                   28.               command is used to create a new table in a database.                           [2018]
                       a. New                                            b. Create
                       c. Alter                                          d. Select
                   29.  Write SQL query to create the Table Flight with the following structure:                    [2018]


                                                           Field           Type
                                                      Flight_ID       Char(4)
                                                      Flight_Name     Varchar(25)
                                                      Source          Varchar(30)

                                                      Destination     Varchar(30)

                   30.  Consider the following table and answer the following:                                      [2018]
                                              ID      Department    OPD_DAYS      Doctor_Name

                                           H201       ENT          MWF          Akaash Arora
                                           H308       Oncology     TTS          Dharma Sharma

                                           H907       Paediatrics  MWF          Sanjay Singh
                       a. Identify suitable Primary Key from the above table.
                       b. Add a new record with the following data:
                           (‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)
                       c. Write a select query to display records of those Doctors whose OPD_DAYS are ‘MWF’.
                   31.  What is DDL ? Mention any two DDL statements.                                               [2018]
                   32.  What do DBMS and RDBMS stand for? Explain in short.                                         [2017]
                   33.  What do you mean by primary key and foreign key?                                            [2017]
                   34.  What do you mean by DDL and DML commands?                                                   [2017]




                                                                        Database Management System using LibreOffice Base  383
   380   381   382   383   384   385   386   387   388   389   390