Page 326 - Trackpad 402_Class-X_Final
P. 326
13. Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
[CBSE Sample Paper 2021]
a. Table b. Form
c. Relationships d. Sorting
14. Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this
purpose. [CBSE Sample Paper 2021]
a. Length b. Default
c. Entry required d. Format
Ans. 1. c 2. d 3. b 4. b 5. c 6. b 7. d 8. d 9. a 10. c 11. c 12. b 13. c 14. b
B. Fill in the blanks.
1. The collection of related arranged in the form of rows and columns will form structured data.
2. is the smallest unit of a database and is formed by the intersection of a row and a column.
3. By default, data is arranged in order using ORDER BY clause. [CBSE Handbook]
4. is an attribute or a set of attributes whose values match the primary key of another table.
5. statement is used for modifying records in a database. [CBSE Handbook]
6. clause is used with select to arrange the records in ascending or descending order.
7. is the extension of a database in openoffice base.
8. stores data in a plain text format.
9. Data means that the data is accurate and consistent in the database.
10. A row that forms complete information is known as a .
11. gives you a window where you enter the names, data types and the description of the fields you wish to
create in a table.
12. The data type stores integer range between 0 to 255.
13. statement is used to remove one or more records in a Database. [CBSE Handbook]
Ans: 1. data 2. Data Value 3. ascending 4. Foreign Key 5. UPDATE 6. Order by 7. .odb
8. Flat file 9. integrity 10. Tuple 11. Design View 12. TINYINT 13. DELETE
C. Match the following:
1. Flat File a. Row
2. Record b. DML
3. Attribute c. DDL
4. Alter table d. Column
5. Select e. Spreadsheet
Ans. 1. e 2. a 3. d 4. c 5. b
D. State whether these statements are true or false:
1. In the database, all the data is stored at a centralized location.
2. Table is also known as tuple.
3. Field contains a set of characters.
4. CREATE TABLE is a DDL command.
5. % with like in SQL replaces only one character.
6. Relational File stores data of different data types like text, number, date in the form of rows and
columns to form a table.
7. MySql is not an example of relational database management system.
8. Sharing of data means data can be accessed by multiple users at the same time.
326 Trackpad Information Technology-X

