Managing Databases with Oracle The default extension for an Oracle SQL*Plus file is: .txt .sql .pls .ora .txt .sql .pls .ora ANSWER DOWNLOAD EXAMIANS APP
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 You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use? Show [FileName] Alter [FileName] Edit [FileName] Open [FileName] Show [FileName] Alter [FileName] Edit [FileName] Open [FileName] 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 prefixes are available to Oracle triggers? :new only Both :new and :old Neither :new nor :old :old only :new only Both :new and :old Neither :new nor :old :old only 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. NextVal and CurrVal are both sequence methods. Sequences guarantee valid surrogate key values. A sequence is an object that generates a sequential series of unique numbers. Sequences are most often used to provide values for surrogate keys. NextVal and CurrVal are both sequence methods. Sequences guarantee valid surrogate key values. A sequence is an object that generates a sequential series of unique numbers. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS