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 Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle The semicolon terminates a SQL statement (and executes it). True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? Sequences guarantee valid surrogate key values. A sequence is an object that generates a sequential series of unique numbers. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. Sequences guarantee valid surrogate key values. A sequence is an object that generates a sequential series of unique numbers. NextVal and CurrVal are both sequence methods. Sequences are most often used to provide values for surrogate keys. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Of the three ways to create an Oracle database, which one is the easiest and most recommended? None of these Using the Oracle Database Configuration Assistant. Using the Oracle-supplied database creation procedures. Using the SQL CREATE DATABASE command. None of these Using the Oracle Database Configuration Assistant. Using the Oracle-supplied database creation procedures. Using the SQL CREATE DATABASE command. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which prefixes are available to Oracle triggers? :new only :old only Neither :new nor :old Both :new and :old :new only :old only Neither :new nor :old Both :new and :old ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS