Managing Databases with Oracle Which SQL phrase is not supported by Oracle? DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. is a value that keeps track of explicit locks. is a value that is incremented whenever a dirty read occurs. is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. is a value that keeps track of explicit locks. is a value that is incremented whenever a dirty read occurs. 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 prefixes are available to Oracle triggers? :old only Neither :new nor :old Both :new and :old :new only :old only Neither :new nor :old Both :new and :old :new only ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle When you type Start FILENAME, the statement in your file will be executed automatically. 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: CHANGE TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP