To obtain the structure of an Oracle table, the command to use is: DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. DESC TABLE [TableName]. STRUCTURE [TableName]. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not true about modifying table columns? You can drop a column at any time. You cannot increase or decrease the number of decimal places. You can add a column at any time as long as it is a NULL column. You can increase the number of characters in character columns or the number of digits in numeric columns TRUE ANSWER : ? YOUR ANSWER : ?
The only time that case matters is inside quotation marks of strings. 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 : ?
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 left slash ( ) followed by [Enter]. A colon ( : ) followed by [Enter]. 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 : ?
In creating a procedure, you may get a message if you have compile errors. Which of the following is true? If there are no syntax errors, you will receive the message "NO ERRORS." SQL*Plus will automatically show the errors to you. To see the errors, enter SHOW ERRORS in SQL*Plus. The line numbers reported match the line numbers you see in your text editor. TRUE ANSWER : ? YOUR ANSWER : ?