Notes on Oracle

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, … Read more

What is the use of SHOW option in IMP command? The SHOW option specifies when the value of show=y, the DDL within the export file is displayed. How to add foreign keys in MySQL? The foreign key is used to link one or more tables together. It matches the primary key field of another table … Read more

Can you create a synonym without having a table? Yes. We can create a synonym without having a base table. How do you store pictures in a database? Yes, you can store pictures in a database using Long Raw Data type. This data type is used to store binary data for 2 gigabytes of length. … Read more

What is a snapshot in Oracle database? A snapshot is a replica of a target master table from a single point-in-time. In simple words you can say, snapshot is a copy of a table on a remote database. What is the difference between pre-select and pre-query? A pre-query trigger fire before the query executes and … Read more

What is bulk copy or BCP in Oracle? Bulk copy or BCP in Oracle, is used to import or export data from tables and views but it does not copy structure of same data. The main advantage of BCP is fast mechanism for coping data and you can also take the backup of data easily. … Read more

Oracle Interview Questions – Set 05 Oracle Interview Questions – Set 04 Oracle Interview Questions – Set 03 Oracle Interview Questions – Set 02 Oracle Interview Questions – Set 01