What is a collection of privileges?

hari kumar

• Aug 2nd, 2012

Its role .... we can assign a role like manager , etc , collection of privs is known as role

BBBB

• Apr 19th, 2012

Collecting the access

eg: insert,select,update

in this group the user can apply only the above operation on the tables.

Answer Question  Select Best Answer

What is an Archiver in Oracle?

venkatesh

• Jun 8th, 2012

Its background processes in oracle, it will write offline redolog group information into archive log files

Answer Question  Select Best Answer

What is a Synonym in Oracle?

jimmy.katiyar11

 Profile Answers by jimmy.katiyar11 Questions by jimmy.katiyar11

• Nov 29th, 2011

Hi, In oracle use SYNONYM as a temporary name of the object ( Table, view, index etc.)

Code
 
  CREATE SYNONYM synonym_name FOR table_name
 
You CREATE PUBLIC SYNONYM WITH the PUBLIC keywrd
 
 
CREATE PUBLIC SYNONYM synonym_name FOR table_name

Payal Shah

• Sep 5th, 2011

Synonum is a alias of the table..

Answer Question  Select Best Answer

What is an exception in Oracle?

asit

• Jun 9th, 2012

Exceptions are nothing but the errors occurred at the run time. To handle the exception we use exception block in the PLSQL.

Answer Question  Select Best Answer