You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
Answer Posted / anonymous
Have to manually create a new control file.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What authentication modes does sql server support? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is a system database and what is a user database? : sql server DBA
Which autogrowth database setting is good? : 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.
What purpose does the model database server? : 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 high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?