SESSION 3: PERFORM OPERATIONS ON TABLE

 

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 :

  1. Open the Open Office Base
  2. Right click on the table which we need to open.
  3. Select option Edit from popup menu.
  4. 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 :

  1. Auto Value
  2. Length

 

Q6. Name two properties of Character type data.

Ans. Two properties of Character type data are :

  1. Entry Required
  2. Length

 

Q7. What is the default length of Integer data type?

Ans. The default length of Integer data type is 10.

 

Q8. What is the default length of Varchar data type?

Ans. The default length of Varchar data type is 50.

 

Q9. Define the following field properties in reference to Open Office Base.

1. Default Value

2. Format

3. Auto Value

Ans.

1. Default Value : A value which automatically appears when we enter the new record.

2. Format : This property helps to set the format of the data entered in the field.

3. Auto Value : This is the property of Numeric Field type. If this property is set to Yes then numeric field will get auto numeric value.

 

Q10. What do you mean by Sorting?

Ans. Sorting means to arrange the data in either ascending or descending order.

 

Q11. What is Referential Integrity?

Ans. Referential Integrity is used to maintain the accuracy and consistency of data in relationship.

 

 

Q12. What do you mean by relationship between tables?

Ans. A relationship refers to an association or connection between two or more tables.

 

Q13. How many types of relationship can be created between tables? Name them.

Ans. Three types of relationship can be created between tables.

  1. One to One
  2. One to Many or Many to One
  3. Many to Many

 

Q14. Relationship option is available in _____________ menu.

Ans. Tool

 

Q15. Write two advantages of relationship created between two tables.

Ans. Two advantages of relationship created between two tables are :

  1. It reduces data entry errors.
  2. It help to summarize data from related tables

 

Comments

Post a Comment

Popular posts from this blog

SESSION 2 : CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS

  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 ...
Read more

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD

  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 ...
Read more