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 ON UPDATE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON DELETE CASCADE ON UPDATE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ANSWER DOWNLOAD EXAMIANS APP
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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): is a value that is incremented whenever database changes are made. is a value that keeps track of explicit locks. is incremented whenever a deadlock occurs. is a value that is incremented whenever a dirty read occurs. is a value that is incremented whenever database changes are made. is a value that keeps track of explicit locks. is incremented whenever a deadlock occurs. is a value that is incremented whenever a dirty read occurs. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Sequences guarantee valid surrogate key values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS