Managing Databases with Oracle Which of the following is not true about modifying table columns? You can add a column at any time as long as it is a NULL column. You cannot increase or decrease the number of decimal places. You can drop a column at any time. You can increase the number of characters in character columns or the number of digits in numeric columns You can add a column at any time as long as it is a NULL column. You cannot increase or decrease the number of decimal places. You can drop a column at any time. You can increase the number of characters in character columns or the number of digits in numeric columns ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To obtain the structure of an Oracle table, the command to use is: DESCRIBE STRUCTURE [TableName]. DESC TABLE [TableName]. STRUCTURE [TableName]. DESCRIBE [TableName]. DESCRIBE STRUCTURE [TableName]. DESC TABLE [TableName]. STRUCTURE [TableName]. DESCRIBE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle directly supports the definition of surrogate keys. 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Money is defined in Oracle with the Currency data type. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? Both :new and :old :old only :new only Neither :new nor :old Both :new and :old :old only :new only Neither :new nor :old ANSWER DOWNLOAD EXAMIANS APP