⟩ Can I use Fortran/C/Python/Visual Basic?
You can provide SWIG wrappers for the parts of your program you need to access.
You can provide SWIG wrappers for the parts of your program you need to access.
What is a Sequence?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What type of index should you use on a fact table?
What is a Segment?
Give the two types of tables involved in producing a star schema and the type of data they hold.
Give the reasoning behind using an index.
Compare and contrast TRUNCATE and DELETE for a table.
What view would you use to determine free space in a tablespace?
What view would you use to look at the size of a data file?