Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Grade X Revision Test v IT Key Answers 2024 25

    Uploaded by

    venipunya830

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Grade X Revision Test v IT Key Answers 2024 25

    Uploaded by

    venipunya830
    8 views4 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    8 views4 pages

    Grade X Revision Test v IT Key Answers 2024 25

    Uploaded by

    venipunya830

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 4

    PES PUBLIC SCHOOL, SHIVAMOGGA

    REVISION TEST-V- 2024-25


    SUBJECT: INFORMATION TECHNOLOGY KEY ANSWERS
    Grade –X
    Total Marks: 40
    Duration: 2-Hours
    General Instructions:
    1. Please read & follow the instructions carefully.
    2. This Question Paper is i.e., Subject Specific Skills
    3. Answer as per the instructions. Apply correct question number. Total Questions: 26.
    4. Marks allotted are mentioned against each section/question.

    SECTION A:

    I. Fill in the blanks (1 x 5 = 5 marks)

    1 List styles are used to select, format, and position numbers or bullies to lists. 1

    2 Arrangement refers to the placement of a graphic on a imaginary vertical axis. 1

    3 The Table of Contents is a necessary index in a long document. 1

    4 Using a Template you can create your own document. 1

    5 To resize the image proportionally, you should press the Alignment key while dragging the 1
    mouse.

    II. Multiple Choice Questions. (1 x 10 = 10 marks)

    6 Which of the following data models sets a relation between the two or more tables? 1
    (a) Relational Data Model (b) Network Data Model (c) Hierarchical Data Model
    (d) Connection Data Mode
    7 Which of the following statements are true about primary key in a database? 1
    (a) It is a field that can have duplicate values. (b) It uniquely identifies each
    record in a table. (c) It can have null values (d) It is an optional field in a database
    table.
    8 The __________ is a computerized record keeping system. 1
    a) DBMS b) Database c) Metabase d) Metadata

    9 Which of the following is a RDBMS? 1


    a) Open-Office Base b) MySQL c) Oracle d) All of these
    10 It consists of one or more fields whose value matches a primary key in another table. 1
    a) Foreign Key b) Composite Primary Key c) Composite Key d) Candidate Key
    11 In this type of relationship, a record in a table can only one matching record in another table and 1
    vice versa.
    a) One-to-One b) One-to-Many c) Many-to Many d) Many-to Many
    12 It is an interactive way of entering data. 1
    a) Form b) Report c) Query d) Record
    13 It acts as a map for the user in a document. 1
    a) TOC b) Preface c) Prolog d) TAC
    14 The ___________ mode allows you to apply a style to many different areas quickly. 1
    a) File Format b) File Handling c) Fill Format d) Fill Handle
    15 _____________ means to delete the unwanted areas of a photograph or image in order to improve 1
    its appearance.
    a) Erasing b) Cropping c) Cutting d) Formatting

    SECTION B:

    III. Answer the following. (Answer any 5 only) (5 x 3 = 15 marks)

    16 List the different styles categories available in Writer. 3


    Writer has the following style categories:
    Paragraph Styles are used to change the appearance of a paragraph by making changes to the
    text alignment, tab stops, line spacing, and so on.
    Character Styles are used for a block of text inside a paragraph.
    Page Styles are used for page formatting.
    Frame Styles are used format graphic and text frames.
    List Styles are used to select, format, & position the numbers or bullets in lists.
    17 How can you customize the TOC? 3
    To customize the Table of Contents, right-click on it and select the option Edit Index/Table.
    The insert index/ Table dialog box appears, which has five tabs. Make the required changes
    and click on Ok.
    18 Write four characteristics of good table of contents. 3
    It should be easy to read and simple to use.
    It should be organized and formatted properly.
    It must be accurate and easily accessible.
    It should be given after the title and copyright page.
    19 What steps will you follow to crop an image in a Writer document? 3
    1. Select the picture for operation.

    2. Click Picture Tool from the toolbar → Crop

    3. Adjust the cropping range of the picture.

    4. Press Enter to complete the operations.

    20 Write at least four features of a database. 3


    The features of a database are:
    A database can have one or more tables.
    Each table in a database contains data about a particular type of subject. As a result, a
    database Provides a container for tables and other objects, as well as a management system for
    how they might be used. For every table, record uniqueness is an important feature. It helps to
    avoid record duplication caused by user or computer errors. One or more fields should be
    designated as keys in every database table.

    PES Public School – REVISION TEST-V – 2024-25. Grade-X - Information Technology


    21 Describe the use of forms. How do you create a form? 3
    Forms are used to enter and modify the data in tables. Using form, you also search for records.
    A form can have a different name from a table, yet a form manipulates the same information
    and data to the corresponding table. If we change a record in a form, it will be reflected in the
    table also. In OpenOffice Base, a form can be created using the Form Wizard and Design
    Mode.
    22 In a database, why is it important to create relationships between the tables? 3
    A relationship between tables is an important aspect of a good relational database. 1) It
    establishes a connection between a pair of tables that are logically related to each other. 2) It
    helps to refine table structures and minimize redundant data.

    23 Distinguish between one-to-one and one-to-many relationships. 3


    In one-to-one relationship, a record in a table has only one matching record in another table,
    and vice versa.
    In one-to-many relationship, a record of Table A is associated with several matching records
    of Table B, but a record of Table B is associated with only one record of Table A.

    IV. Application Based Question: (Any 2 only) (5 x 2= 10 marks)


    24 What is a report? When you work a report, you see different sections in it. Describe some of 5
    those sections in detail.
    A report is a effective way to organize and summarise data for viewing and printing. It consists
    of information obtained from table for queries, and presented as per the user’s requirements.
    In OpenOffice Base, a report is made up of the following sections: Page Header: It contains
    the information that is to be displayed at the top of the report on every page.
    Header: It contains the heading of the report.
    Detail: This is where you place the consists that make up the main body of the report.
    It displays the records and appears between the page header and page footer.
    Page Footer: This section is printed at the end of every page. It is used to print the page
    number or total number of pages.
    25 Sudeep runs a small bookstore and wants to maintain an inventory of books. He needs to 5
    record information such as book titles, authors, ISBNs, publication dates, prices, and
    stock levels. However, he is not familiar with database management systems. Explain the
    following concepts to help him understand DBMS:
    a) What is DBMS?
    b) What are the advantages of using DBMS?
    c) Name any two database programs that can be used to create a table and store the data
    according to his requirements.
    d) Which field can be set as a Primary Key

    PES Public School – REVISION TEST-V – 2024-25. Grade-X - Information Technology


    26 Hoovitha wants to set a template as custom template in Writer. What steps should she follow to 5
    perform this task?

    1. Use File > New > Templates. In the Templates dialog, double-click the template you
    want to use. A new document opens, containing any text or graphics that were in the
    template.
    2. Delete any unwanted text or graphics from this new document.
    3. Open the document you want to change. (It opens in a new window.)
    4. Use Edit > Select All, or press Ctrl+A, to select everything in the document.
    5. Click in the blank document created in step 1. Use Edit > Paste, or press Ctrl+V, to
    paste the contents from the old document into the new one.
    6. Update the table of contents, if there is one. Close the old file without saving. Use File
    > Save As to save this new file with the name of the file from which content was taken.
    When asked, confirm you wish to overwrite the old file. Or, you may prefer to save the
    new file under a new name and preserve the old file under its original name.

    PES Public School – REVISION TEST-V – 2024-25. Grade-X - Information Technology

    You might also like