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?
Answer Posted / 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 |
Post New Answer View All Answers
State the various uses of dbcc command?
How to use fetch statement in a loop?
Can a parameter be passed to a cursor?
Differentiate between post-database commit and post-form commit?
How do I find my oracle client driver version?
How to write a query with a right outer join in oracle?
How to use "if" statements on multiple conditions?
What is an oracle database table?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to select all columns of all rows from a table in oracle?
Explain the use of show option in imp command.
Explain an extent?
Does oracle charge for java?
What are the attributes that are found in a cursor?
How to add another datafile to a tablespace?