Exercise : Managing Databases with Oracle MCQ Questions and Answers
Question 1
Which schema does this window group reside?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. sys
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
To create a cluster index, one of the following conditions must be true?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Both 1) & 2)
Description :
No answer description available for this question. Let us discuss.
Question 3
What are the elements of the redo log buffer and Shared pool?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. SGA
Description :
No answer description available for this question. Let us discuss.
Question 4
Which view would you query at this stage to investigate this missing control file?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. V$CONTROLFILE
Description :
No answer description available for this question. Let us discuss.
Question 5
What is an executable SQL statement?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Statement that generates calls to an instance, including DML and DDL statements.
Description :
No answer description available for this question. Let us discuss.
Question 6
Which of the following is not true about modifying table columns?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. You cannot increase or decrease the number of decimal places.
Description :
No answer description available for this question. Let us discuss.
Question 7
Which tables in the Tables schema cannot be redefined?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Both SYS & SYSTEM
Description :
No answer description available for this question. Let us discuss.
Question 8
Which statement about sequences is not true?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Sequences guarantee valid surrogate key values.
Description :
No answer description available for this question. Let us discuss.
Question 9
A synonym is an alias for which object?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Schema
Description :
No answer description available for this question. Let us discuss.
Question 10
What is the use of Library cache?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Used to store shared SQL
Description :
No answer description available for this question. Let us discuss.