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 the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,


What is the difference between translate and replace?

0 Answers  


What is an Integrity Constrains ?

3 Answers  


Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers  


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

0 Answers  






What is the usage of analyze command in oracle?

0 Answers  


how to make an oracle object

0 Answers  


how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  


Explain the use of control file?

0 Answers  


How to retrieve data from an explicit cursor?

0 Answers  


How do I uninstall oracle client from windows?

0 Answers  


can anyody please send me the dump for Oracle 10g certifications for DBA path?

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)