Managing Databases with Oracle The only time that case matters is inside quotation marks of strings. True False True False 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? Full backup Differential backup Consistent backup Inconsistent backup Full backup Differential backup Consistent backup Inconsistent backup ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: CHANGE TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. 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 Media Failure Instance Failure Rollback failure Application failure Media Failure Instance Failure Rollback failure ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? CREATE SEQUENCE [SequenceName] ON DELETE CASCADE DROP SEQUENCE [SequenceName] ON UPDATE CASCADE CREATE SEQUENCE [SequenceName] ON DELETE CASCADE DROP SEQUENCE [SequenceName] ON UPDATE CASCADE ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle allows the ORDER BY clause in view definitions. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS