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.
Page2/5
Date21.11.2021
Size1.99 Mb.
1   2   3   4   5
Grant privileges:

To grant privileges to a user account, the GRANT statement is used.

Since using the Create User Statement only creates a new user but does not grant any privileges to the user account.

Syntax to grant privileges:

GRANT privileges_names ON object TO user;

  • Revoke Privileges:

The Revoke statement is used to revoke some or all of the privileges which have been granted to a user in the past.

Syntax to revoke privileges:

REVOKE privileges ON object FROM user;
Question 1

Discuss various types of cursors.

Cursors:

cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is referred to as the active set.

There are two types of cursors −
1   2   3   4   5




The database is protected by copyright ©ininet.org 2020
send message

    Main page