when a grant option is encountered for a table EMP to a
peer sitting beside you who has already having the table of
that name (EMP), then what is the result?

Answers were Sorted based on User's Feedback



when a grant option is encountered for a table EMP to a peer sitting beside you who has already ha..

Answer / devraj

He will have the rights on both tables. But on query the
first result will be fetched from his schema table.

Is This Answer Correct ?    2 Yes 1 No

when a grant option is encountered for a table EMP to a peer sitting beside you who has already ha..

Answer / abcd

It will show the error : Table already exists.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Oracle General Interview Questions

What is currency type in database ?

3 Answers   TCS,


What are the uses of Rollback Segment ?

2 Answers  


Where do you use decode and case statements?

0 Answers  


What is meant by joins?

0 Answers  


How do we create privileges in oracle?

0 Answers  






What is connection pooling in oracle?

0 Answers  


What is a user account in oracle?

0 Answers  


What is translate in oracle?

0 Answers  


How a tablespace is related to data files?

0 Answers  


I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  


How to upsert (update or insert into a table)?

0 Answers  


What are the varoius components of physical database structure of oracle database?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)