Home/Database/Managing Databases with Oracle

Managing Databases with Oracle MCQs

41 questionsDatabasePage 4 of 5

Practice free Managing Databases with Oracle multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 41 questions — no login required.

Question 28hard

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

⚑ Report ✎ Feedback

Question 29hard

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

⚑ Report ✎ Feedback

Question 30medium

Oracle directly supports the definition of surrogate keys.

⚑ Report ✎ Feedback

Question 31hard

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

⚑ Report ✎ Feedback

Question 32medium

Oracle allows the ORDER BY clause in view definitions.

⚑ Report ✎ Feedback

Question 33medium

Oracle does NOT support a CASCADE UPDATE constraint.

⚑ Report ✎ Feedback

Question 34medium

Sequences guarantee valid surrogate key values.

⚑ Report ✎ Feedback

Question 35easy

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

⚑ Report ✎ Feedback

Question 36hard

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

⚑ Report ✎ Feedback