cbse class 10 IT 402 UNIT 3: DATABASE MANAGEMENT SYSTEM
UNIT 3: DATABASE MANAGEMENT SYSTEM Q.1 What Do you mean by datasheet view? Ans - It provides a visual way to create a table. It is a simple view which arranges the data in rows and columns and allows to edit the data, but not allows to change the format of the database, Q.2 What Do you mean by design view? Ans - Design View It allows you to create or change the table. You can set or change every available properties for each field and can open existing tables in Design View, add, remove or change fields Q.3 Write steps to open table in design view. Ans - 1. Click Table Design on the Ribbon 2. A blank table will appear in Design View. 3. Enter a name for each field down the left column. 4. To set a field as a primary key, right click on the field and select Primary Key. Q. 4 What is the default length of varchar data type? Ans - 50 Q.5 What is a database? Ans - A database is information that is set up for easy access, management and updating. Computer databases ty