Managing Databases with Oracle Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): is a value that is incremented whenever a dirty read occurs. is incremented whenever a deadlock occurs. is a value that keeps track of explicit locks. is a value that is incremented whenever database changes are made. is a value that is incremented whenever a dirty read occurs. is incremented whenever a deadlock occurs. is a value that keeps track of explicit locks. is a value that is incremented whenever database changes are made. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle You can use the DROP statement to remove structures from the database. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle does NOT support a CASCADE UPDATE constraint. 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: ALTER TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS