Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? DURING INSTEAD OF BEFORE AFTER DURING INSTEAD OF BEFORE AFTER 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 Differential backup Inconsistent backup Consistent backup Full backup Differential backup Inconsistent backup 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
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
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