DBMS 4th july paper updated

DBMS

Kindly do make vuhelps your default page and keep viewing it to get up to date information about current fresh exams. Also follow the blog. Send your papers to make them here uptodate at vuhelps@gmail.com or feel free to call at 03455242488
Total 41 Questions
In which 30 are MCQ’s 1 marks each and 11 questions.

1. Write the first step to change logical database into physical database? (1 marks)
2. Write range of Tinyint? (1 marks)
3. Write two types of interfaces? (2 marks)
4. Define a COMMIT? (2 marks)
5. Write advantage of DELETE command over TRUNCATE (3 marks)
6. Write importance of queries? (3 marks)
7. Why LOST UPDATE problem occurs? (3 marks)
8. Define VIEWS with security mechanism? (5 marks)
9. Define SEMI join? (5 marks)
10. Two tables are given with queries we have to tell that whether queries are VALID or INVALID? (10 marks each)

Regards Vuhelps

DBMS 4th july paper

Kindly do make vuhelps your default page and keep viewing it to get up to date information about current fresh exams. Also follow the blog. Send your papers to make them here uptodate at vuhelps@gmail.com or feel free to call at 03455242488
Q. Explain the mechanism of LOCKING ? aslo expalin the two types of operation ( read, write) the transction on object? 10 Marks

Q, Briefly explain RAID? and aslo the striping meathod in RAID? 10 Marks

Q, What is Transction? what are the properties of ACID? 5 Marks

Q. What is the importance of De-normalization in DBSM? 5 Marks

Q,What are 3 benifits of using VIEW? 3 Marks

Q. Tell the major difference b/w SQL and other convention programming Langages? 3 Marks

Q. Name of two approaches to create tables for the DATABASE? 2 Marks

Q. When a query is sent to the DATA BASE and an index is not being used, What type of execuation is taking place? 2 Marks

Q. What is procecdual of DML? 2 Marks

Q. What Commands udes to drop the VIEW? 2 Marks

Regards Vuhelps