Managing Databases with Oracle The only time that case matters is inside quotation marks of strings. False True False True 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 SQL*Plus will finish the statement and execute it when the user types in this: A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A period ( . ) followed by [Enter]. A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A period ( . ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle You can check on the status of tables with the DESCRIBE or DESC command. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same. True False True False 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]. CHANGE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP