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

