Managing Databases with Oracle Which prefixes are available to Oracle triggers? :new only Both :new and :old Neither :new nor :old :old only :new only Both :new and :old Neither :new nor :old :old only ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To see the contents of the SQL*Plus buffer, type: BUFFER LIST CURRENT CONTENTS BUFFER LIST CURRENT CONTENTS 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. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. A sequence is an object that generates a sequential series of unique numbers. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle In creating a procedure, you may get a message if you have compile errors. Which of the following is true? If there are no syntax errors, you will receive the message "NO ERRORS." To see the errors, enter SHOW ERRORS in SQL*Plus. The line numbers reported match the line numbers you see in your text editor. SQL*Plus will automatically show the errors to you. If there are no syntax errors, you will receive the message "NO ERRORS." To see the errors, enter SHOW ERRORS in SQL*Plus. The line numbers reported match the line numbers you see in your text editor. SQL*Plus will automatically show the errors to you. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle does NOT support a CASCADE UPDATE constraint. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? CREATE SEQUENCE [SequenceName] DROP SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE CREATE SEQUENCE [SequenceName] DROP SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS