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
Managing Databases with Oracle When using SQL*Plus, Oracle commands, column names, table names and all other database elements: are case sensitive. must always be in lower case. are case insensitive. must always be in upper case. are case sensitive. must always be in lower case. are case insensitive. must always be in upper case. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? BEFORE DURING INSTEAD OF AFTER BEFORE DURING INSTEAD OF AFTER ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle SQL*Plus will finish the statement and execute it when the user types in this: A semicolon ( ; ) followed by [Enter]. A period ( . ) followed by [Enter]. A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A period ( . ) followed by [Enter]. A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? ON DELETE CASCADE CREATE SEQUENCE [SequenceName] DROP SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE CREATE SEQUENCE [SequenceName] DROP SEQUENCE [SequenceName] ON UPDATE CASCADE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS