Page 383 - TP_IT_V1.0_C10_flipbpookl
P. 383
Previous Years' Questions
1. In OpenOffice Base, the relationship applied on the tables can be removed with the help of
option. [2024]
a. Clear b. Remove
c. Drop d. Delete
2. In SQL, the keyword to display records in ascending order is: [2024]
a. Asce b. Incr
c. Asc d. High
3. is a numeric data type which can store Yes/No type values in the form of 0 or 1 in OpenOffice
Base table. [2024]
a. Boolean b. Binary
c. Char d. OtherObject
4. Which of the following statement retrieves zero or more rows from one or more database tables or database
views? [2024]
a. UPDATE b. DELETE
c. SELECT d. DISPLAY
5. Roshni has created a table Customer in SQL and wants to store photograph image of every customer under Cust photo
field. Suggest a suitable data type from the options given below. [2024]
a. IMAGE b. PICTURE
c. LONGVARBINARY d. GRAPHIC
6. By default, all the fields in OpenOffice Base will have datatype. [2024]
a. int (tiny) b. Boolean
c. text (varchar) d. text (char)
7. Give any two benefits of creating relationships between tables in a database. [2024]
8. In context of OpenOffice Base, explain the concept and significance of the following: [2024]
a. Forms
b. Reports
9. Consider the table Product and write SQL queries for the following: [2024]
PID PNAME PRICE QUANTITY CATEGORY
P01 BOARD 10000 2 OFFICE
P02 EYELINER 700 50 MAKEUP
P04 PENCIL 5 500 SCHOOL
P05 LAMP 250 10 DOMESTIC
P08 BEDSHEET 450 45 DOMESTIC
P09 LAPTOP 75000 15 OFFICE
a. To display names of all products whose category is “domestic”.
b. To display product name and price whose quantity is less than 50.
c. To display price and quantity of Laptop.
d. To display name and quantity of those products whose price is above 5000.
For Visually Impaired Candidates:
In the context of Database Management System, write a short note on the following:
(i) Database
(ii) Table
(iii) Field
(iv) Composite Primary Key
Database Management System using LibreOffice Base 381

