What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
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
1/2
Page
Pick an option on a question to see the right answer and solution.
Which statement about sequences is not true?
Select an option to see the answer and solution.
Which prefixes are available to Oracle triggers?
Select an option to see the answer and solution.
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Select an option to see the answer and solution.
Which of the following is not true about indexes?
Select an option to see the answer and solution.
Which of the following is not true of SQL views?
Select an option to see the answer and solution.
SQL*Plus will finish the statement and execute it when the user types in this:
Select an option to see the answer and solution.
Which of the following is NOT an Oracle-supported trigger?
Select an option to see the answer and solution.
After a table has been created, its structure can be modified using the SQL command:
Select an option to see the answer and solution.
Which of the following is not true about modifying table columns?
Select an option to see the answer and solution.
Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Select an option to see the answer and solution.
What Oracle backup and recover file contains user and system data?
Select an option to see the answer and solution.
When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
Select an option to see the answer and solution.
Which SQL phrase is not supported by Oracle?
Select an option to see the answer and solution.
What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Select an option to see the answer and solution.
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
Select an option to see the answer and solution.
The default extension for an Oracle SQL*Plus file is:
Select an option to see the answer and solution.
An Oracle System Change Number (SCN):
Select an option to see the answer and solution.
To obtain the structure of an Oracle table, the command to use is:
Select an option to see the answer and solution.
To see the contents of the SQL*Plus buffer, type:
Select an option to see the answer and solution.