Class-X-Solved Exercise:
Unit-11 Database Development(Basic)
Session-5 Creating a Table
Session-6 Building Forms
Session-7 Create and Manage Queries
Session-8 Design Reports
I. Objective Type Questions.
1. Fill in the blanks.
a. A ________ enables users to view, enter, and change data directly in database objects such as tables.
Answer: Forms
b. To create a form you need to select ____ option available under Database section.
Answer: Database
c. A _______ is a request for some portion of the database information.
Answer: Query
d. Some portion of database information printed in formatted form is called as _______.
Answer: Report
e. ______ statement retrieves zero or more rows from one or more database tables or database views.
Answer: Select
f. ______ statement is used to add one or more records to a database.
Answer: Insert
g. _______ statement is used for modifying records in a database.
Answer: Alter
h. _____ statement is used to remove one or more records in a database.
Answer: Delete
2. Write 'T' for true and 'F' for false against the statement.
a. You can create tables in OO Base using the create table wizard.
Answer: T
b. The primary key is the required field while creating a query.
Answer: F
c. You cannot create tables in the Design view.
Answer: F
d. In SQL the INSERT statement is used to add one or more records to a database.
Answer: T
e. You can create static or dynamic reports.
Answer: T
f. You cannot delete or modify a record in SQL.
Answer: F
g. Forms are used to view and edit information in a table record by record.
Answer: T
h. Open Office Base does not provide you wizard feature to create forms.
Answer: F
II. Multiple choice questions. Tick the correct answer.
1. New record is added using
a. Select query b. Create table query c. update query d. Insert query
Answer: Insert Query
2. ________ presents data in a way similar to an excel spreadsheet.
a. Datasheet view b. design view c. print preview d. layout preview
Answer: Print preview
3. Which option under database will you select to create a report?
a. use wizard to create form b. use wizard to create table c. use wizard to create report d. use wizard to create query
Answer: Use wizard to create report
4. Which of these helps you to retrieve information from one or more database tables based on particular condition or criteria?
a. form b. query c. report d. record
Answer: Query
5. A_______ uniquely identifies an item or record in a table.
a. data type b. table c. primary key d. form
Answer: Primary key
III. Short Answer Questions.
1. Define the following terms:
a. Primary key b. Query c. Form d. Report
Answer:
Primary key: A primary key uniquely identifies an item (or record) in the table.
Query: Query are commands that are used to define the data structure and also to manipulate the data in the database.
Form: Forms are custom screens that provide an easy way to enter and view data in a table or query.
Report: Reports provide information found in the database in a useful way.
2. What is the use of INSERT statement in SQL? Write its syntax.
Answer: Insert statement is used to add one or more records to a database. The general syntax of insert statement is shown below.
INSERT INTO<table_name><column1, column2, column3.....>values <value1, value2, value3....>;
3. Write the steps to create a table in Design view in open office base.
Answer:
1. Click create table in design view.
2. Define the field names, data types and field properties for the table.
3. Similarly, define all other fields (date, fuelcost, fuel quantity, odometer, and payment type) with their field type and properties.
4. To access additional formatting options, click the button to the right of the format example field.
5. To save and close the table, choose File--->save. Name the table fuel. Close fuel table.
4. Write the steps to create a form in open office base.
Answer:
1. Start open office.
2. Select open an existing database file option and click on finish button.
3. Select the database name from the drop down list box and click the open button.
4. Select the forms tab and then click on use wizard to create form.
5. a. click the field selection step.
b. further , select the table name.
c. click the double right arrow icon to move all available fields to the fields in the form list.
6. Select the step arrange controls and then select an arrangement of the main form.
7. Select the step set data entry and choose the option to use the form to enter data and leave the option to display data.
8. Apply a style and field border, then click next.
9. Name the form, select the work with the form option, then click finish.
5. How will you add records to the table through a form?
Answer:
To add records to the table using the form that you have created for the table. Follow these steps:
1. Click on the new record symbol located at the bottom on the form navigation bar.
2. Enter the required details in each field by typing in the required data.
3. Click next record button to add more records to the table as desired. All the data that you enter using the form will get stored in the table. You can view the added records by opening the table from the main database window.
Some other links:
No comments:
Post a Comment