⟩ Explain what is OLTP data modelling?
☛ OLTP stands for online transactional processing.
☛ Data models are constructed for transactions is called OLTP data modelling.
☛ OLTP stands for online transactional processing.
☛ Data models are constructed for transactions is called OLTP data modelling.
What does a Control file Contain?
Where in the Oracle directory tree structure are audit traces placed?
Explain the use of table functions.
What are the system resources that can be controlled through Profile?
Name three advisory statistics you can collect.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the use of ANALYZE command?
What command would you use to encrypt a PL/SQL application?
How would you determine the time zone under which a database was operating?
Explain the use of setting GLOBAL_NAMES equal to TRUE.