Exercise : Managing Databases with Oracle MCQ Questions and Answers
Question 1
Which of the following is not true about indexes?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Indexes are created with the ALTER TABLE command.
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Which of the following is a collection of one or more replicated objects (typically tables) that are administrated together.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Replication group
Description :
No answer description available for this question. Let us discuss.
Question 3
In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be remove You execute the following command to achieve this objective.
DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;
What would be the result of this command?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. This command would result in an error because the disk group is not empty
Description :
No answer description available for this question. Let us discuss.
Question 4
Errors discovered during SQL statement execution cause
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. statement-level rollback
Description :
No answer description available for this question. Let us discuss.
Question 5
SQL*Plus will finish the statement and execute it when the user types in this:
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. A semicolon ( ; ) followed by [Enter].
Description :
No answer description available for this question. Let us discuss.
Question 6
For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest _________ .
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Prime Number
Description :
No answer description available for this question. Let us discuss.
Question 7
Oracle database's design is also called as -
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Database Schema
Description :
No answer description available for this question. Let us discuss.
Question 8
Which of the following scenarios ends an Oracle transaction?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. All of the mentioned
Description :
No answer description available for this question. Let us discuss.
Question 9
What do the schema objects comprise of?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. All of the Mentioned
Description :
No answer description available for this question. Let us discuss.
Question 10
Which of the following is not true about modifying table columns?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. You cannot increase or decrease the number of decimal places.
Description :
No answer description available for this question. Let us discuss.