Prepare Interview with Confidence
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
If you are looking for Self Assessment Technical Mock Test to prepare you Interview, you are at right place. We are offering Self Assessment Technical Interview Mock Test Series. Contact us in chat box, we will call you back.
If you are looking for Corporate Assessment Test for Interview Screening the Candidates who applied for job vacancies, you are at right place. We are offering Corporate Assessment Test for Interview Screening. Contact us in chat box, we will call you back.
Eklavya Online is Free Study Portal for NewBies and Experienced Guys who wanna upgrade their knowledge in their respective industry and strive to learn more.