Managing Databases with Oracle Questions

• Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
• The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
• Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
• Money is defined in Oracle with the Currency data type.
• Oracle commands, column names, table names, view names and all other database elements are case sensitive.
• When you type Start FILENAME, the statement in your file will be executed automatically.
• If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
• The only time that case matters is inside quotation marks of strings.
• Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
• Oracle does NOT support a CASCADE UPDATE constraint.
• You can use the DROP statement to remove structures from the database.
• SQL*Plus is a text editor.
• When you type into SQL*Plus and press enter, the statement will be finished and executed.
• Oracle directly supports the definition of surrogate keys.
• Sequences guarantee valid surrogate key values.
• Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.
• You can check on the status of tables with the DESCRIBE or DESC command.
• Oracle allows the ORDER BY clause in view definitions.
• The semicolon terminates a SQL statement (and executes it).
• The default extension for SQL*Plus is .sql.