Give the stages of instance startup to a usable state where
normal users may access it.
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
How can you gather statistics on a table?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Why does Oracle not permit the use of PCTUSED with indexes?
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 questions might be they ask in managerial round in capgemini.
What is the difference between Datapump & export/import?
what functionality does oracle provide to secure sensitive information?
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
by issuing "alter tablespace begin backup;" what happens to tablespace?
Explain what partitioning is and what its benefit is.