• DATABASE MANAGEMENT TOOLS,  FOUNDATION OF IT,  MCQ-DM

    MCQ-DM.

    Multiple Choice Questions- Database Management Tool-OpenOffice.org BASE The figure 12% is a data which does not convey any meaning on its own. (True/False) Ans. True 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. 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   The default extension of OpenOffice Base is _____. a. .odb b. .obs c. .oob d. .obd Ans. a.  .odb

  • DATABASE MANAGEMENT TOOLS,  FOUNDATION OF IT,  LONG QUES-DM

    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: Open the Student table in the Table Design view (Figure 19). Select the field that you want to delete. In our case, we have selected the field named Stud_Marks in Science (Figure…

  • DATABASE MANAGEMENT TOOLS,  FOUNDATION OF IT,  LONG QUES-DM

    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: Right-click the Student table to add fields in it. A context menu appears . Select the Edit option from the context menu, The Table Design window appears. Type the desired field name in the Field Name column to add the field…

  • DATABASE MANAGEMENT TOOLS,  FOUNDATION OF IT,  LONG QUES-DM

    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: 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. Select the Primary Key check box from the context menu.   The primary key is set for the selected field in the table.  

  • DATABASE MANAGEMENT TOOLS,  FOUNDATION OF IT,  LONG QUES-DM

    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…

  • DATABASE MANAGEMENT TOOLS,  FOUNDATION OF IT,  LONG QUES-DM

    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.