Answer Posted / amsu
ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
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
what is the use of recording information about current session?
how to restore files with rman?
What purpose does the model database server? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What the different types of replication and why are they used? : sql server DBA
Where would you look for errors from the database engine?
internal architecture
how can you initialize log miner?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
. 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?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what functionality does oracle provide to secure sensitive information?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit