Q:1 what are the creteria to judge the affectiveness of a
chache memory?
Q:2 Differentiate between procedural and non-prodedural DML.
Q:3 How for should the recovery manager go backword in the
log-file to trace the transaction affacted from the crash that the recovery manager
needs to redo or ignore.
Q;4 write a SQL command to show all the cities from given
students table .city should be not repeated :
STUDENTS(stu_id,stu_name,father_name,address, city ,
province)
Q:5 Analyze the statement give below and identify as correct
or incorrect . Justify
"isolation" ansure that a transaction which is in
progress may noot affect the transaction.
Q:6 what are the primary modes of locks? Differentiat
between shared and update lock.
Q :7 Analyze the below query and findout why it will not
work. correct the error
SELECT*FORM customer WHERE Year>'2004'
Q: 8 analyze the statement. Justify your answer
in RAID level 1 if either drive fails no data is lost.
Q: 9 justify
0)After defining indexes are not updated in any case
1) index can only be defined when table has at least 100
rows
Comments
Post a Comment
Please give us your feedback & help us to improve this site.