If the entire disk is corrupted how will you recover the database and what are the steps to recover the database?
Latest Answer: Succesful backup is possible iff there is "Archive Mode" is on.that is database is in Archive Mode.and if it's offthen there are only 99.9% chancesthroughGroup1 or Group2 of Online Redo log files. ...
There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What
Latest Answer: in full table scan, if another user updates the value for a given row does not affect the full table scan if the user finishes the update by the time the oracle reads that particular record will get updated value otherwise it has the old value. ...
A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota
Latest Answer: Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored.
SQL> create user test identified by test1;
User created.
SQL> grant connect, resource to test;
Grant succeeded.
SQL> select * from ...
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No-Archive log mode. How can the database be recovered?
How to estimate the size of SGA?
What do you do when the server cannot start due to a corrupt master database?
What will you do when the ASE server's performance is bad?
Explain how will you setup Replication Server & sync it?
What do you do when tempdb is full?
How to load data into multiple tables at once?
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
