 |
|
#1
12-01-2011, 02:41 PM
|
||||
|
||||
cs403 final term paper 2011
CS403 All Latest Final Term Papers Spring Fall 2011
Q no: 1 Write the two types of ordered indices? Q no: 2 Write three types of data Independence? Q no: 3 How do we prevent deadlock in DBMS? Q no:4 How the lost Updates are in DBMS? Q no: 5 Differentiate b/w crustal index and non crustal index? Q no: 6 what are the purposes of creating views in DBMS? Q no: 7 Write about NOT operators? Write any two similarities between matererialized views and indexs 2 Name two types of data dictionary 2 What is the role of commit 2Write an sql statement to remove an index called Index Number 2 In context with transaction what does the ACID Stands for 2 What is the main use of forms 3 States the major disadvantage of creating and using index 3 Write two factors which enforce a relation into send normal form 3 Write any five advantage of database system 5 Describe To_Date() function 5 Explain database objects 5 Write the output of the following Query 5 {table was given but the query was wrong written there so I mentioned that query written is wrong but this question is 5 no so I am going to rewrite the query and display result to youfirst table was student contains (SID,Class,Name,City)Results(SID,semester,result)} Select Name , result from student inner join result on student.sid=results.sid(which was given student.Name)Order by resuts.resultYeh Qs tohra modified hai mujay exact fields name nai yaad rahay. Paper # 2 Q1- What is Logical data base? Q2- How do we DELETE row by row from the table ? Q3- Write down the Three types of view. Q4- Write down the syntax of command CREATING INDEX. Q5- What do u mean by GROUP By command Q6- Give the implementtaion of One to many relationship Q7- Give three problems which are created in the absence of cohrenece Q8- Give similarities between Materilized view and indexe Cs403 Today ( 16.07.2011 ) Final Term 40 Objectives came from mostly Past papers and these very easy. Subjective: Explain Secondary key and give it’s a example. Three Factors when designing an indexed sequential file. Procedure which truncate command removes the data. What is the mean of “Operational maintenance” of database? Three problems which concurrency not controlled. Two primary modes of taking locks. What is the basics purpose of window control? Give an example. Why prefer direct access over sequential access of files. Name two types of completeness concurrent. Basic Syntax 40 Objectives came from mostly Past papers and these very easy. Subjective: Explain Secondary key and give it’s a example. Three Factors when designing an indexed sequential file. Procedure which truncate command removes the data. What is the mean of “Operational maintenance” of database? Three problems which concurrency not controlled. Two primary modes of taking locks. What is the basics purpose of window control? Give an example. Why prefer direct access over sequential access of files. Name two types of completeness concurrent. Basic Syntax of INDEX. 
|
|
Linear Mode
