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