Managing Databases with Oracle Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? Both :new and :old :new only :old only Neither :new nor :old Both :new and :old :new only :old only Neither :new nor :old ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle SQL*Plus will finish the statement and execute it when the user types in this: 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]. A semicolon ( ; ) followed by [Enter]. A period ( . ) followed by [Enter]. A colon ( : ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What Oracle backup and recover file contains user and system data? OnLine ReDo file Datafile Offline ReDo file Control file OnLine ReDo file Datafile Offline ReDo file Control file 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 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
EXAMIANS