-
Find High Value of an Array
How to find out the max high value using varray?
-
Use of NOCOPY in Procedure
CREATE OR REPLACE PACKAGE XX14_SO_INBOUND_PKG AS PROCEDURE main ( x_errbuf OUT NOCOPY VARCHAR2 , x_retcode OUT NOCOPY NUMBER , p_data_file_path IN VARCHAR2 ); END XX14_SO_INBOUND_PKG;
In above procedure what is the use of NOCOPY...? -
Error while Inserting Records into Table
How to insert records into Oracle db table if I got error while inserting 4th record then how to insert 5th,6th.... records continuously
-
-
-
Synonym without Table
If there no table but we can create a synonym. If it raises error or not. If raises error what error it raises.
-
-
CURSOR and BULK COLLECT
How does CURSOR and BULK COLLECT work logically?
-
RefCursor Data Type
When and for what purpose do we use refcursor instead of other data type?
-
PL/SQL Block Cursor
Scenario: I forgot to Close the Cursor in PL/SQL block. I executed the block successfully. Again I am going to execute that block without Closing the cursor. An error will be thrown or not?
-
Number of Databases Running
How do you verify the number of Databases running on a Host?
-
Truncate Vs Delete
If a table contains 2 million rows, consider the below scenarios?
- DELETE command to delete just few rows in a 2 million row table.
- TRUNCATE command (will obviously deletes 2 million rows)
Which is faster. Truncate or Delete? -
Tablespace Management Autoextend Option
Is it possible to autoextend on option for two datafiles of same tablespace? How?
-
-
Export and Import
What is the use of IGNORE option in the Export and Import?
-
-
Multiple Database access one Instance
Can Multiple Database access one Instance ?
Yes or No ? Explain -
PCT Increase Parameter
What is PCT increase parameter in segment?
-
Why we use Materialized view ?
If it reduce the traffic then please give an example for that one
-
Oracle Production support common issues ?
Hi I want to know what are thw common oracle production support issues that we face when we deal with banking domain and as general too.
Oracle Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans