Basics of Computer

Note: Attempt any five questions. All questions carry equal marks. Mobile Phone & Programmable Calculators are not allowed.  

Q.1: – a) Define the terms Data, Information, and Meta Data.

b) Write the advantages of Database.

Q.2:- a) What is Database Management System (DBMS)? Explain its function.

b) Explain the elements of the Entity Relationship Diagram (ERD) Model.

Q.3:- a) Define Relationship. Explain the degree of relationship.

b) Explain types of Association / Relationship. (1:1, 1:M, M:M)

Q.4:- What is DML (Data Manipulation Language)? Explain Insert, Update, and Delete, statements with suitable examples.

Q.5:- Define Key. Explain the Primary Key, Secondary Key and Composite Key.

Q.6:- What is a Constraint? Explain the purpose and syntax of the following constraints.

i) NOT NULL

ii) UNIQUE

iii) Primary Key

iv) CHECK Constraint

Q.7: – Explain the following SQL functions. i i)TRUNC iv)RTRIM vi)AVG

i) ROUND

ii) TRUNC

iii) MOD

vi) RTRIM

v) MIN

vi) AVG

Q.8:- a) Define the term View. Write the procedure for creating simple and complex views.

b) Discuss the importance of view in a multiuser environment.