Managing Databases with Oracle Which prefixes are available to Oracle triggers? :new only Both :new and :old :old only Neither :new nor :old :new only Both :new and :old :old only Neither :new nor :old 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 What Oracle backup and recover file contains user and system data? Offline ReDo file Datafile Control file OnLine ReDo file Offline ReDo file Datafile Control file OnLine ReDo file ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles? Differential backup Inconsistent backup Full backup Consistent backup Differential backup Inconsistent backup Full backup Consistent backup ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? INSTEAD OF BEFORE AFTER DURING INSTEAD OF BEFORE AFTER DURING ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To obtain the structure of an Oracle table, the command to use is: DESC TABLE [TableName]. DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. STRUCTURE [TableName]. DESC TABLE [TableName]. DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. STRUCTURE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS