True Or False

Question 1 :

Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.


A). True
B). False
Answer : Option A

Question 2 :

Money is defined in Oracle with the Currency data type.


A). True
B). False
Answer : Option B

Question 3 :

The default extension for SQL*Plus is .sql.


A). True
B). False
Answer : Option A

Question 4 :

The left-leaning slash tells Oracle to execute whatever statement is in the buffer.


A). True
B). False
Answer : Option B

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.


A). True
B). False
Answer : Option A

Question 6 :

The semicolon terminates a SQL statement (and executes it).


A). True
B). False
Answer : Option A

Question 7 :

SQL*Plus is a text editor.


A). True
B). False
Answer : Option A

Question 8 :

When you type Start FILENAME, the statement in your file will be executed automatically.


A). True
B). False
Answer : Option A

Question 9 :

You can check on the status of tables with the DESCRIBE or DESC command.


A). True
B). False
Answer : Option A

Question 10 :

Oracle directly supports the definition of surrogate keys.


A). True
B). False
Answer : Option B

Question 11 :

When you type into SQL*Plus and press enter, the statement will be finished and executed.


A). True
B). False
Answer : Option B

Question 12 :

Oracle allows the ORDER BY clause in view definitions.


A). True
B). False
Answer : Option A

Question 13 :

Oracle does NOT support a CASCADE UPDATE constraint.


A). True
B). False
Answer : Option A

Question 14 :

Sequences guarantee valid surrogate key values.


A). True
B). False
Answer : Option B

Question 15 :

Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.


A). True
B). False
Answer : Option B

Question 16 :

Oracle commands, column names, table names, view names and all other database elements are case sensitive.


A). True
B). False
Answer : Option B

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.


A). True
B). False
Answer : Option A

Question 18 :

The only time that case matters is inside quotation marks of strings.


A). True
B). False
Answer : Option A

Question 19 :

You can use the DROP statement to remove structures from the database.


A). True
B). False
Answer : Option A

Question 20 :

Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.


A). True
B). False
Answer : Option A