MCQ-DM.

Multiple Choice Questions- Database Management Tool-OpenOffice.org BASE

  1. The figure 12% is a data which does not convey any meaning on its own. (True/False)

Ans. True

  1. A database is a collection of data that is organized so that its content can easily be accessed, managed, and updated. (True/False)

Ans. True.

  1. The _____ allows you to create various objects of the database, such as tables, queries, forms, and reports.

a. Database Object buttons

b.Title bar

c. Menu bar

d. Toolbar

Ans. a. Database Object buttons

 

  1. The default extension of OpenOffice Base is _____.

a. .odb

b. .obs

c. .oob

d. .obd

Ans. a.  .odb

Procedure of deleting a field from a table in BASE.

Q14. Explain the procedure of deleting a field from a table in Base.

Ans. In BASE, you can delete the fields that you do not require from a table, by using the Delete command. To delete a field, first you need to open the table in Table Design View.

In this question, we are using the Stud_Database database that contains Student and Faculty tables. Perform the following steps to delete a field from the Student table in BASE:

  1. Open the Student table in the Table Design view (Figure 19).
  2. Select the field that you want to delete. In our case, we have selected the field named Stud_Marks in Science (Figure 19).
  3. Right-click the grey button beside the field name. A context menu appears (Figure 19).
  4. Select the Delete option from the context menu, as shown in Figure 19:

 

The selected field is deleted from the table

 

How can you insert multiple fields in a table.

Q17. How can you insert multiple fields in a table?

Ans. In this question, we are using the Stud_Database database that has two tables named Faculty and Student. Let’s assume that you want to add additional fields in the Student table. For this, you first need to open the Student table in the Table Design view. After this, perform the following steps to add fields in the Student table:

  1. Right-click the Student table to add fields in it. A context menu appears .
  2. Select the Edit option from the context menu,

The Table Design window appears.

  1. Type the desired field name in the Field Name column to add the field in the Student table. In our case, we have typed Stud_Marks in Science.
  2. Press the ENTER key to move to the Field Type column to define the field type.
  3. Select the Number [NUMERIC] field type for the Stud_Marks in the Maths field from the Field Type column.
  4. Click the Save button to save data in the table.

 

The required fields are now added in the Student table. To view the modifications, open the table in Table Data View by double-clicking the name of the table in the BASE window. The table appears in Table Data View with the required changes.

How can you set the primary key for a table in Base.

Q11. How can you set the primary key for a table in Base?

Ans. In this question, we are using the Stud_Database database that contains Student an Faculty tables. Perform the following steps to set the primary key in the Student table:

  1. Right-click the field of the table in which you want to set a primary key. In our case, we have right-clicked the Stud_RollNo field. A context menu appears.
  2. Select the Primary Key check box from the context menu.

 

The primary key is set for the selected field in the table.

 

Steps for creating a database in BASE.

Q3. Write down all the steps for creating a database in BASE.

Ans. You can perform the following steps to create a database in BASE:

  1. Select the Create a new database radio button from Database Wizard.
  2. Click the Next button to move to the next step

The Decide how to proceed after saving the database page appears.
Read More …

How can you select multiple fields randomly from a table in Base?

Q20. How can you select multiple fields randomly from a table in Base?

Ans. In BASE, you can randomly select multiple fields in a table by pressing the CTRL key from the keyboard and then click the row selector button to select the field that you want. In this way, you can randomly select multiple fields in a table.

Special data types available in Base.

Q19. What are the special data types available in Base?

Ans. Special data types allow you to store special type of information, such as Yes/No data. The special data type is categorized in the following types:

  • Yes/No [Boolean]: Refers to a Boolean data type, which helps you handle input that is either a Yes or No value.
  • Image [LONGVARBINARY]: Allows you to add an image as a record in the field.
  • Binary [VARBINARY]: Allows you to handle binary values. A binary value is one that is represented in the 0 and 1 format.
  • Binary (fix) [BINARY]: Works in the same way as the Binary [VARBINARY] data type, except that it handles data of fixed length.
  • Other [OTHER]: Allows you to handle any kind of data. This data type is used when you are unable to define the data type using the other types, such as Boolean, Image [LONGVARBINARY], Binary [VARBINARY], and Binary (fix) [BINARY].

Importance of the primary key in a table.

Q18. Explain the importance of the primary key in a table with the help of a suitable example.

Ans. In a database, a primary key is very useful for uniquely identifying the data in a field. A table must contain at least one primary key, and each field with the primary key must contain a value. Read More …

difference between the fixed and variable field lengths

Q16. What is the difference between the fixed and variable field lengths?

Ans. In a fixed length field, the number of characters you can enter in the field remains fixed. On the other hand, in variable length field, the length of the field changes according to the data entered.

Fixed Length Field: It is a type of field length in which the number of characters you can enter is fixed. For example, if we specify the field length as 8, it means that the field can store a maximum of eight characters or 8 bytes of data. Read More …