Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Class X It QP CH-8,9

    Uploaded by

    sravichandranvao
    IT

    Copyright:

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

    Class X It QP CH-8,9

    Uploaded by

    sravichandranvao
    4 views2 pages
    IT

    Original Title

    CLASS X IT QP CH-8,9

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    IT

    Copyright:

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

    Class X It QP CH-8,9

    Uploaded by

    sravichandranvao
    IT

    Copyright:

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

    Senthil Public School, Dharmapuri

    (Montessori & CBSE Stream)


    (Affiliated to CBSE, New Delhi, Affiliation No.: 1930752)
    Subject: I.T Unit:4 DBMS / Ch:8,9 / REVISION W/S:1 DATE:25/10/2024
    I.Multiple Choice Question: 11X1=11
    1)__________ is also considered as an inverted tree structure in database
    a)Network data model b)Hierarchical Data Model
    c)Relational data model d)Object oriented model
    2)___________ is a collection of these attributes associated with relation.
    a)Row b)keys c)Entity d)Both a and b
    3)A collection of fields make a _____, a collection of _______ make a table in database.
    a)record,record b)record,keys c)keys,record d)datavalue,record
    4)All Candidate key,other than primary key is called ________
    a)composite key b)Alternate key c)Foreign key d)Both a and b
    5)A field in a table can be taken as a foreign key if ______
    a)It is present in all other table b)It has Unique Values
    c)Is a primary key in some other table d)None of the above
    6)_________ datatype is used to store character strings of fixed length.
    a)Varchar b)Char c)Long Varchar d)Short Varchar
    7)_________ Stores date and time information at once
    a)Date b)Time c)Timestamp d)Date Format
    8)The _______ is located on the left side of the window.
    a)database pane b)Task pane c)Table pane d)User pane
    9)After selecting the Customer table, various fields appears under ______ .
    a)Selected Field b)Available Field c)Both a and b d)Navigation Field.
    10) _______ allows to assign a data type to the field.
    a)Field Type b)Field Description c)Both a and b d)None of the Above
    11)___________ is the text box where the currently active record number is displayed.
    a)Record Selector Box b)Record Box c)Navigation Box d)Both a and b
    II.Answer the following: 4X2=8
    12)Define the term
    a)Data b)Information c)Database
    13)What is the use of navigation box with respect to tables in a database?
    14)Difference between Memo and Varchar data type.
    15)What is the use of navigation box with respect to tables in a database?
    16)Define Primary Key.
    III.Answer in detail: 1X4=4
    17)Consider the table given below and answer the questions that follow:

    You might also like