Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old Both :new and :old :old only :new only Neither :new nor :old Both :new and :old :old only :new only ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle commands, column names, table names, view names and all other database elements are case sensitive. 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
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? AFTER BEFORE DURING INSTEAD OF AFTER BEFORE DURING INSTEAD OF ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle allows the ORDER BY clause in view definitions. False True False True 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 are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. Sequences are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. NextVal and CurrVal are both sequence methods. ANSWER DOWNLOAD EXAMIANS APP