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 SQL*Plus will finish the statement and execute it when the user types in this: A period ( . ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. A period ( . ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle allows the ORDER BY clause in view definitions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: ALTER TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old :old only Both :new and :old :new only Neither :new nor :old :old only Both :new and :old :new only ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE DROP SEQUENCE [SequenceName] ON DELETE CASCADE CREATE SEQUENCE [SequenceName] ON UPDATE CASCADE DROP SEQUENCE [SequenceName] ON DELETE CASCADE ANSWER DOWNLOAD EXAMIANS APP