|
Related Questions |
View Answer |
|
Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why
|
View Answer
|
|
How can you see the source code of the package
|
View Answer
|
|
You are regularly changing the package body part. How will you create or what will you do before creating that package
|
View Answer
|
|
How do you increase the performance of %LIKE operator
|
View Answer
|
|
Shall we create procedures to fetch more than one record
|
View Answer
|
|
If the SQL * Plus hangs for a long time, what is the reason
|
View Answer
|
|
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP
|
View Answer
|
|
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why
|
View Answer
|
|
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan
|
View Answer
|
|
What are the differences between database designing and database modeling
|
View Answer
|
|
What are the differences you have seen while installing Oracle on NT and Unix platform
|
View Answer
|
|
How to do the scheduled task/jobs in Unix platform
|
View Answer
|
|
What is bulk SQL
|
View Answer
|
|
If the entire disk is corrupted how will you and what are the steps to recover the database
|
View Answer
|