Download SGBAU BSc 2019 Summer 4th Sem CA CS IT RDBMS PL SQL Question Paper

FirstRanker.com

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

COMPUTER SCIENCE/COMPUTER APPLICATION/INFORMATION TECHNOLOGY

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

(New)

(RDBMS and PL/SQL)

Time : Three Hours] [Maximum Marks : 80

N.B. :— (1) ALL questions are compulsory.

(2) Question No. 1 carries 8 marks and all other questions carry 12 marks each.

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

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

1. (A) Fill in the blanks :
   1. BCNF stands for __________
   2. __________ clause is used to sort the contents of table.
   3. __________ function measures all the rows in entire table.
   4. __________ section is the execution section of PL/SQL.

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

   (B) Choose correct alternative :
   1. Non key attribute of one table becomes primary key of another table is called
      1. Primary key
      2. Foreign key
      3. Super key
      4. Candidate key

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

   2. __________ is not SQL component.
      1. DCL
      2. DML
      3. DDL
      4. DSL

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

   3. In outer join operator combines matching and non matching rows of two tables.
      1. +
      2. %
      3. *
      4. -

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

   4. Hierarchical model has __________ connectivity.
      1. One to one
      2. One to many
      3. Many to many
      4. Many to one

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

   (C) Answer in one sentence :
   1. What is primary key ?
   2. What is DBMS ?
   3. What is block in PL/SQL ?
   4. What is privilege ?

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

2. (A) Describe hierarchical database model with example.
3. (B) Why database systems are more popular over conventional file system ?

OR

3. (A) Describe architecture of database system and explain with diagram.
4. (B) What is relation ? Describe relational database model.

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

4. (A) What is E-R diagram ? Describe procedure to draw E-R diagram.
5. (B) Describe the following terms
   1. Functional dependency
   2. Entity and entity set.

OR

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

5. (A) Describe the following terms :
   1. Attribute
   2. Domain
   3. Relation.
6. (B) What is normalization ? Explain 3NF with example.

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

6. (A) What is SQL ? Explain components of SQL.
7. (B) Describe various data types used in SQL with suitable example.

OR

7. (A) Describe the following commands with syntax and example :
   1. CREATE
   2. RENAME

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

   3. UPDATE.
8. (B) What is data integrity ? Give types of integrity constraints.

8. (A) Describe the following functions with example :
   1. POWER
   2. SIGN

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

   3. SIN.
9. (B) What is join ? Explain equi join with example.

OR

9. (A) Describe with syntax and example :
   1. INITCAP

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

   2. INSTR
   3. RTRIM.
10. (B) Describe various date functions with syntax and example

10. (A) What is cursor ? How to use explicit cursor ? Describe with example.

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

11. (B) Describe loop control structure in PL/SQL with example.

OR

11. (A) Describe datatype support by PL/SQL with example.
12. (B) What are various cursor attributes ?

12. (A) Explain the following statements with syntax and example :
    1. GRANT

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

    2. REVOKE.
13. (B) How to secure databases ? Explain.

OR

13. (A) What is transaction ? Describe various transaction control statements.

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

14. (B) Describe various levels of data locking in SQL.

FirstRanker.com