Exercise : Managing Databases with Oracle MCQ Questions and Answers
Question 1
Which parameter uses all MANDATORY destinations plus some number of non-standby OPTIONAL destinations to determine whether LGWR can overwrite the online log?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. LOG_ARCHIVE_MIN_SUCCEED_DEST=n
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Abbreviate the term DBCA?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Database Configuration Assistant
Description :
No answer description available for this question. Let us discuss.
Question 3
SQL*Plus will finish the statement and execute it when the user types in this:
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. A semicolon ( ; ) followed by [Enter].
Description :
No answer description available for this question. Let us discuss.
Question 4
What do the schema objects comprise of?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. All of the Mentioned
Description :
No answer description available for this question. Let us discuss.
Question 5
When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. are case insensitive.
Description :
No answer description available for this question. Let us discuss.
Question 6
To ensure that a transaction does not hang if it cannot obtain a lock, which of the following statements below should be executed?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. FOR UPDATE ... NOWAIT
Description :
No answer description available for this question. Let us discuss.
Question 7
In ________ type of link users connect as themselves. This means that they must have an account on the remote database with the same username as their account on the local database.
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Connected user link
Description :
No answer description available for this question. Let us discuss.
Question 8
Using PL/SQL Packages to Display Information About Schema Object Space Usage which Returns information about free data blocks in an object (table, index, or cluster) whose segment space management is AUTO?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. DBMS_SPACE.SPACE_USAGE
Description :
No answer description available for this question. Let us discuss.
Question 9
Which of the following is not true of SQL views?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Oracle views cannot use the ORDER BY clause in view definitions.
Description :
No answer description available for this question. Let us discuss.
Question 10
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.