Managing Databases with Oracle Oracle commands, column names, table names, view names and all other database elements are case sensitive. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To see the contents of the SQL*Plus buffer, type: BUFFER LIST CURRENT CONTENTS BUFFER LIST CURRENT CONTENTS 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? Alter [FileName] Open [FileName] Edit [FileName] Show [FileName] Alter [FileName] Open [FileName] Edit [FileName] Show [FileName] ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? DROP SEQUENCE [SequenceName] ON DELETE CASCADE ON UPDATE CASCADE CREATE SEQUENCE [SequenceName] DROP SEQUENCE [SequenceName] ON DELETE CASCADE ON UPDATE CASCADE CREATE SEQUENCE [SequenceName] ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Sequences guarantee valid surrogate key values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle SQL*Plus will finish the statement and execute it when the user types in this: A colon ( : ) followed by [Enter]. A period ( . ) followed by [Enter]. A left slash ( ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A colon ( : ) followed by [Enter]. A period ( . ) followed by [Enter]. A left slash ( ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP