Managing Databases with Oracle The default extension for an Oracle SQL*Plus file is: .sql .ora .txt .pls .sql .ora .txt .pls ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To see the contents of the SQL*Plus buffer, type: CONTENTS LIST BUFFER CURRENT CONTENTS LIST BUFFER CURRENT ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): is incremented whenever a deadlock occurs. is a value that is incremented whenever a dirty read occurs. is a value that keeps track of explicit locks. is a value that is incremented whenever database changes are made. is incremented whenever a deadlock occurs. is a value that is incremented whenever a dirty read occurs. is a value that keeps track of explicit locks. is a value that is incremented whenever database changes are made. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. ALTER TABLE [TableName]. MODIFY TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. ALTER TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is not true of SQL views? Oracle views can by queried. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views cannot use the ORDER BY clause in view definitions. Oracle views can by queried. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views cannot use the ORDER BY clause in view definitions. ANSWER DOWNLOAD EXAMIANS APP
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
EXAMIANS