data base management systems, Thesis of Database Management Systems (DBMS)

Download data base management systems and more Thesis Database Management Systems (DBMS) in PDF only on Docsity!

4/24/2018 Introduction to Database Previous-Paper 2014 ~ Online DIT Time Allowed: -03 Hours. Max. Marks: - 100 Note: - Attempt any five questions. All questions carry equal marks. Mobile Phone & Programmable Calculators are not allowed. Q.1: - a) What is Database? What are the advantages of Database? b) What is Primary Key and Secondary Key? " Q.2:- a) What is DBMS? What are the functions of DBMS? b) Differentiate between DBA and DBMS. Q3 :- a) What is ERD? Explain with the help of examples. b) What do you mean by degree of Relationship explain. Q.4:- a) What is Normalization? Explain its three types. b) Differentiate between Entity and Attributes. Q5:- a) Define DML. Explain insert, update and delete statement. b) Write down the purpose, syntax and example of CONCAT and MOD functions. Q.6:- a) What is DDL statements? Explain Create and Drop statements. b) Differentiate between Commit and Roll Back statements. Q7:- a) What is Conversion function? b) Define view and data dictionary. http://online-dit.blogspot.co.ke/2014/10/introduction-to-database-previous-paper.html 27