Managing Databases with Oracle Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? 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. 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. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Sequences guarantee valid surrogate key values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is not true of SQL views? Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views can by queried. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Oracle views cannot use the ORDER BY clause in view definitions. Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views can by queried. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Oracle views cannot use the ORDER BY clause in view definitions. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle commands, column names, table names, view names and all other database elements are case sensitive. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS