Question given relation r (A,B,C,D) and the following fd’s. Identify the candidate key for r and highest normal form b->C, d->a question Consider the universal relation R= {A,

Download 1.99 Mb.
Size1.99 Mb.
  1   2   3   4   5

Question 1

Given relation R (A,B,C,D) and the following FD’s. Identify the candidate key for R and highest normal form

B->C, D->A

Question 2

Consider the universal relation R= {A,B,C,D,E,F,G,H,I,J} and a set of functional dependencies F= { {AB→ C}, { A → DE}, { B→ F}, {F→ GH}, {D→ IJ}}. What is the key for R? Decompose R into 2NF, then 3NF relations.

Question 3

Give PL/SQL example for the following attributes of cursor

  •  %rowcount

  • %notfound    

Question 4

Enumerate the types of privileges available in SQL.


privilege is a right to execute a particular type of SQL statement or to access another user's object.

Privileges perform operations like, connecting to the database, creating a table, Selecting rows from another user's table.

There are two distinct categories of privileges:

  • System Privileges

A system privilege is the right to perform a particular action, or to perform an action on any schema objects of a particular type. For example, the privileges to create tablespaces and to delete the rows of any table in a database are system privileges. There are over 60 distinct system privileges.

You can grant or revoke system privileges to users and roles. If you grant system privileges to roles, then you can use the roles to manage system privileges. For example, roles permit privileges to be made selectively available.
  1   2   3   4   5

The database is protected by copyright © 2020
send message

    Main page