Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    PB4_IT402_DECEMBER_2024_25_SET-A_

    Uploaded by

    bishtarjun32

    Copyright:

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

    PB4_IT402_DECEMBER_2024_25_SET-A_

    Uploaded by

    bishtarjun32
    27 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
    27 views4 pages

    PB4_IT402_DECEMBER_2024_25_SET-A_

    Uploaded by

    bishtarjun32

    Copyright:

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

    Dynasty Modern Gurukul Academy

    Preboard IV Examination (2024-25)


    INFORMATION TECHNOLOGY(402)
    Class-10th (SET-A)
    Time: 2 Hours Max. Marks: 50

    General Instructions :-
    1. This Question Paper consists of two Sections viz. Section A: Objective type questions and Section B: Subjective type
    questions.
    i. This question paper contains (5+10)15 questions.
    ii. Marks allotted are mentioned against each question/part.

    2. SECTION A- OBJECTIVE TYPE QUESTIONS (24 MARKS):


    i. Multiple choice question/Fill in the blanks, 24 questions of 1 mark each.
    ii. This section has 05 questions
    questions.

    3. SECTION B– SUBJECTIVE TYPE QUESTIONS (26 MARKS):

    i. This section has 10 questions.


    ii. Question numberss 6 to 12 are Short Answer questions of 2 marks each.
    iii. Question numbers 13 to 15 are Long Answer questions of 4 marks each.

    4. All questions of a particular part/section must be attempted in the correct order.

    SECTION A- OBJECTIVE TYPE QUESTIONS (24 Marks)

    Q1) Answer the following questions. (1x 4 = 4 marks)

    i) Rajesh launches a new app, but it fails to attract users and he faces financial losses. He gathers his
    team to discuss the failure, takes accountability for the oversight, and assures them that he will conduct
    through market research
    arch before the next launch. He
    He___________.
    a) takes responsibility for his mistakes b) thinks before making a decision
    c) does not give up d) is innovative

    ii) Which of the following statements about self


    self- motivation is/are incorrect?
    a) It is a confidence booster.
    b) It enhancess one’s enthusiasm and provides energy to work.
    c) It also reflects the ability to cheer yourself after disappointments.
    d) It also cultivates a desire to do something in life
    iii) Which of the following best describes selfself-management?
    a) The ability to ignore emotions and focus solely on tasks
    b) The ability to control one’s emotions, thoughts, and behavior in various situations
    c) The ability to manage
    nage time efficiently without considering feelings
    d) The ability to rely on others for emotional support

    iv) Rihana has two people who work for her. Every day, she spends one hour with them to learn about what
    they’ve done that day. She_______________.
    _______________.
    a) Creates a new product b) divides income
    c) Manages the business d) takes risk
    Q2) Answer the following questions. (1x 5 = 5 marks)

    i) Which feature in Writer allows you to apply the same style to multiple words scattered throughout the
    document?
    a) Format Painter b) Fill Format option
    c) Style Inspector d) Font Adjustment Tool
    ii) Radha is planning a school event and wants to decide how much money to allocate for different
    Activities, like games, food, and decorations. She creates several different budget plans to see how
    changing the amount for each category affects the total expenses.
    How can Radha efficiently compare the different budget plans for her school event in the same
    spreadsheet?
    a) By writing down each budget on paper
    b) By using the What-if scenario feature in the spreadsheet to create and analyze different budget options
    c) By asking her friends to guess the costs
    d) By using the Filter function to look at one category at a time

    iii) What is the benefit of inserting an image as a link in a document?


    a) It reduces the document size by storing only the reference to the image.
    b) It enhances the image quality.
    c) It allows for automatic image editing within the document.
    d) It removes the need for image captions.

    iv) How many levels of headings does LibreOffice Writer support?


    a) 5 b) 8 c) 10 d) 12

    v) It allows the placement of image in relation to text, is called _________________.


    a) Water mark b) Trade mark c) Copyright d) Text Wrapping

    Q3) Answer the following questions. (1x5= 5 marks)

    i) Database servers are referred to as________________.


    a) Front-ends b) Back-ends c) Both a) and b) d) None of these

    ii) When you define a field for a table, _____________ are the names given to column in a table.
    a) Field name b) Field Size c) Data Types d) Description

    iii) What is the primary function of the Subtotal tool in Calc?


    a) It creates a chart for the data.
    b) It automatically groups data and applies common functions like sum and average.
    c) It highlights cells with conditional formatting.
    d) It removes duplicate data from the spreadsheet.

    iv) _________ is a numeric data type which can store Yes/No type values in the form of 0 or 1 in Libreoffice
    Base.
    a) Boolean b) Binary c) CHAR d) None of these

    v) Which of the following data models sets a relation between the two or more tables?
    a) Connection Data Model b) Network Data Model
    c) Hierarchical Data Model d) Relational Data Model
    Q4) Answer the following questions. (1x5= 5 marks)

    i) What feature in OpenOffice Base allows users to present retrieved data in a user-friendly and formatted
    manner?
    a) Query b) Form c) Report d) Data view

    ii) Which of the following statements are true about primary key in a database?
    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.

    iii) ______________ passed to a macro from Calc.


    a) Query b) Argument c) Cell d) Data

    iv) In Spreadsheet,
    Statement I: To consolidate by row labels or column labels, the label must be contained in the selected
    sources ranges.
    Statement II: The text in the labels must be identical so that rows or columns can be accurately matched.
    Statement III: If the row or column label does not match any that exist in the target range, it will be
    appended as a new row or column.
    Consider above two statements, identify the correct one.
    a) Only Statements I and II are correct
    b) Only Statement II is correct
    c) Only Statements II and III are correct
    d) All the Statements are correct

    v) Which of the following best defines "Data"?


    a) Unprocessed raw facts such as names, marks, and addresses.
    b) Organized and processed data that provides meaningful insights.
    c) Audio, video, and graphics stored without any processing.
    d) A collection of unrelated raw facts.

    Q5) Answer the following questions. (1x5= 5 marks)

    i) What does referential integrity in a database ensure?


    a) All primary keys are unique across the database.
    b) All records in a table must have a value in every column.
    c) Every foreign key value must match a primary key in the referenced table or be null.
    d) Data can be freely deleted from any table without constraints.

    ii) What should you do with the problem of dry eyes?


    a) Forget to blink b) Rest eyes periodically and do simple eye exercises
    c) Do exercise d) Blink the eyes

    iii) Which of the following is a recommended way to manage stress at work?


    a) Engage in aggressive conflicts with colleagues
    b) Work longer hours without breaks
    c) Seek conflict resolution strategies with colleagues
    d) Avoid hobbies that promote relaxation
    iv) Which of the following can lead to musculoskeletal problems while working on a computer?
    a) Using anti glare screen
    b) Sitting in a wrong posture and using an uncomfortable chair
    c) Using Air Conditioners
    d) Taking frequent breaks

    v) What is one way to mitigate hazards associated with prolonged computer use?
    a) Increasing screen brightness
    b) Sitting in a fixed position
    c) Using a smaller screen
    d) Stretching at regular intervals or doing simple yoga

    SECTION B: SUBJECTIVE TYPE QUESTIONS (26 MARKS)

    Short Answer type Questions: (2x 7 = 14 marks)

    Q6) Distinguish between Candidate Key and Composite Primary Key.


    Q7) What do you understand by the term Table of Content? List the characteristics of good ‘Table of Content’
    in a word processor.
    Q8) What points should be included in Fire Prevention Plan in the office?
    Q9) Differentiate between Hierarchical Data Model and Relational Data Model.
    Q10) Discuss Self-awareness and its types.
    Q11) Explain how entrepreneurs and society are interconnected?
    Q12) Explain any four advantages of Database.

    Long Answer type Questions (4x3 =12 marks)


    Q13) A health clinic is developing a patient management system to streamline patient intake, appointments,
    and medical records. They need to implement forms for various purposes, including new patient
    registration, appointment scheduling, and updating medical histories.
    a) What is a DBMS? Write the full form of RDBMS.
    b) What is a Primary key? How is it different from foreign Key?
    c) What is a Form?
    d) What is a Query?
    Q14) Define Absolute and Relative hyperlink. And Explain four types of hyperlink that can be applied in spreadsheet.
    Q15) Define the following Points:
    a) Referential Integrity
    b) Scenario
    c) Goal seek
    d) Macro

    You might also like