Oracle interview questions – page 45

1,328 questions. Tap “Show answer” to check yourself.

Give the reasoning behind using an index.
Compare and contrast TRUNCATE and DELETE for a table.
Where would you look for errors from the database engine?
Give two examples of how you might determine the structure of the table DEPT.
Explain the difference between a data block, an extent and a segment.
How do you switch from an init.ora file to a spfile?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
Explain the difference between a hot backup and a cold backup and the benefits associated with each.