Class 10 Info Tech Unit 3 RDBMS Session 2 - Create and Edit Tables Using Wizard & SQL Commands 50+ Question Answer - Page 3 of 3 - MyCSTutorial- The path to Success in Exam

31. Define the structure of a table.

Answer: In OpenOffice.org Base, A table is a set of data elements (values) that is organized using a model of vertical columns(which are identified by their name) and horizontal rows.

Structure of table in OpenOffice.org Base (For example: Table Dept)

FieldName	FieldType
Empcode	TINYINT
Department	Text (25)
DOJ	Date
Salary	Number(12,2)

32. Differentiate between Tuples and Attributes of a table.

Answer: Tuples are the collection of interrelated data (attributes). Attributes are a set of data values of a particular simple type.

33. In how many ways you can save a table in OpenOffice Base?

Answer: To save changes in the table you can choose any one of the following -:

(a) Click File->Save,

(b) Press Ctrl + S ,

34. In which view, modification of the table can be done?

Answer: Design View.

A table once created, whether through wizard or through design view, can be edited only in Design View.

35. What do you mean by editing a table?

Answer: Editing a table means

(a) Adding fields,

(b) Moving fields,

(d) Changing field properties.

36. How can you modify the table. Write steps?

Answer: To modify the table:-

(a) In the Database window, click the Tables tab.

(b) Select the table, and right-click on it.

It will open the table structure, now you can make desired change in the table.

37. Write steps to add a column to a table?

Answer: To add a column to the table, follow these steps:-

(a) Right Click on TableName, select Edit option

(b) In the Table window, click a blank row in the Field Name column

(d) Save the changes to the table design by clicking Save Icon or Press Ctrl + S

38. Write steps for moving a field in a table?

Answer: To move a field or column, follow these steps:-

(a) Right Click on TableName, and Select the Edit option.

(b) In a Table window, select a field and click on the cut button

39. Write steps to delete a column or field from a table?

Answer: To delete a column or field in the table, follow these steps:-

(a) Open table for editing in the design window.

(b) Select the filed row, by clicking on row selector.

40. Differentiate between INTEGER data types and Real Number data types?

Answer: Integer Data Types vs Real Number Data Types

INTEGER Data Types	REAL Number Data Types
a. Stores Integer value only i.e. non-fractional value. E.g. 256 b. There are four types of Integer data types: – TINYINT – 3 spaces SMALLINT – 5 spaces INTEGER – 10 spaces BIGINT – 19 spaces	a. Stores fractional value i.e. real numbers. E.g. 256.69 b. There are five types of Real Number data types: – NUMERIC or DECIMAL – any number of values can be stored. REAL – 15 digits after decimal point FLOAT – 15 digits after decimal point DOUBLE – 15 digits after decimal point

41. When should you prefer a NUMERIC field type over INT?

Answer: NUMERIC field type can be used to store all types of numbers like whole numbers, numbers with decimals, fractional numbers, etc., while INT field type should be used when purely whole numbers are to be stored in the field.

42. How is the field type DATE/TIME (TIMESTAMP) different from the Date[DATE] and Time[TIME] field type?

Answer: The Date [DATE] field type stores the dates only and the Time[TIME] field type stores the times only. But the field type Date/Time [TIMESTAMP] is a combination of both Date and Time types and hence can store a combination of date and time, also known as a timestamp.

43. What is the significance of Null values?

Answer: Null values are very useful while entering data in a field when the table demands data for the field but the user does not have any value to enter. Since Null values are legal empty values in BASE.

SQL ( Structured Query Language) in OpenOffice.org Base