Managing Databases with Oracle Which prefixes are available to Oracle triggers? :new only Neither :new nor :old :old only Both :new and :old :new only Neither :new nor :old :old only Both :new and :old ANSWER DOWNLOAD EXAMIANS APP
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? CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE DROP SEQUENCE [SequenceName] ON DELETE CASCADE CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE DROP SEQUENCE [SequenceName] ON DELETE CASCADE ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Media Failure Application failure Instance Failure Rollback failure Media Failure Application failure Instance Failure Rollback failure ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle directly supports the definition of surrogate keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): 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. is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS