Latest Answer : in 10g there is a option to lock an acount we can lock system user through this correct me if i am wrong ...
What is the differences between DBMS & RDBMS? What is the differences between Oracle & MS Access?
How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?
what is Referential Backup? Which case we use Referential Backup and which case we use Incremental backup?
Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS?
Latest Answer : ofcourse Ascending ...
Latest Answer : In oracle 9i we have some limitation with reqard to Backing up entire dataabase in one go. First we will have to take the database in mount stage (not open) in order to take the back up, and that too, one tablespace at a time. like:-sql>alter ...
Can we read Control file? If yes, then how?
Latest Answer : Yes, We can read control filefirst we have to transfer it to text file.sql> alter database backup controlfile to trace,we can view the controlfile from user_dump_test. ...
What is mean by fractured block in terms of manual hot backup?
Latest Answer : The concept of fractured block occrus when backup is under process.It means you are taking backup and some other session is updating it.Then backup process can not get the consistent image of the block and it will be inconsistent right thats why it is ...
what are the necessary steps to be take when server gets down? How can we increase size of a database?
Latest Answer : 1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring up the listener. 6.Check whether the tablespace ...
