Scribd Logo
Upload

Welcome to Scribd!

  • 54 views

    10th pt3

    Uploaded by

    ON InFo EdU

    Copyright:

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

    10th pt3

    Uploaded by

    ON InFo EdU
    54 views2 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    54 views2 pages

    10th pt3

    Uploaded by

    ON InFo EdU

    Copyright:

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

    NEW OXFORD SCHOOL - CBSE

    Doddathimmasandra, Sarjapura(P), Anekal(T) - 562 125


    Affiliated to CBSE New Delhi, Affiliation No. 830703
    PERIODIC TEST - 3 November- 2024-25
    GRADE: X SUB: Information Technology
    Marks: 30

    I Answer the given 5 questions (1 x 5=5 Marks)


    i. What does referential integrity in a database ensure? 1
    (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 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.
    iii Data in RDBMS is organized in _________. 1
    (a) files (b) tables (c) text related only (d) linked through network
    iv Which of the following dialog boxes appears when the Query Design window is 1
    opened for the first time to design a query?
    (a) Add Table (b) Add Query (c) Add Query or Report (d) Add Table or Query
    v What feature in OpenOffice Base allows users to present retrieved data in a 1
    user-friendly and formatted manner?
    (a) Query (b) Form (c) Report (d) Data view
    II Answer the given 5 questions (1 x 5= 5 Marks)
    i. Identify the property which help to set the number of characters in text/ varchar type 1
    field of a table in DBMS.
    a. Entry Required b. Size c. Default Value d. Length
    ii. The length of the field value of text data type is _____ characters by default in DBMS. 1
    a. 10 b. 25 c. 20 d. 50
    iii. Identify the mode, where we can modify in the structure of table? 1
    a. Datasheet view b. Structure view c. Design view d. All of the above
    iv. …………….. Clause can be used with the SELECT statement in SQL to 1
    specify which rows to retrieve from the table.
    (a) WHERE (b) GROUP (c) SAME (d) SIMILAR
    v. __________ store data in a single table which is suitable to store less amount of Data. 1
    a. Flat File b. Relational c. Mini File d. Single File

    III Answer the given 5 questions (1 x 5= 5 Marks)


    i. SQL stands for _____________. 2
    a. Structured Queue Language b. Structured Query Language
    c. Structured Query Lang d. None of the above
    ii ___________ represent a single data item in a table. 2
    a. Tuples b. Attributes c. Relation d. All of the above
    iii. Which data type will be appropriate to store information as Salary, Fees, Price etc 1
    a. Alphanumeric Data types b. Numeric Data type c. Binary Data types d. Date Time

    Page 1of
    iv Parth is a student of class X. He is working in Open Office Base. He created a table 1
    but forgot to create the primary key. Does Open Office Base automatically create the
    primary key. If yes then what would be the default name of primary key?
    a. No, open office will not create primary key automatically.
    b. Yes, ID is the default name
    c. Yes, IDs is the default name
    d. Yes, PK is the default name
    v Which command is used to define the structure of your tables? 1
    (a) DDL (b) DCL (c) DML (d) TCL

    IV Answer any 3 out of the given 4 questions (3 x 2= 6 Marks)


    i. List Numeric and Alphanumeric Datatypes in OpenOffice Base. 2
    ii. Differentiate between DDL and DML Commands. 2
    iii. Write four advantages of database 2
    iv. Differentiate between Forms and Report. 2

    V Answer any 3 out of the given 4 questions (3 x 3= 9 Marks)


    i. Define: 3
    a)Data integrity b) Entry Required c) data inconsistency
    ii. 3

    iii. Consider the following table: Sales 3


    1. How many fields and records are there in Sales table?
    2. Write SQL commands for the following:
    i. Display Sales ID and price of all products whose discount is more than 1000.
    ii. Display the details alphabetically by product name.
    iii. Display product name and sales price after deducting the discount from the price.
    Note: Sales price can be calculated as (price-discount)
    iv. Your cousin runs a small bookstore and wants to maintain an inventory of books. He needs to 3
    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?

    Page 2of

    You might also like