Home/Database/Managing Databases with Oracle

Managing Databases with Oracle MCQs

41 questionsDatabasePage 1 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 1medium

What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

⚑ Report ✎ Feedback

Question 2easy

Which statement about sequences is not true?

⚑ Report ✎ Feedback

Question 3easy

Which prefixes are available to Oracle triggers?

⚑ Report ✎ Feedback

Question 4hard

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

⚑ Report ✎ Feedback

Question 5easy

Which of the following is not true about indexes?

⚑ Report ✎ Feedback

Question 6medium

Which of the following is not true of SQL views?

⚑ Report ✎ Feedback

Question 7hard

SQL*Plus will finish the statement and execute it when the user types in this:

⚑ Report ✎ Feedback

Question 8easy

Which of the following is NOT an Oracle-supported trigger?

⚑ Report ✎ Feedback

Question 9hard

After a table has been created, its structure can be modified using the SQL command:

⚑ Report ✎ Feedback