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