Managing Databases with Oracle The default extension for SQL*Plus is .sql. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? DURING AFTER BEFORE INSTEAD OF DURING AFTER BEFORE INSTEAD OF 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? Differential backup Full backup Inconsistent backup Consistent backup Differential backup Full backup Inconsistent backup Consistent backup ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): is a value that keeps track of explicit locks. is a value that is incremented whenever a dirty read occurs. is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. is a value that keeps track of explicit locks. is a value that is incremented whenever a dirty read occurs. is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? A sequence is an object that generates a sequential series of unique numbers. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. A sequence is an object that generates a sequential series of unique numbers. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. 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
EXAMIANS