Welcome to the VuGoogle - We Lead and Others Follow -.
Header

VuGoogle - We Lead and Others Follow - » --== Virtual University Section ==-- » CS - Computer Sciences » CS403 » Final term » cs403 final paper 2012

Reply
Thread Tools vBmenu Seperating Image
cs403 final paper 2012
  #1  
Old 07-17-2012, 01:22 AM
$@mi $@mi is offline
Super Mod boys
Points: 27,789, Level: 72
Points: 27,789, Level: 72 Points: 27,789, Level: 72 Points: 27,789, Level: 72
Activity: 66.7%
Activity: 66.7% Activity: 66.7% Activity: 66.7%
 
Join Date: Apr 2012
Posts: 363
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?

Reply With Quote
  #2  
Old 07-17-2012, 01:27 PM
Admin's Avatar
Admin Admin is offline
Administrator
Points: 230,609, Level: 100
Points: 230,609, Level: 100 Points: 230,609, Level: 100 Points: 230,609, Level: 100
Activity: 99.5%
Activity: 99.5% Activity: 99.5% Activity: 99.5%

 
Join Date: Dec 2010
Location: Pakistan
Posts: 3,225
Default Re: cs403 final paper 2012

very nice dear
__________________

Reply With Quote
  #3  
Old 07-18-2012, 01:00 PM
$@mi $@mi is offline
Super Mod boys
Points: 27,789, Level: 72
Points: 27,789, Level: 72 Points: 27,789, Level: 72 Points: 27,789, Level: 72
Activity: 66.7%
Activity: 66.7% Activity: 66.7% Activity: 66.7%
 
Join Date: Apr 2012
Posts: 363
Default Re: cs403 final paper 2012

thanks alot admin
Reply With Quote
  #4  
Old 07-18-2012, 01:00 PM
$@mi $@mi is offline
Super Mod boys
Points: 27,789, Level: 72
Points: 27,789, Level: 72 Points: 27,789, Level: 72 Points: 27,789, Level: 72
Activity: 66.7%
Activity: 66.7% Activity: 66.7% Activity: 66.7%
 
Join Date: Apr 2012
Posts: 363
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.
Reply With Quote
  #5  
Old 07-21-2012, 07:19 AM
$@mi $@mi is offline
Super Mod boys
Points: 27,789, Level: 72
Points: 27,789, Level: 72 Points: 27,789, Level: 72 Points: 27,789, Level: 72
Activity: 66.7%
Activity: 66.7% Activity: 66.7% Activity: 66.7%
 
Join Date: Apr 2012
Posts: 363
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….


Reply With Quote
  #6  
Old 07-21-2012, 07:21 AM
$@mi $@mi is offline
Super Mod boys
Points: 27,789, Level: 72
Points: 27,789, Level: 72 Points: 27,789, Level: 72 Points: 27,789, Level: 72
Activity: 66.7%
Activity: 66.7% Activity: 66.7% Activity: 66.7%
 
Join Date: Apr 2012
Posts: 363
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.

Reply With Quote
  #7  
Old 07-21-2012, 07:22 AM
VAMPIRE EYES's Avatar
VAMPIRE EYES VAMPIRE EYES is offline
Special Girl
Points: 18,454, Level: 59
Points: 18,454, Level: 59 Points: 18,454, Level: 59 Points: 18,454, Level: 59
Activity: 99.3%
Activity: 99.3% Activity: 99.3% Activity: 99.3%
 
Join Date: Apr 2012
Location: pakistan
Posts: 134
Default Re: cs403 final paper 2012

thanx fro sharing..
__________________
Ye sab Tumhara karam hai Aqqa ki baat ab tak bani hui hai.
Reply With Quote
  #8  
Old 07-21-2012, 07:25 AM
$@mi $@mi is offline
Super Mod boys
Points: 27,789, Level: 72
Points: 27,789, Level: 72 Points: 27,789, Level: 72 Points: 27,789, Level: 72
Activity: 66.7%
Activity: 66.7% Activity: 66.7% Activity: 66.7%
 
Join Date: Apr 2012
Posts: 363
Default Re: cs403 final paper 2012

not mention
Reply With Quote
  #9  
Old 07-21-2012, 07:26 AM
$@mi $@mi is offline
Super Mod boys
Points: 27,789, Level: 72
Points: 27,789, Level: 72 Points: 27,789, Level: 72 Points: 27,789, Level: 72
Activity: 66.7%
Activity: 66.7% Activity: 66.7% Activity: 66.7%
 
Join Date: Apr 2012
Posts: 363
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

Reply With Quote
  #10  
Old 06-24-2013, 09:04 PM
naveedjamal naveedjamal is offline
Junior Member
Points: 11,989, Level: 47
Points: 11,989, Level: 47 Points: 11,989, Level: 47 Points: 11,989, Level: 47
Activity: 33.3%
Activity: 33.3% Activity: 33.3% Activity: 33.3%
 
Join Date: Dec 2011
Posts: 3
Default Re: cs403 final paper 2012

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

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump