Which SQL phrase is not supported by Oracle? ON UPDATE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON DELETE CASCADE TRUE ANSWER : ? YOUR ANSWER : ?
An Oracle System Change Number (SCN): is a value that keeps track of explicit locks. is incremented whenever a deadlock occurs. is a value that is incremented whenever a dirty read occurs. is a value that is incremented whenever database changes are made. TRUE ANSWER : ? YOUR ANSWER : ?
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. TRUE ANSWER : ? YOUR ANSWER : ?
After a table has been created, its structure can be modified using the SQL command: UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. TRUE ANSWER : ? YOUR ANSWER : ?
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 ANSWER : ? YOUR ANSWER : ?
Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems. True False TRUE ANSWER : ? YOUR ANSWER : ?
What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles? Full backup Consistent backup Inconsistent backup Differential backup TRUE ANSWER : ? YOUR ANSWER : ?