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 a system database and what is a user database? : sql server DBA
how can you communicate with operating system files from oracle?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what is a crs resource?
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.
What would you do with an "in-doubt" distributed transaction?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What authentication modes does sql server support? : sql server DBA
Query processing is slow(eg select query)how will u solve that
how can you generate profile of pl/sql applications to identify performance bottlenecks?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is a correlated sub-query? : sql server DBA
Explain materialized views and how they are used.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?