What is cold backup ? What are the elements of it ?
Answer / chaudhry
Cold backup is taking backup of all physical files after
normal shutdown of database. We need to take.
- All Data files.
- All Control files.
- All on-line redo log files.
- The init.ora file (Optional)
Is This Answer Correct ? | 5 Yes | 1 No |
Define b-trees.
Which database is good for large data?
What is the structure of a table in database?
Which is the best free database software?
What are the steps in creating a database?
What do you understand by unique key?
What is metadata and why should I use it?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What do you mean by starvation in dbms?
What is write ahead logging in DBMS?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What are the Different Types of Joins and How do They Work?