Managing Databases with Oracle An Oracle System Change Number (SCN): is a value that is incremented whenever database changes are made. is a value that is incremented whenever a dirty read occurs. is a value that keeps track of explicit locks. is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. is a value that is incremented whenever a dirty read occurs. is a value that keeps track of explicit locks. is incremented whenever a deadlock occurs. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle directly supports the definition of surrogate keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Of the three ways to create an Oracle database, which one is the easiest and most recommended? Using the Oracle-supplied database creation procedures. Using the SQL CREATE DATABASE command. None of these Using the Oracle Database Configuration Assistant. Using the Oracle-supplied database creation procedures. Using the SQL CREATE DATABASE command. None of these Using the Oracle Database Configuration Assistant. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? DROP SEQUENCE [SequenceName] ON DELETE CASCADE ON UPDATE CASCADE CREATE SEQUENCE [SequenceName] DROP SEQUENCE [SequenceName] ON DELETE CASCADE ON UPDATE CASCADE CREATE SEQUENCE [SequenceName] ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle You can check on the status of tables with the DESCRIBE or DESC command. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? DURING BEFORE INSTEAD OF AFTER DURING BEFORE INSTEAD OF AFTER ANSWER DOWNLOAD EXAMIANS APP