Managing Databases with Oracle The default extension for an Oracle SQL*Plus file is: .ora .pls .txt .sql .ora .pls .txt .sql 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
Managing Databases with Oracle Which prefixes are available to Oracle triggers? :new only :old only Both :new and :old Neither :new nor :old :new only :old only Both :new and :old Neither :new nor :old 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 You can check on the status of tables with the DESCRIBE or DESC command. True False True False 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