Skip to main content

CS403 Current Midterm paper Shared by Izma khan, Spring 2014

    Total 26 Question
    Held on 07-JUN-2014
    20 MCQs = 20x1 Marks
    2 Questions each = 2 Marks
    2 Questions each = 3 Marks
    2 Questions each = 5 Marks

    Anaylyse relation (EMPLOY(enpId,empName etc... ))... and tell weathr it is in 2ND
    note: it is in 1NF -- 2 marks

    Customer (c-no, name, address, city, phone-no)

    Case A –
    If c-no --> city, phone-no
    Then c-no --> city and c-no --> phone-no

    Case B –
    If c-no --> phone-no and phone-no, address --> city
    Then c-no, address --> city

    Which of the Inference Rules are applied on the Case A and CaseB?
    AxB find krna tha
    A= no of week
    B =shift
     A {Monday,tuseday,Wednesday ‘Thursday,Friday}
    B={shift-1 shift-2 shift-shift-3}

    Component ER data model ?




Popular posts from this blog

CS301 Current Finalterm Paper Spring 2014 Shared By M. Waleed

My Tday's Cs301 Paper: Mcq's Are From Moaz And Some Are From Handouts. Subjective Is From Moaz Majority One. 1- The Image Segmentation Define? 2- The Maximum Number Level Of Nodes In Binary Tree 3-The Iteration Array Have To Sort. 4- The Hapified Array Have To Solved 5- The Algorithm Of Binary Seaoh Tree 6-Sara Arrays Wala He Tha Ya Heap Wala. 7-....Wala Wala Wala...
1 comment
Read more

CS614 Quiz No.4 Shared by Princess (solved), Spring 2014

  “What means What”. The phrase refers to: Select correct option:  Meta data  External data Transformed data Internal representations Question # 2 of 10 Which of the following is NOT one of the activities of “Maintenance and Growth” phase in Kimball’s DWH development approach? Select correct option: Education Technical Education Program Support  Interface Deployment                 Question # 3 of 10 Horizontally wide data means: Select correct option: Dataset has large no. of attributes Dataset has large no. of records Dataset has attribute skews Dataset has partitioning skews                 Question # 4 of 10 Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development? Select correct option: Not interacting directly with end ...
1 comment
Read more

CS614 Quiz No.3 Shared by Students (Solved), Spring 2014

______ index stores first value in each block in the sequential file and a pointer to the block.  Select correct option:   Dense  Sparse  B-Tree  Hash In context of data parallelism, the work done by query processor should be:  Select correct option:  Almost zero  Maximum  Pipelined  Filtered across partitions The optimizer uses a hash join to join two tables if they are joined using an equijoin and  Select correct option:   Outer table has less number of rows  Inner table has less number of rows  Cardinality of tables is equal  Large amount of data needs to be joined Bitmap index is appropriate for:  Select correct option:  Low cardinality data  High cardinality data  Clustered data  Aggregated data If a task takes “T” time units to execute on a single data item, then execution of this task on “N” data items will take __...
Post a Comment
Read more