If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
Name three advisory statistics you can collect.
how can you record information about current session?
how can you connect from 10g user to 11g user??
what are the types of connection load-balancing?
deleted of control file how will u recover control file?
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
what are the benefits of flashback feature?
how will u see whether the dabase is in archive log mode or not?
Why would you call update statistics? : sql server DBA
What is dcl? : sql server DBA
How to make a replica of existing oracle server to another server?
How would you go about generating an EXPLAIN plan?