Chapter Test Computer Science Class-12 Chapter 1, 2

Chapter Test Computer Science Class-12 Chapter 1, 2

Chapter Test Computer Science Class-12 Chapter 1, 2

ICS part II Computer (Chap # 1 & 2)


Total Time: 1hr 30 min    Total marks: 50

Objective                                                                                                                
Q1.  MCQs                                                                                                  

  1. The process of arranging data in a logical sequenceiscalled: 
    1. Summarizing
    2. Capturing
    3. Classifying
    4. Sorting
  2. In relational database, a single piece of informationiscalled:
    1. Record
    2. Entity
    3. Attribute
    4. Field
  3. Which of the following may be atemporaryfile?        
    1. Masterfile
    2. Datafile
    3. Transactionfile
    4. Programfile
  4. Microsoft Saves the database withtheextension:                              
    1. .mdb
    2. .msdb
    3. . madb
    4. .mxls
  5. Whichrepresentsacollectionofconceptsthatareusedtodescribethestructureofadatabase?
    1. Data warehouse
    2. Data Model
    3. Datastructure
    4. Datatype
  6. The row of relation canbeof        order.
    1. Same
    2. Any
    3. Sorted
    4. Constant
  7. Which is used to indicate characteristics of an object?
    1. Relationship
    2. Co-ordinately
    3. Modality
    4. Attribute
  8. A virtual table that is constructed from another tableiscalled:     
    1. Tuple
    2. Table
    3. View
    4. Report
  9. Which of the following is also known ascontrolkey?         
    1. Foreignkey
    2. Compositekey
    3. Primarykey
    4. Sort key
  10. A table musthavea:
    1. Secondarykey
    2. Primary key
    3. Compositekey
    4. Sortkey

Subjective
Time: 1hr 15min                                                                                                                 Marks: 40
SHORT QUESTIONS
Q2.  Attempt any twelve questions [2*12=24]                                                      

  1. Differentiate b/w dataandinformation?
  2. Definefield.                            
  3. What isa file?
  4. Differentiate b/w master file andtransactionfile.                             
  5. Whatisfileorganization?Namedifferenttypesoffileorganization.
  6. List any two problems in traditionalfileapproach.
  7. Define the term DML&DDL.
  8. Whatisattribute?                                            
  9. Define entity. Give two exampleofentity
  10. List different properties ofarelation.
  11. What is the purpose ofusingview?                                                    
  12. Who isdatabaseadministrator?
  13. State the purpose ofindexfile?
  14. What are the four responsibilities of a database administrator?

LONG QUESTIONS
Q3. Attempt any two questions    [8*2=16]

  1. Explain Database Management System. Discuss any four advantages of Database ManagementSystem.
  2. What activities are involved in data processing? Discuss indetail.
  3. What is key? Discuss different typesofkeys.