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. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. A sequence is an object that generates a sequential series of unique numbers. Sequences guarantee valid surrogate key values. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. 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 SQL phrase is not supported by Oracle? ON DELETE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The only time that case matters is inside quotation marks of strings. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle When using SQL*Plus, Oracle commands, column names, table names and all other database elements: are case sensitive. must always be in upper case. must always be in lower case. are case insensitive. are case sensitive. must always be in upper case. must always be in lower case. are case insensitive. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? :old only Both :new and :old Neither :new nor :old :new only :old only Both :new and :old Neither :new nor :old :new only ANSWER DOWNLOAD EXAMIANS APP