Page 233 - IT_V1.0_Class10
P. 233

3.  A  table  is  a  set  of  data  elements  that  is  organized  using  a  model  of  vertical  .............................  and  horizontal
                      ..............................                                             [CBSE Sample Paper, 2022]
                       i.  Rows, Tables       ii.  Columns, Rows       iii.  Rows, Columns           iv.  Forms, Reports
                     4.  After creating a table in LibreOffice Base, you realise you need to add a new field. What can you do?
                       i.   Create a new table                         ii.   You cannot add new fields once the table is created
                       iii.  Delete the existing table                 iv.  Modify the structure of the table
                 B.  State whether the following statements are true or false:

                     1.  Tables are the basic element of a database where data is stored in columns and rows.   ............................
                     2.  VARBINARY data type is used to store fixed-length binary data.                      ............................
                     3.  Text data type can include special characters.                                      ............................
                     4.    button is clicked to move to the first record of the table.                       ............................

                     5.  You can the  properties of a field based on the selected data type.                 ............................
                 C.  Assertion and reasoning question.
                                                                                                        21 st
                                                                                                     Century   #Critical Thinking
                    The following question consists of two statements – Assertion (A) and Reason (R).    Skills
                    Answer the question by selecting the appropriate option given below:
                    i.  Both A and R are true and R is the correct explanation of A.

                    ii.  Both A and R are true but R is not the correct explanation of A.
                    iii.  A is true but R is false.
                    iv.  A is false but R is true.
                       Assertion (A): The Memo data type allows for storing descriptive data exceeding 255 characters.
                       Reason (R): Memo data type has a capacity of up to 64,000 characters and is ideal for lengthy text entries.

                                                   Section B (Subjective Type Questions)
                 A.  Answer the following questions:
                     1.  What do you understand by the term Default value of a field in ‘LibreOffice Base’?
                     2.  Write the difference between CHAR data types and VARCHAR datatype.
                     3.  Write the steps to set primary key on the table.
                     4.  Write the steps to create a table in design view.
                     5.  Explain any five components of LibreOffice Base interface window.
                                                                                                        21 st
                                                                                                     Century   #Critical Thinking
                 B.  Application-based question.                                                       Skills
                    Consider the table ProductInventory and answer the following questions:
                       ProductID          ProductName            Category           Price       QuantityInStock
                          1001           Apple iPhone 13        Electronics          700               50
                          1002         Samsung Galaxy S21       Electronics          750               30
                          1003             Dell XPS 13          Computers           1200               20
                          1004             Nike Air Max          Footwear            120              100
                          1005             LG OLED TV           Electronics         2000               15
                          1006          Adidas Ultraboost        Footwear            150               80
                          1007           Lenovo ThinkPad        Computers           1100               25

                          1008           Samsung 55" TV         Computers            800               40
                    Questions:
                    i.  Identify the field that will be considered as the primary key in the ProductInventory table.
                    ii. Write the steps to modify the category of Samsung 55” TV from Computers to Electronics.


                                                                                     Starting with LibreOffice Base  231
   228   229   230   231   232   233   234   235   236   237   238