Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old :new only :old only Both :new and :old Neither :new nor :old :new only :old only Both :new and :old ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. Sequences guarantee valid surrogate key values. Sequences are most often used to provide values for surrogate keys. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. Sequences guarantee valid surrogate key values. Sequences are most often used to provide values for surrogate keys. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle When you type Start FILENAME, the statement in your file will be executed automatically. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Rollback failure Application failure Media Failure Instance Failure Rollback failure Application failure Media Failure Instance Failure ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles? Consistent backup Inconsistent backup Differential backup Full backup Consistent backup Inconsistent backup Differential backup Full backup ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS