Managing Databases with Oracle Which prefixes are available to Oracle triggers? Both :new and :old :new only Neither :new nor :old :old only Both :new and :old :new only Neither :new nor :old :old only ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The left-leaning slash tells Oracle to execute whatever statement is in the buffer. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use? Show [FileName] Open [FileName] Alter [FileName] Edit [FileName] Show [FileName] Open [FileName] Alter [FileName] Edit [FileName] 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? Rollback failure Media Failure Application failure Instance Failure Rollback failure Media Failure Application failure Instance Failure 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 [TableName]. DESCRIBE STRUCTURE [TableName]. STRUCTURE [TableName]. DESC TABLE [TableName]. DESCRIBE [TableName]. DESCRIBE STRUCTURE [TableName]. STRUCTURE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle commands, column names, table names, view names and all other database elements are case sensitive. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS