What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Instance Failure Rollback failure Media Failure Application failure TRUE ANSWER : ? YOUR ANSWER : ?
You can use the DROP statement to remove structures from the database. True False TRUE ANSWER : ? YOUR ANSWER : ?
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use? Show [FileName] Open [FileName] Edit [FileName] Alter [FileName] TRUE ANSWER : ? YOUR ANSWER : ?
Which prefixes are available to Oracle triggers? Both :new and :old Neither :new nor :old :new only :old only TRUE ANSWER : ? YOUR ANSWER : ?
SQL*Plus will finish the statement and execute it when the user types in this: A left slash ( ) followed by [Enter]. A period ( . ) followed by [Enter]. A colon ( : ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not true of SQL views? The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Oracle views cannot use the ORDER BY clause in view definitions. Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views can by queried. TRUE ANSWER : ? YOUR ANSWER : ?
Of the three ways to create an Oracle database, which one is the easiest and most recommended? Using the SQL CREATE DATABASE command. Using the Oracle-supplied database creation procedures. Using the Oracle Database Configuration Assistant. None of these TRUE ANSWER : ? YOUR ANSWER : ?
The default extension for an Oracle SQL*Plus file is: .sql .txt .ora .pls TRUE ANSWER : ? YOUR ANSWER : ?