Managing Databases with Oracle If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old :old only :new only Both :new and :old Neither :new nor :old :old only :new only Both :new and :old ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle When you type Start FILENAME, the statement in your file will be executed automatically. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle allows the ORDER BY clause in view definitions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? 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. A sequence is an object that generates a sequential series of unique numbers. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS