What are the steps involved in Instance Recovery ?
Answer / guest
Rolling forward to recover data that has not been recorded
in data files, yet has been recorded in the on-line redo
log, including the contents of rollback segments.
Rolling back transactions that have been explicitly rolled
back or have not been committed as indicated by the rollback
segments regenerated in step a.
Releasing any resources (locks) held by transactions in
process at the time of the failure.
Resolving any pending distributed transactions
undergoing a two-phase commit at the time of the instance
failure.
| Is This Answer Correct ? | 4 Yes | 4 No |
How rdbms is different from dbms?
Explain the Importance of Data Normalization.
What file is read by ODBC to load drivers ?
What is domain in dbms?
Why its better to use files than a DBMS when there are multiple users to access the data
What is normalisation and its type?
HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.
Is it possible to Disable the Parameter form while running the report ?
hi, i am new to database cau give me link where can i get about databse..
Explain the term ‘relations’?
write a query to retrieve the last day of next month in oracle.
What are the four objects in a database?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)