DATABASE MANAGEMENT SYSTEM (Class-X IT)

DATABASE MANAGEMENT SYSTEM

Multiple-Choice Questions (MCQs)

1. In which of the following types of databases, a single table or file stores all the data?

a. Flat-file database

b. Relational database

c. Distributed database

d. All of these

Ans. a

2. DML stands for

a. Data Manipulation Language

b. Data Manipulative Language

c. Database Manipulation Language

d. Data Management Language

Ans. b

3. Which of the following refers to uniquely identifying a record in a table?

a. Field

b. Primary key

c. Record

d. Foreign key

Ans. b

4. Which of the following is not a data type available in OpenOffice Base?

a. Text

b. Memo

c. Number

d. String

Ans. d

5. Which of the following is a link between two or more tables?

a. Form

b. Relationship

c. Query

d. Report

Ans. b

Very Short Answer Questions

1. What is summarizing?

Ans. Summarizing refers to the procedure of retrieving the summary of the data based on some defined criteria.

2. What is a flat-file database?

Ans. A flat-file database refers to the type of database in which a single table or file stores all the data.

3. Define a distributed database.

Ans. A distributed database refers to a central database that is distributed at multiple locations within a network.

4. What is a relational database?

Ans. A relational database refers to a database in which data is stored in multiple tables. These tables are linked to one another through common fields.

5. What do you understand by data definition language?

Ans. Data Definition Language (DDL) comprises SQL commands that are used for defining a database schema.

Short Answer Questions-I

1. How does a DBMS reduce the inconsistency of data?

Ans. DBMS helps you to reduce the data inconsistency as the entire data is stored at one central location. DBMS ensures that when data is changed at one location, the corresponding data is also changed at other locations. This process is known as propagating updates.

2. How does a database ensure data security?

Ans. The data that is stored in a database may contain valuable or sensitive information. DBMS provides security to data by ensuring that only authorized users are able to access the database.

3. What do you understand by backup and recovery of a database?

Ans. DBMS provides backup and recovery facilities to protect data from hardware or software failures. The backup is the copy of data that can be used for future references for the recovery of the database.

4. What is RDBMS?

Ans.   A Relational Database Management System (RDBMS) is based on the relational model and uses tables for representing data elements as well as the relationships between them.

5. What do you understand by editing a record in a table?

Ans. Editing a record means changing or modifying it in a table. You can edit records in any objects such as forms and reports in the Datasheet or Design View. You need to select a record before performing any tasks in a table. For example, for changing a record or deleting a record, you need to select that particular record that you wish to change or delete.

Short Answer Questions-II

1. Write the steps for closing and quitting a database in OpenOffice Base.

Ans. The steps to close a database are as follows:

1. Click the File menu from the Menu bar. A drop-down menu appears.

2. Select the Close option from the drop-down menu.

        The database gets closed and the OpenOffice Base window appears.

        Closing the database is not enough to quit the OpenOffice Base application.

        The steps to quit the OpenOffice Base application are as follows:

1. Click the File menu from the Menu bar. A drop-down menu appears.

2. Select the Exit option from the drop-down menu. The OpenOffice Base application gets closed.

2. What are the advantages of using RDBMS?

Ans. Some of the advantages of RDBMS are listed as follows:

 Provides the ability to query all the related database tables to fetch the required results

 Provides the ability to view the content of the database according to different views as required by users

 Manages large amounts of data related to the organization more easily and efficiently

 Provides the ability to access, update and share data

 Ensures data security and integrity

 Ensures reduction in data redundancy

 Provides support for normalization

 Provides facilities for analyzing data and producing reports accordingly

 Provides compatibility with a number of third-party tools

3. What do you understand by criteria in a query field?

Ans. A criterion in query enables you to specify the records to be included in a table. You can specify the criteria for your query to extract the particular records from the database easily and quickly. There are two basic types of criteria, namely, numeric criteria and text criteria, which you can use to set for a table in a database. Using numeric criteria, you can set the desired numeric value in the Criteria row for your table, such as date, without using any quotation or special character. In the text criteria, you can type a specific text string as a criterion.

The text criteria may include a single or multiple words along with punctuation marks and spacing. It is important to enclose the text in the quotation marks.

4. Write the steps to set the primary key in a table.

