Managing Databases with Oracle Which prefixes are available to Oracle triggers? Neither :new nor :old Both :new and :old :old only :new only Neither :new nor :old Both :new and :old :old only :new only ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is not true about indexes? Indexes are created to enable fast retrieval by column values. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes. Indexes are created to enforce uniqueness on columns. Indexes are created with the ALTER TABLE command. Indexes are created to enable fast retrieval by column values. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes. Indexes are created to enforce uniqueness on columns. Indexes are created with the ALTER TABLE command. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle does NOT support a CASCADE UPDATE constraint. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What Oracle backup and recover file contains user and system data? Offline ReDo file OnLine ReDo file Datafile Control file Offline ReDo file OnLine ReDo file Datafile Control file ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To obtain the structure of an Oracle table, the command to use is: STRUCTURE [TableName]. DESCRIBE [TableName]. DESCRIBE STRUCTURE [TableName]. DESC TABLE [TableName]. STRUCTURE [TableName]. DESCRIBE [TableName]. DESCRIBE STRUCTURE [TableName]. DESC TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP