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 To see the contents of the SQL*Plus buffer, type: CONTENTS CURRENT LIST BUFFER CONTENTS CURRENT LIST BUFFER ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle SQL*Plus is a text editor. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What Oracle backup and recover file contains user and system data? Offline ReDo file Control file OnLine ReDo file Datafile Offline ReDo file Control file OnLine ReDo file Datafile ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old :old only Both :new and :old :new only Neither :new nor :old :old only Both :new and :old :new only ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? 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. Sequences guarantee valid surrogate key values. A sequence is an object that generates a sequential series of unique numbers. ANSWER DOWNLOAD EXAMIANS APP