Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) What are snapshots? What are materialized views & where do we use them? What is a materialized view?
1Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
532What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
547If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
548Which is the best option used to move database from one server to another serve on same network and why?
511What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
611
what is the use of system.effective.date variable in oracle?
what are basic modules required to implement oracle application in any oraganisation?
How can we generate report output in excel format?
Which is the best option used to move database from one server to another serve on same network and why?
If you are working Microsoft excel, which type of file you used .excel or .csv?
What is coalesce function?
What if your ocr (oracle cluster registry) is corrupted?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are functions of dba?
Difference between oracle's plus (+) notation and ansi join notation?
How to build data dictionary view an new database?
Can we store images in oracle database?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What are the execution control statements?
What is the volume management techniques used in oracle rac?