Managing Databases with Oracle Oracle allows the ORDER BY clause in view definitions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To see the contents of the SQL*Plus buffer, type: LIST CURRENT BUFFER CONTENTS LIST CURRENT BUFFER CONTENTS ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is NOT an Oracle-supported trigger? AFTER DURING INSTEAD OF BEFORE AFTER DURING INSTEAD OF BEFORE 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. Using the Oracle Database Configuration Assistant. None of these Using the Oracle-supplied database creation procedures. Using the SQL CREATE DATABASE command. Using the Oracle Database Configuration Assistant. None of these ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? Sequences guarantee valid surrogate key values. Sequences are most often used to provide values for surrogate keys. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. Sequences guarantee valid surrogate key values. Sequences are most often used to provide values for surrogate keys. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is not true of SQL views? The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views cannot use the ORDER BY clause in view definitions. Oracle views can by queried. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views cannot use the ORDER BY clause in view definitions. Oracle views can by queried. ANSWER DOWNLOAD EXAMIANS APP