Managing Databases with Oracle Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? 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. Sequences are most often used to provide values for surrogate keys. A sequence is an object that generates a sequential series of unique numbers. 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 The only time that case matters is inside quotation marks of strings. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): 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. 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. is a value that keeps track of explicit locks. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle When you type Start FILENAME, the statement in your file will be executed automatically. True False True False ANSWER DOWNLOAD EXAMIANS APP