Ans.  The steps to set the primary key in a table are as follows:

1. Right-click the name of the table in the OpenOffice Base window in which you want to set the primary key. A context menu appears.

2. Select the Edit option from the context menu. The Table Design window of the selected table appears.

3. Right-click the row head of the field that you want to make as the primary key.

A context menu appears.

4. Select the Primary Key option from the context menu. The selected field is set as the primary key.

5. Click the Save button to save the table.

5. How to sort data in a table in Base?

Ans. Sorting data means arranging the data of a table in ascending or descending order. For this, you need to select the column based on which you want to sort the data of the table and then select the Sort Ascending or Sort Descending button on the Table Data toolbar according to your requirement. Now, the OpenOffice Base sorts the whole column and the values in the other field of the rows corresponding to that column are also affected.

Long Answer Questions

1. What do you understand by the relationship between tables? Explain the types of relationship in Base.

Ans. A relationship is a link between two or more tables. You can connect two fields from two different tables with the help of a relationship. You can create relationships between tables to bring together related information. Relationships between tables are essential for creating a form, report, or query that uses information from more than one table in a database. The different types of relationships are as follows:

 One-to-One Relationship: Implies that a single record from the first table can be linked to only a single record in the second table and vice versa. One-to-one relationships occur when just one record in the first table is linked to exactly one record in the related table.

 One-to-Many Relationship: Implies that a single record from the first table can be linked to multiple records in the second table while a single record in the second table relates to only a single record in the first table.

 Many-to-Many Relationship: Implies that multiple records from the first table can be linked to multiple records in the second table and vice-versa.

You can create the relationship between tables by selecting the Tools W Relationship option from the Menu bar. Now add the tables in which you want to specify the relationship.

2. How can you create a form in the Design View?

Ans.  The steps to create a form in Design View are as follows:

1. Open a database file.

2. Click the Forms object button. The various options related to the selection are displayed in the Tasks pane.

3. Select the Create Form in Design View option from the Tasks pane.

        The Database Form window appears.

4. Click the Label Field button on the Form Controls toolbar.

5. Drag the mouse pointer by clicking the left mouse button to draw a label field on the form

6. Right-click the label field in the form. A context menu appears.

7. Select the Control option from the context menu.

The Properties dialog box appears displaying the General tab by default. This dialog box shows the properties of the label field.

8. Specify the different properties of the label field in the Properties dialog box.

9. Click the Close button in the Properties dialog box to close it.

10. Click the Text Box button on the Form Controls toolbar.

11. Drag the mouse pointer by clicking the left mouse button to draw a text box on the form.

12. Right-click the text box in the form. A context menu appears.

13. Select the Form option from the context menu.

The Form Properties dialog box appears displaying the General tab by default.

14. Click the Data tab.

15. Select the content type from the Content type drop-down list.

16. Select the desired table from the Content drop-down list.

17. Click the Close button in the Form Properties dialog box to close it.

18. Right-click the text box in the form. A context menu appears.

19. Select the Control option from the context menu.

        The Properties dialog box appears displaying the General tab by default. This dialog box shows the properties of the text box.

20. Click the Data tab.

21. Select the data field of the table from the Data field drop- down list that you want to link with the text box.

22. Click the Close button in the Properties dialog box to close it.

23. Repeat steps 4 to 22 to add more fields in the form.

24. Click the Save button in the Standard toolbar. The Save dialog box appears.

25. Type the name of the form in the File name text box.

26. Click the Save button to save the form. The form is saved with the specified name.

27. Click the Design Mode On/Off button in the Form Design toolbar to view the form in design mode.

        The form, showing data, is displayed in the design mode.

28. Click the Close button in the Database Form window to close it.

The newly created form is displayed in the Forms pane in the OpenOffice Base window.

3. What are reports? Write the steps of creating a report by using the Report Wizard tool.

Ans. A report is a predefined or user-defined format to display the specific data stored in a database. In OpenOffice Base, a report is used to format, summarize, and present data in an attractive and meaningful manner. In addition, reports help you to view records in a printable format. In addition, you can use reports to create a summary of specific data stored in a database. You can make your report more professional and appealing by adding different elements, such as themes and colours to it.

The steps to create a report by using Report Wizard are as follows:

1. Open a database file.

2. Click the Reports object button.

