Managing Databases with Oracle In creating a procedure, you may get a message if you have compile errors. Which of the following is true? To see the errors, enter SHOW ERRORS in SQL*Plus. The line numbers reported match the line numbers you see in your text editor. SQL*Plus will automatically show the errors to you. If there are no syntax errors, you will receive the message "NO ERRORS." To see the errors, enter SHOW ERRORS in SQL*Plus. The line numbers reported match the line numbers you see in your text editor. SQL*Plus will automatically show the errors to you. If there are no syntax errors, you will receive the message "NO ERRORS." 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 semicolon ( ; ) followed by [Enter]. A period ( . ) followed by [Enter]. A left slash ( ) followed by [Enter]. A colon ( : ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A period ( . ) followed by [Enter]. A left slash ( ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: UPDATE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. 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 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] Open [FileName] Edit [FileName] Alter [FileName] Show [FileName] Open [FileName] Edit [FileName] ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle You can use the DROP statement to remove structures from the database. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS