How will you find out if your database is using recovery catalog or not?
How will you determine the number of connections connected to your database?
Latest Answer: Use any one of the below commands to show the userssql>show users; orsql>desc dba_users; ...
What will happen in database if your like hard disk crashes & what will be your next step to recover that database?
A Database is running in NoArchiveLog mode then which type of backups you can take?
Latest Answer: If your database is in NOARCHIVELOG mode, then the only type of backups that you should perform are closed, consistent (COLD BACKUP), whole database backups. The files in this type of backup are all consistent and do not need recovery, so the online logs ...
What is the effect on database at the time of total power failure when an UPDATE query is under execution in Oracle 9i?
Latest Answer: When the power failure occurs while an update statement is running. When the database is restarted it does an automatic recovery, when it finds the update statements pending, it performs a rollback of the update statement.Regards-Ram ...
What are the steps required to enable the RMAN backup for a target database?
Latest Answer: Open a RMAN session and connect with target database, if you follow standalone command method just issue BACKUP DATABASE command its allocates channel and do the backup, but if you follow batch command method to do sort of jobs in one issue then you ...
In Oracle RAC 3-node environment, If one node is down then how will the sessions balance among the remaining two nodes?
What is High Water Mark in Oracle?
Latest Answer: The High Watermark is the maximum fill-grade a table has ever reached. The blocks above high water mark are empty blocks.Initially when you create a table the high water mark is the first block. When you insert rows on the table the high water mark increases ...
If we are running in NOARCHIVELOG mode and my all redo log files are full and data is still not committed by the current session. What activity will Oracle perform and what will happen with the un-comitted
Latest Answer: NONARCHIVE log will Protect the DB from Instence faliure but not from Media failure.The Redo files will be covered until the last backup taken , but after that all uncommited datae will be lost for the period (after the last backup) taken. ...
Why the Standard Oracle supplied JDBC driver cannot be used when using a Real Application Cluster?Decribe the differences between an Oracle Real Application Cluster and Oracle Deployed in a Sun Cluster?
View page [1] 2 3 4 5 6 7 Next >>
Go Top
