You can use the DROP statement to remove structures from the database. False True TRUE ANSWER : ? YOUR ANSWER : ?
What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Media Failure Instance Failure Rollback failure Application failure TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not true of SQL views? Oracle views are created using the standard SQL-92 CREATE VIEW command. Oracle views can by queried. 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. TRUE ANSWER : ? YOUR ANSWER : ?
When you type into SQL*Plus and press enter, the statement will be finished and executed. True False TRUE ANSWER : ? YOUR ANSWER : ?
Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad. False True TRUE ANSWER : ? YOUR ANSWER : ?
SQL*Plus will finish the statement and execute it when the user types in this: A period ( . ) followed by [Enter]. A semicolon ( ; ) followed by [Enter]. A colon ( : ) followed by [Enter]. A left slash ( ) followed by [Enter]. TRUE ANSWER : ? YOUR ANSWER : ?
Which prefixes are available to Oracle triggers? :old only Neither :new nor :old :new only Both :new and :old TRUE ANSWER : ? YOUR ANSWER : ?
An Oracle System Change Number (SCN): is incremented whenever a deadlock occurs. is a value that keeps track of explicit locks. is a value that is incremented whenever a dirty read occurs. is a value that is incremented whenever database changes are made. TRUE ANSWER : ? YOUR ANSWER : ?
When using SQL*Plus, Oracle commands, column names, table names and all other database elements: are case sensitive. must always be in lower case. are case insensitive. must always be in upper case. TRUE ANSWER : ? YOUR ANSWER : ?