Managing Databases with Oracle Which prefixes are available to Oracle triggers? :new only Neither :new nor :old Both :new and :old :old only :new only Neither :new nor :old Both :new and :old :old only 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 colon ( : ) followed by [Enter]. A period ( . ) followed by [Enter]. A left slash ( ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A colon ( : ) followed by [Enter]. A period ( . ) followed by [Enter]. A left slash ( ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What Oracle backup and recover file contains user and system data? Control file Offline ReDo file OnLine ReDo file Datafile Control file Offline ReDo file OnLine ReDo file Datafile 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 Instance Failure Rollback failure Application failure Media Failure Instance Failure Rollback failure Application failure ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle You can use the DROP statement to remove structures from the database. 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. True False True False ANSWER DOWNLOAD EXAMIANS APP