Results 1 to 10 of 10

Thread: cs403 final paper 2012

  1. #1

    Post cs403 final paper 2012

    MY todays paper
    TOTAL 52 QUESTIONS
    40= MCQZ= APPROXIMATELY 15 FROM PAST PAPERS, REST MCQZ WERE new logical mcqz,
    4 question - 3 marks of each
    4 question-2 marks of each
    4 question-5 marks of each
    5 marks questions
    find Cartesian product from given?
    create index of following query?
    draw cross reference matrix of following?
    different statements which is correct and which is incorrect?
    3 marks question
    one to one relationship
    INDEXES CLASSIFICATION ACCORDING TO OPTIONS?
    what is the common disadvantages of indexes and materialized views?
    create alter statement of following
    2 marks questions
    what is the purpose of AND OPERATOR?
    what is the purpose of OR OPERATOR?
    CREATE SYNTAX OF SELECT STATEMENT?
    WHICH IS USED FOR WILDCARD?


  2. #2

    Default Re: cs403 final paper 2012

    very nice dear


  3. #3

    Default Re: cs403 final paper 2012

    thanks alot admin

  4. #4

    Default Re: cs403 final paper 2012

    my today's papar 18-7-2012
    Q.1:If a company can not compromise on data access time. which file processing technique you'll suggest in this case.
    Q.2: difference b/w semi join & natural join.
    Q.3: if table 1 has 20 indexes & table 2 has 14. both have same data & values. three statements were given to choose correct or incorrect b/w the tables.
    q.4: statement: text based interfaces include more tables than GUI. justify it as true.
    q.5: a table can have more than one clustered index . if true justify it.
    q.6: semi join sql coding & 2 tables were given & you have to calculate resultant table.


    q.7: what does SELECT keyword in sql?
    q.8: A view have to created & a student table was given. in view you have to collect all st.ID which in ascending order where city=something.

  5. #5

    Default Re: cs403 final paper 2012

    My today paper 17-7-2012 at 8:00 am
    Mostly MCQ's new thae 25% past paper se ae thae
    2 Marks

    What is diff b/w database and dbms? 2 Mark
    What is the purpose of OR OPERATOR? 2 Mark
    Write any two similarities between matererialized views and indexs?
    2Marks
    Ak organization store karti hai data or wo uske lye tape use nae karti or baten ke storage ke lye kia behtr hogai for direct acess

    3 Marks

    1. State the basic difference between Inner join and Left Outer Join. . 3 marks
    2. In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks
    3. Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 3 Mark
    4. a table is given and btana tha kun sa worst hai good hai and average hai according to time….1st one tha linear piping shayad,, 2nd chaining and 3rd rehasing? 3 Marks

    5 Marks

    1. Analyze the below given statements and mark as correct and incorrect and also explain. (Marks 5)
    1. Deadlock occurs when one transaction wants to read more than on object at same time.
    2. The mechanism ―Wait for Graph‖ is used to apply join on multiple.

    2. Given two tables DOCTOR (D_ID,D_CONTACT) , MEDICINE(M- CODE, Description) (i) Create unique index DOCTOR on D_ID on field
    (ii)Create unique index MEDICINE on composite M-CODE, Description

    ERD digram banai thin yeh bhi 5 marks ka tha
    Table diye hoe thae r btana tha kun sa join hai….



  6. #6

    Default Re: cs403 final paper 2012

    Q.1:If a company can not compromise on data access time. which file processing technique you'll suggest in this case.
    Q.2: difference b/w semi join & natural join.
    Q.3: if table 1 has 20 indexes & table 2 has 14. both have same data & values. three statements were given to choose correct or incorrect b/w the tables.
    q.4: statement: text based interfaces include more tables than GUI. justify it as true.
    q.5: a table can have more than one clustered index . if true justify it.
    q.6: semi join sql coding & 2 tables were given & you have to calculate resultant table.


    q.7: what does SELECT keyword in sql?
    q.8: A view have to created & a student table was given. in view you have to collect all st.ID which in ascending order where city=something.


  7. #7

    Default Re: cs403 final paper 2012

    thanx fro sharing..
    Ye sab Tumhara karam hai Aqqa ki baat ab tak bani hui hai.

  8. #8

    Default Re: cs403 final paper 2012

    not mention

  9. #9

    Default Re: cs403 final paper 2012

    write down the alternative name of browser base form? 2 marks
    Q2: Different classification of indexes? 2 Marks
    Q3: List down any two problems which may come up if the concurrency is not controlled properly? 2 marks ( handout page 307)
    Q4: In three schema architecture, External schema is responsible for data storage on hard disk. Correct and justify it. 3 marks
    Q5: Create view named “Product_list” on product table which will show all the columns? 3 marks
    Q6: Describe the importance of Data link properties tool in designing form by using MS Access? 3 marks
    Q7: In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks
    Q8: Draw cross Reference matrix? 5 marks diagram was given
    Q9: Deadlock is a serious threat for the concurrent transaction; shortly explain the approach which is used to detect the deadlock by DBMS? 5 marks
    Q10: Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 5 Marks


  10. Default Re: cs403 final paper 2012

    shakal vaikhi apni tu main sami say free main banwa lon ge .sanbhal k rakh apna 149$

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •