Structured Query Language used to manipulate the data with help of queries. The SQL uses some operators to throw queries like SELECT uses to selects a data value and shown on the output screen, Where uses for c
The checkpoint and data recovery: Recording the checkpoint is important for recovery purposes. The checkpoint identifies the first redo log entry that Oracle will need to process in a recovery situation. All changes related to previous redo log entries have been written to the disk. Checkpoint Proc...
Explain with examples what is meant by lossy decomposition and how this problem can be avoided in DBMS. Virtualization is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources. What is datab...
SYS@prima >alter database datafile 4 online;alter database datafile 4 online * ERROR at line 1: ORA-01113: file 4 needs media recovery ORA-01110: data file 4: '/u01/app/oracle/oradata/prima/users01.dbf' SYS@prima >recover datafile 4;Media recovery complete. SYS@prima >alter database ...