How do you switch from an init.ora file to a spfile?
Answer Posted / ravindra
create pfile from spfile;
Is This Answer Correct ? | 2 Yes | 2 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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
internal architecture
How can you control the amount of free space in your index pages? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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
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 the default port no on which sql server listens? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what is the use of ocr?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you implement fine-grained auditing?
Query processing is slow(eg select query)how will u solve that