The various options related to the selection are displayed in the Tasks pane.

3. Select the Use Wizard to Create Report option from the Tasks pane.

The Which fields do you want to have in your report? Page appears on the Report Wizard.

4. Select the desired table from the Tables or queries drop-down list.

5. Select the desired field for the report from the Available fields list box.

6. Click the Add button. The added fields are displayed in the Fields in report list box.

Similarly, you can add more fields.

7. Click the Next button.

The How do you want to label the fields? page appears on the Report Wizard.

8. Type the labels for the fields in the Label text boxes.

9. Click the Next button.

The Do you want to add grouping levels? page appears on the Report Wizard.

10. Click the Next button.

The According to which fields do you want to sort the data?

page appears on the Report Wizard.

11. Select the desired fields in the Sort by drop-down list based on which you want to sort the data

12. Select the Ascending radio button in the Sort by section to arrange the data in ascending order.

13. Click the Next button.

The How do you want your report to look? page appears on the Report Wizard.

14. Select the layout for the data in the Layout of data list box.

15. Select the layout for the header and footer in the Layout of headers and footers list box.

16. Select the Landscape radio button in the Orientation section.

17. Click the Next button.

The Decide how you want to proceed page appears on the Report Wizard.

18. Type the name for the report in the Title of report text box.

19. Select the desired radio button under the What kind of report do you want to create? section.

20. Select the desired radio button under the How do you want to proceed after creating the report? section.

21. Click the Finish button.

The report is displayed in the OpenOffice Writer document.

22. Click the Close button in the OpenOffice Writer application window to close it.

The report is displayed in the Reports pane in the OpenOffice Base window.

4. What do you understand by a wildcard? Explain with some examples.

Ans. A wildcard is a symbol used to replace or represent one or more characters. A wildcard refers to a specific character that can be used to return/filter/generate results from a given query. It also refers to a character that takes the place of any other character or string that is not known or specified.

Some examples of wildcard characters used in queries are as follows:

 Asterisk (*): This represents a string of text from nothing up to an entire paragraph or more. For example, To* finds Toll, Tool, Tour, Took, and Tower but not Troll. * X finds characters ending with that specified character.

 Question Mark (?): This represents or matches a single character or letter only in a specified position of the character or letter. For example, t?ll finds tell, till, and tall.

 Square Brackets []: This represents characters within brackets,

for example, t[ae]ll finds tall and tell, but it cannot finds till and toll.

 Exclamation Mark (!): It is used to exclude the characters that are available inside the brackets. For example, “[!k]” finds all items that do not begin with the letter k such as board, apple, lion, etc., but not the keyboard or key or knowledge.

 Hash Tag (#): It is used to match any single numeric character, for example, 2#4 finds 204, 224, 254 and 284.

 Underscore (_): It is used to match a range of characters. You must specify the characters in the ascending order (A to Z, not Z to A) while using the underscore (_) wildcard. For example, m[a_d]d finds mad, mbd, mcd, and mdd.

5. Write the steps of creating a new table using Table Wizard.

Ans. The steps to create a table using the Table Wizard are as follows:

1. Open the database in which you want to create a table.

2. Click the Tables object button.

3. Select the Use Wizard to Create Table option under the Tasks pane.

The Select fields for your table page of Table Wizard appears.

4. Select the desired radio button under the Category section.

5. Select the desired sample table from the Sample tables drop- down list.

6. Select the desired field for the table from the Available fields list box.

7. Click the Add button.

The added fields are displayed in the Selected fields list box.

8. Repeat steps 6 and 7 to add more fields to the table.

9. Click the Next button.

The Set field types and formats page of Table Wizard appears.

10. Set the fields information according to your requirements under the Field information section.

11. Click the Next button.

The Set primary key page of Table Wizard appears.

12. Select the Create a primary key check box to create a primary key.

13. Select the desired radio button to specify the way you want to create the primary key.

14. Select the desired field name that you want to make a primary key from the Fieldname drop-down list.

15. Click the Next button.

The Create table page appears.

16. Type the desired name of the table in the What do you want to name your table? text box

17. Select the Insert data immediately radio button under the What do you want to do next? section to open the table after it has been created.

18. Click the Finish button

The Faculty_Details table opens in the Table Data View window to allow you to enter records.