Page 374 - TP_IT_V1.0_C10_flipbpookl
P. 374
12. are a great way to provide additional information about the Form controls.
a. Tooltips b. Label
c. Format d. Text
13. It enables users to view, enter, and change data directly in database objects. [CBSE Sample Paper 2023]
a. Report b. Query
c. Form d. Database
14. Suraj wants to create a database for his clients. For this purpose, he needs to store the Email IDs of his clients. Which data
type should he use to accomplish this purpose? [CBSE Sample Paper 2023]
a. Numeric b. Varchar
c. Binary d. Boolean
15. is used with WHERE clause to search for a specific pattern in a column.
a. ORDER BY clause b. LIKE operator
c. INSERT command d. GROUP BY clause
16. are used to retrieve a particular record from a table that contains a specified character.
a. Relationship b. Tuple
c. LIKE operator d. Wildcard characters
Ans. 1. d 2. d 3. a 4. c 5. d 6. a 7. c 8. c 9. b 10. c 11. c 12. a 13. c 14. b
15. b 16. d
B. Fill in the blanks.
1. The collection of related arranged in the form of rows and columns will form structured data.
2. is an attribute or a set of attributes whose values match the primary key of another table.
3. is the extension of a database in LibreOffice base.
4. file stores data in a plain text format.
5. Data means that the data is accurate and consistent in the database.
6. A row in a relation is called .
7. gives you a window where you enter the names, data types and the description of the fields you wish to
create in a table.
8. The data type stores integer range between 0 to 255.
9. The toolbar contains various controls that can be added to the form.
10. A is a step-by-step process of doing a specific task through a set of dialog boxes.
11. A is a piece of text that represents the field on the form.
12. characters are used to retrieve a particular record from a table that contains a specified character.
13. Each table can have only primary key in a database.
14. A Relational database uses commands which is a standard user application that provides an easy
programming interface for database interaction.
15. A view helps you design a query by specifying the tables and the criteria.
16. is the standard language for managing relational databases and performing various operations on the
data in the tables.
Ans. 1. data 2. Foreign Key 3. .odb 4. Flat 5. Integrity
6. Tuple 7. Design View 8. TINYINT 9. Forms Control 10. Wizard
11. label 12. Wildcard 13. One 14. SQL 15. Design
16. Structured Query Language
372 Trackpad Information Technology (Ver. 1.0)-X

