Managing Databases with Oracle The default extension for an Oracle SQL*Plus file is: .sql .txt .pls .ora .sql .txt .pls .ora ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. UPDATE TABLE [TableName]. ALTER TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. UPDATE TABLE [TableName]. ALTER TABLE [TableName]. 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] Edit [FileName] Alter [FileName] Open [FileName] Show [FileName] Edit [FileName] Alter [FileName] Open [FileName] ANSWER DOWNLOAD EXAMIANS APP
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 Oracle directly supports the definition of surrogate keys. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What Oracle backup and recover file contains user and system data? OnLine ReDo file Offline ReDo file Datafile Control file OnLine ReDo file Offline ReDo file Datafile Control file ANSWER DOWNLOAD EXAMIANS APP