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? Alter [FileName] Show [FileName] Edit [FileName] Open [FileName] Alter [FileName] Show [FileName] Edit [FileName] Open [FileName] ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The default extension for an Oracle SQL*Plus file is: .txt .ora .pls .sql .txt .ora .pls .sql ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): is incremented whenever a deadlock occurs. is a value that keeps track of explicit locks. is a value that is incremented whenever a dirty read occurs. is a value that is incremented whenever database changes are made. is incremented whenever a deadlock occurs. is a value that keeps track of explicit locks. is a value that is incremented whenever a dirty read occurs. is a value that is incremented whenever database changes are made. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To obtain the structure of an Oracle table, the command to use is: STRUCTURE [TableName]. DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. DESC TABLE [TableName]. STRUCTURE [TableName]. DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. DESC TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To see the contents of the SQL*Plus buffer, type: CONTENTS CURRENT BUFFER LIST CONTENTS CURRENT BUFFER LIST ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS