Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

          Anees Ahmad mcs second semester

28/07/2013 papar  

1.Write any two benifits of “VIEWS”.  2marks

2.Wha t is the basic purpos of windows control? Give two example of  windows control.  2marks

3.How deadlock occurs? 2mark

4.Analyze the statement given below and identify as correct or incorrect. Justify your answer in either case.

‘’in recovery procedure,the transactions ended before the checkpoint are redone”     2Marks

5.Suppose we have ERD having two entities Emplyee and Parking-space there is one to one relationship

Between these two entities.

Emplyee entity has a attribute as,

EMP_ID, EMP_name, Address

Parking-space has  a attribute as,

PARKING_ID

Map and said scenario into relation.               3marks

6.Write diffrence between EQUI JOIN and NATURAL JOIN.     3marks

7.Create a view named “PRODUCT-LIST” on PRODUCT table to show all column

PRODUCT (PRODUCT -ID, PRODUCT -NAME, PRODUCT QTY)   3marks

8.Analyze the statement given below and identify as correct or incorrect. Justify your answer in either case.

“It is a good approach to create an index on non-key attribute”.    3marks

 

9.create view of PROFESSOR_LIST on PROFESSOR table. Display name who belongs to city ‘LAHORE ‘and Course ‘ALGORITHM’?          5marks
PROFESSOR(id, name, city, course)


10. Analyze the statement given below and identify as correct or incorrect. Justify your answer

 

0.After defining , Indexs are not updated in any case.

1.Index can only be define, when table have at least 100 rows.

 

 

 

11. STUDENT TABLE

STD_ID

STD NAME

ADDRESS

CITY

1

AHMAD

ABC-123

XYZ

2

ALI

DEF-456

WXY

3

RASHEED

GHI-789

WYZ

4

REHAN

GKL-012

XYZ

5

FAHAD

MNO-345

WXZ

 

RESULT  TABLE

STD_ID

SEMESTER

TOTAL SEM PARKS

1

SP-2011

400

2

SP-2011

367

3

SP-2011

164

5

SP-2011

423

 

Suppose table are provided above, you have to draw output table of the SQL quary

SELECT.STUDENT.STU_NAME, RESULT.TATAL_SEM_MARKS

FROM STUDENT

INNER JOIN RESULT

ON STUDENT.STU_ID=RESULT.STU_ID

ORDER BY RESULT=TOTAL+SEM_MARKS                                    (5marks)

 

 

12.

Customer

CUSTOMER_ID

CUSTOMER

CITY

1

ABC

LAHORE

2

DEF

ISLAMABAD

3

GHI

LAHORE

4

JKL

KARACHI

 

 

 

 

Invoice

Invoice

 

CUST_ID

Date

Amount

1

1

13/1/2011

2500

2

2

13/1/2011

1000

3

4

15/1/2011

1500

 

 

Find resultant table A for given relation algebra statement

Customer X (Equi join invoice)

Where Equi join=CUSTOMER.CUSTOMER_ID=INVOICE.CUST_ID                  5Marks

Views: 366

Attachments:

Replies to This Discussion

yar MCQS ka b idea dein............new MCQS or from past papers????

MOstly from old papars or moaaz ki file se 15 20 aa he jaty hyn.

RSS

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service