When you type into SQL*Plus and press enter, the statement will be finished and executed. False True TRUE ANSWER : ? YOUR ANSWER : ?
Oracle directly supports the definition of surrogate keys. True False TRUE ANSWER : ? YOUR ANSWER : ?
To see the contents of the SQL*Plus buffer, type: CURRENT BUFFER LIST CONTENTS TRUE ANSWER : ? YOUR ANSWER : ?
You can check on the status of tables with the DESCRIBE or DESC command. False True TRUE ANSWER : ? YOUR ANSWER : ?
Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems. True False TRUE ANSWER : ? YOUR ANSWER : ?
Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. False True TRUE ANSWER : ? YOUR ANSWER : ?
An Oracle System Change Number (SCN): 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. is incremented whenever a deadlock occurs. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not true about modifying table columns? You can increase the number of characters in character columns or the number of digits in numeric columns You can drop a column at any time. You can add a column at any time as long as it is a NULL column. You cannot increase or decrease the number of decimal places. TRUE ANSWER : ? YOUR ANSWER : ?
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 TRUE ANSWER : ? YOUR ANSWER : ?