Page 379 - TP_IT_V1.0_C10_flipbpookl
P. 379

21 st   #Communication
                 C.  Competency-based/Application-based questions.                        Century   #Leadership & Responsibility
                                                                                           Skills

                    1.  A restaurant wants to maintain the list of their customers in a RDBMS.
                       a. Suggest him a few RDBMS software.
                       b. Name a few columns that can be created for storing customer information.
                       c. Which column can be created as a Primary key?
                       d. What is another name for a row and a column in RDBMS?
                  Ans.  a. Oracle, IBM DB2, LibreOffice Base, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.
                       b. Few columns can be Customer Code, Customer Name, Address, Phone number, City.
                       c. Customer code can be created as a Primary Key.
                       d. Another name for row is Tuple and for column is Attribute.
                    2.  Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s, date of purchase, expiry date,
                       price, etc. in a database program. But he does not have any knowledge about the database. Explain to him the following
                       to get a better understanding of the DBMS concepts.
                       a. What is DBMS?
                       b. Name any two database programs which can be used to create a table and store the data as per the requirement.
                       c. Which field can be set as a Primary Key?
                       d. Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify your answer.
                  Ans.  a.  A database management system is a software package with computer programs that controls the creation, maintenance,
                         and use of a database. It allows organisations to conveniently develop databases for various applications.
                       b.  Two databases are: i. Microsoft Access ii. MySQL iii. LibreOffice Base.
                       c.  A  field  in  a  table  that  ensures  each  record  is  uniquely  identified  and  prevents  duplicate  entries  can  be  set  as  a
                         Primary Key.
                       d.  No, we cannot make more than one column as a primary key in a table because it is uniquely identify a record in the
                         table.
                    3.  A teacher has created a list of students' details and marks in a database. She is not very familiar with the use of the
                       database. Help her in setting a few field properties and where are these field properties available:
                       a. Generate the roll numbers automatically.
                       b. The name field should have a maximum of 20 characters.
                       c. Marks should store value upto 1 decimal place.
                       d. Display the date of birth in dd-month-yyyy format.
                       e. Wanted to keep the place as default ‘Delhi’.
                  Ans.  The field properties are available in the Design view of the table.
                       a. Autovalue
                       b. Length
                       c. Decimal Value
                       d. Format
                       e. Default
                    Assertion and Reasoning Questions:
                    Direction: Questions 4-5, consist of two statements – Assertion (A) and Reasoning (R). Answer these questions selecting the
                    appropriate option given below:
                       a. Both A and R are true and R is the correct explanation of A.
                       b. Both A and R are true but R is not the correct explanation of A.
                       c. A is true but R is false.
                       d. A is false but R is true.
                    4.  Assertion (A): The TINYINT data type can store values from -128 to 127.
                       Reasoning (R): TINYINT is an unsigned data type that can store integer values ranging from 0 to 255.


                                                                        Database Management System using LibreOffice Base  377
   374   375   376   377   378   379   380   381   382   383   384