Managing Databases with Oracle To see the contents of the SQL*Plus buffer, type: BUFFER LIST CONTENTS CURRENT BUFFER LIST CONTENTS CURRENT 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 Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle An Oracle System Change Number (SCN): is a value that keeps track of explicit locks. is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. is a value that is incremented whenever a dirty read occurs. is a value that keeps track of explicit locks. is incremented whenever a deadlock occurs. is a value that is incremented whenever database changes are made. is a value that is incremented whenever a dirty read occurs. 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]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Media Failure Application failure Instance Failure Rollback failure Media Failure Application failure Instance Failure Rollback failure ANSWER DOWNLOAD EXAMIANS APP