Managing Databases with Oracle Oracle does NOT support a CASCADE UPDATE constraint. False True False True 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? Application failure Rollback failure Media Failure Instance Failure Application failure Rollback failure Media Failure Instance Failure ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The default extension for an Oracle SQL*Plus file is: .txt .pls .ora .sql .txt .pls .ora .sql ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: ALTER TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. 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 Inconsistent backup Differential backup Full backup Consistent backup Inconsistent backup Differential backup Full backup ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? Sequences guarantee valid surrogate key values. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. Sequences are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. Sequences are most often used to provide values for surrogate keys. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS