Time 3 Hours Maximum Marks : 70
Note:-Candidates are required to give answers in their own words as far as possible.
The questions are of equal value.
Answer any five questions.
Q 1. Answer questions from below [14 x 1 = 14]
i) What is the full form of DBMS?
a) Data of Binary Management System
b) Database Management System
c) Database Management Service
d) Database Management Service
ii) Which of the following is not an example of DBMS?
a) MySQL
b) Microsoft Access
c) IBM DB2
d) Google
iii) Which of the following is known as a set of entities of the same type that share the same properties, ora.tributes?
a) Relation set
b) Tuples
c) Entity set
d) Entity Relation model
iv) What is information about data called?
a) Hyper data
b) Tera data
c) Meta data
d) Relations
v) is a set of one or more attributes taken collectively to uniquely identify a record.
a) Primary key
b) Foreign Key
c) Super key
d) Candidate key
vi) What do you mean by one to many relationship between Teacher and class Table ?
a) One class may have many teachers
b) One teacher can have many classes
c) Many classes may have many teachers
d) Many teachers may have many classes
vii) in SQL, which command is used to changes data in a table.
a) UPDATE
b) INSERT
c) BROWSE
d) APPEND
viii) Database management system are intended to:
a) Eliminate data redundancy
b) Establish relationships among records in different files
c) Manage file access
d) All of the above
ix) In mathematical term Table is referred as
a) Relation
b) Attribute
c) Tuple
d) Domain
x) In SQL, which command is used to select data in rows and columns from one or more tables?
a) CHOOSE
b) SELECT
c) LIST
d) BROWSE
xi) allow us to identify uniquely a tuple in the relation.
a) SuperKey
b) Domain
c) Attribute
d) Schema
xii) If every non-key attribute is functionally dependent on the primary key, the relation will be in
a) First Normal Form
b) Second Normal Form
c) Third Normal Form
d) Fourth Normal Form
xiii) Goals for the design of the logical schema include
a) Avoiding data inconsistency
b) Being able to construct queries easily.
c) Being able to access data efficiently
d) All of the above
xiv) A logical description of some portion of database that is required by a user to perform task is called as
a) System View
b) Logical View
c) User View
d) Data View
Q 2. What is DBMS? Explain advantages and disadvantages of DBMS. What is difference between DBMS and RDBMS? [4 + 5 + 5]
Q 3. What are the different components of DBMS? Explain each of them in detail. [4+10]
Q 4. What is the purpose of SQL? Explain insertion, updation and deletion methods in a database table with SQL query. [5+9]
Q 5. Explain Entity Relationship Model. What are the different types of Relationships in DBMS? What do you mean by multivalued attributes? [4+10]
Q 6. Explain Entity, Entity Type, and Entity Set in DBMS? Explain different types of keys available in the Relational Model. [7+7]
Q 7. What do you mean by Functional dependency?
Q 8. Explain the concept of ACID properties in DBMS?
Q 9. What are different types of joins in SQL? Give the name of five applications that are used in the database and why? [10+4]
Q 10. Define transaction in RDBMS. Explain briefly the different states of a transaction with a net diagram. What is timestamp?