Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old :new only Both :new and :old :old only Neither :new nor :old :new only Both :new and :old :old only 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 Full backup Differential backup Consistent backup Inconsistent backup Full backup Differential backup ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? AFTER INSTEAD OF DURING BEFORE AFTER INSTEAD OF DURING BEFORE ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? 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. NextVal and CurrVal are both sequence methods. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The semicolon terminates a SQL statement (and executes it). True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle When you type into SQL*Plus and press enter, the statement will be finished and executed. True False True False ANSWER DOWNLOAD EXAMIANS APP