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 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 SQL*Plus will finish the statement and execute it when the user types in this: A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. A period ( . ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. A period ( . ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The semicolon terminates a SQL statement (and executes it). True False True False ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following is NOT an Oracle-supported trigger? AFTER BEFORE INSTEAD OF DURING AFTER BEFORE INSTEAD OF DURING ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS