Download SGBAU BSc 2019 Summer 4th Sem Computer Application DBMS Question Paper

FirstRanker.com

AW-1725

Time : Three Hours] [Maximum Marks : 80

--- Content provided by FirstRanker.com ---

B.Sc. (Part-II) (Semester-IV) Examination

COMPUTER APPLICATIONS (VOC.) (NEW)

(Database Management System)

Note :— (1) Question No. 1 is compulsory.

(2) Question Nos. 2 to 13 carry equal marks.

--- Content provided by FirstRanker.com ---

(3) Assume suitable data and draw labelled diagram wherever necessary.

1. (A) Fill in the blanks :
   1. Existence of ___entity depends on another entity.
   2. _____ command is used to modify the existing row of table.
   3. Non-key of one table becomes a primary key of another table is known as ____
   4. _____ command is used to display the data from table.

   --- Content provided by FirstRanker.com ---

   (B) Choose the correct alternative and rewrite the statement :
   1. _____ is not number function.
      1. Lower
      2. AVG
      3. MAX
      4. ABS

   --- Content provided by FirstRanker.com ---

   2. Rows in the table (relation) are called _____
      1. Attribute
      2. Tuples
      3. Node
      4. Entity

   --- Content provided by FirstRanker.com ---

   3. _____ data type is used to store binary data.
      1. Number
      2. RAW
      3. BIN
      4. CHAR

   --- Content provided by FirstRanker.com ---

   4. _____ statement makes changes permanent.
      1. Commit
      2. Roll back
      3. MKPR
      4. TRIGGER

   --- Content provided by FirstRanker.com ---

   (C)
   1. What is system privilege ?
   2. What is E-R diagram ?
   3. What is BCNF ?
   4. What is save point ?

--- Content provided by FirstRanker.com ---

2. (A) Describe Architecture of Database system.
3. (B) Explain Hierarchical database model with example.

OR

3. (A) What are various components of database system ?
4. (B) Explain Network database model with example.

--- Content provided by FirstRanker.com ---

4. (A) What is E-R diagram ? Describe symbols used in it.
5. (B) Describe the following :
   1. Relation
   2. Attribute
   3. Domain

--- Content provided by FirstRanker.com ---

OR

FirstRanker.com

5. (A) Describe the following :
   1. Functional dependency
   2. Entity and entity set

--- Content provided by FirstRanker.com ---

6. (B) Explain 3 NF with example

6. (A) Describe various components of SQL.
7. (B) Explain following with syntax and example :
   1. INSERT
   2. UPDATE

--- Content provided by FirstRanker.com ---

OR

7. (A) Describe ORDER BY clause with example.
8. (B) Explain rollback segment

8. (A) Describe various integrity constraints
9. (B) Describe the following Date functions :
   1. add_months ( )

   --- Content provided by FirstRanker.com ---

   2. Last_day

OR

9. (A) Describe following with syntax and example :
   1. ABS
   2. SQRT

   --- Content provided by FirstRanker.com ---

   3. SIGN
10. (B) What is join ? Explain self join with example.

10. (A) Describe various data types in PL/SQL with example.
11. (B) Describe following :
    1. Creating BEFORE trigger

    --- Content provided by FirstRanker.com ---

    2. Creating AFTER trigger

OR

11. (A) Differentiate between implicit and explicit cursors.
12. (B) Describe concept of package and its creation.

--- Content provided by FirstRanker.com ---

12. (A) Describe various locking levels.
13. (B) Describe SQL security concept.

OR

13. (A) What is privileges ? What are system privileges ?
14. (B) How views are useful in security enforcement ?

--- Content provided by FirstRanker.com ---