What is the use of GRANT option in IMP command?

GRANT is used to import object grants.

What is the difference between post-database commit and post-form commit?

The post-database commit trigger is executed after Oracle forms issue the commit to finalized transaction while, the post-form commit is fired during the post and commit transactions process, after the database commit occurs.

What is the use of ROWS option in IMP command?

The ROWS option indicates whether the table rows should be imported.

What are the extensions used by Oracle reports?

Oracle reports are use to make business enable with the facility to provide information of all level within or outside in a secure way. Oracle report uses REP files and RDF file extensions.

What is Logical backup in Oracle?

Logical backup is used to read a set of database records and writing them into a file. An Export utility is used to take the backup while an Import utility is used to recover from the backup.

How to convert a string to a date in Oracle database?

Syntax: to_date (string , format)

Let us take an example :

to_date (‘2012-12-12’, ‘YYYY/MM/DD’)
It will return December 12, 2012.

What is the use of INDEXES option in IMP command?

The INDEXES option is used to determine whether indexes are imported.