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 What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles? Inconsistent backup Full backup Differential backup Consistent backup Inconsistent backup Full backup Differential backup Consistent backup ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The semicolon terminates a SQL statement (and executes it). False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? Sequences are most often used to provide values for surrogate keys. A sequence is an object that generates a sequential series of unique numbers. NextVal and CurrVal are both sequence methods. Sequences guarantee valid surrogate key values. Sequences are most often used to provide values for surrogate keys. A sequence is an object that generates a sequential series of unique numbers. NextVal and CurrVal are both sequence methods. Sequences guarantee valid surrogate key values. ANSWER DOWNLOAD EXAMIANS APP
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 true of SQL views? 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. 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. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS