Managing Databases with Oracle Which SQL phrase is not supported by Oracle? ON DELETE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE ON DELETE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE 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? Consistent backup Full backup Inconsistent backup Differential backup Consistent backup Full backup Inconsistent backup Differential backup ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To obtain the structure of an Oracle table, the command to use is: DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. STRUCTURE [TableName]. DESC TABLE [TableName]. DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. STRUCTURE [TableName]. DESC TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To see the contents of the SQL*Plus buffer, type: CONTENTS CURRENT BUFFER LIST CONTENTS CURRENT BUFFER LIST ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? INSTEAD OF AFTER BEFORE DURING INSTEAD OF AFTER BEFORE DURING ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle commands, column names, table names, view names and all other database elements are case sensitive. False True False True ANSWER DOWNLOAD EXAMIANS APP