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 / abcd

It will show the error : Table already exists.

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a record variable to store a table row?

579


How to use select statement to count the number of rows in oracle?

555


What is a snapshot log?

564


How many anonymous blocks can be defined?

586


What are the differences between blob and clob in oracle?

582






How do you tell what your machine name is and what is its IP address?

1516


Explain the use of show option in imp command.

640


How can we force the database to use the user specified rollback segment?

559


What do you mean by a database transaction & what all tcl statements are available in oracle?

553


How to define an anonymous block?

618


What is the difference between online and offline backups?

560


How to get execution path reports on query statements?

566


 What are the oracle DML commands possible through an update strategy?

582


Can a formula column be obtained through a select statement ?

1845


How to use an explicit cursor without open statements?

616