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?
Latest Answer: To improve the performance we have to go for index searching. ...
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
Latest Answer: Gathering statistics can be very resource intensive for the server so avoid peak workload times to gather stale stats or Analyze Table . ...
How to check to memory gap once the SGA is started in Restricted mode?
If the SQL * Plus hangs for a long time, what is the reason?
How do you increase the performance of %LIKE operator?
Explain Dual table. Is any data internally stored 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;
Latest Answer: Dual is a system owned table created during database creation. Dual table consist of a single column and a single row with value xWe will not get any error if we execute select sysdate from scott.emp Instead sysdate will be treated as a psudo column ...
In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it?
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like Schema A. Schema B executed the procedure like inserting some records. In this case where
Latest Answer: Procedure will be executed with the authority of A and therfore data will go to the tables owned by A. If one wants the data to go to B, use the clause authid current_user while defining the procedure. ...
If the entire disk is corrupted how will you recover the database and what are the steps to recover the database?
Latest Answer: Succesful backup is possible iff there is "Archive Mode" is on.that is database is in Archive Mode.and if it's offthen there are only 99.9% chancesthroughGroup1 or Group2 of Online Redo log files. ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
