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
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is replication? : sql server DBA
how can you initialize log miner?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is the role of dip user in our database?
What would you do with an "in-doubt" distributed transaction?
what is the use of ocr?
What is the difference between clustered and non-clustered index? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).