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