Why would you call update statistics? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
Give the reasoning behind using an index.
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is ora 24313?what is the procedure to exclude that error?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Which environment variables are absolutely critical in order to run the OUI?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
What is the difference between clustered and non-clustered index? : sql server DBA
WHEN DOWN TIME WHAT CAN U DO?
how can you find out if a table can be redefined?
Compare and contrast TRUNCATE and DELETE for a table.
how can you communicate with operating system files from oracle?