Managing Databases with Oracle The left-leaning slash tells Oracle to execute whatever statement is in the buffer. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? DROP SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE CREATE SEQUENCE [SequenceName] DROP SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE CREATE SEQUENCE [SequenceName] 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 Sequences guarantee valid surrogate key values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: ALTER TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old :old only Both :new and :old :new only Neither :new nor :old :old only Both :new and :old :new only ANSWER DOWNLOAD EXAMIANS APP