CLASS: 10 UNIT - 3 DATABASE MANAGEMENT SYSTEM

  Unit – 3 DBMS SESSION 5: CREATE FORMS AND REPORTS USING WIZARD   Q1. What is Form in OpenOffice Base? Ans. A form provides the user a systematic way of storing information into the database.   Q2. Name the interface which lets users to view, enter, and change data directly in database. Ans. Form   Q3. Write two ways of creating form in Open Office Base. Ans. Two ways of creating form in Open Office Base are : a. Create form in design view b. Use Wizard to create form   Q4. Can we enter the data in table using forms? Ans. Yes Q5. What do you mean by Report in Open Office Base? Ans. A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format.   Q6. Differentiate between Forms and Report. Ans. Form 1. It is a way of storing data into a database 2. Values entered in the form can be modified Report ...

  Unit – 3 DBMS SESSION 4: RETRIEVE DATA USING QUERY   Q1. What do you mean by query in Open Office Base? Ans. A query is a request to collect specific information from a table or combination of tables.   Q2. In how many ways you can create query in Open Office Base? Ans. We can create query in Open Office Base by three ways which are : Create query in Design view Create query using Wizard Create query in SQL view   Q3. Name the Query language which is used in Base? Ans. SQL   Q4. Which command is used to retrieve data from the table? Ans. Select command is used to retrieve data from the table. SQL Commands Class 10 IT Code 402 Q5. Name two categories of SQL Commands. Ans. Two categories of SQL Commands are : DDL DML   Q6. Differentiate between DDL and DML Commands. Ans. DDL It stands for Data Definition Language Example : Create, Alter, Drop DML ...

  Unit – 3 DBMS SESSION 3: PERFORM OPERATIONS ON TABLE   Q1. What do you mean by Datasheet View? Ans. A view in which new data can be inserted and inserted data can be modified or removed in a table is called datasheet view   Q2. What do you mean by design view? Ans. A view in which we can change the structure of the table is called design view.   Q3. Write steps to open table in design view. Ans. Steps to open table in design view are : Open the Open Office Base Right click on the table which we need to open. Select option Edit from popup menu. Required table will open in design view   Q4. What do you mean by Field Property in Base? Ans. Those properties which determine the characteristics and behavior of fields are called field property.   Q5. Name two properties of Numeric type data. Ans. Two properties of Numeric type data are : Auto Value Length   Q6. Name two properties of Character type ...

  Unit – 3 DBMS SESSION 2 : CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS   Q1. What do you mean by RDBMS? Ans. RDBMS stands for Relational Database Management System. It is a database management system which is based on relational model.   Q2. Define the following terms : 1 Table 2. Fields 3. Records Ans. Table : A table is a set of data elements that is organized in vertical columns and horizontal rows. Fields : A field is a set of data values of a particular simple type, one for each row of the table. Records : A row also called a Record or Tuple represents a single, data item in a table.   Q3. What are the two ways of creating table in OpenOffice Base. Ans. Two ways of creating table in OpenOffice Base are : a. Create table in design view b. Use Wizard to create table.   Q4. What do you mean by Data type? Give example of two data type used in OpenOffice Base. Ans. Datatypes are used to identify ...