Exercise : Managing Databases with Oracle MCQ Questions and Answers
Question 1
In the error Logging Table format, which set of columns contain data from the row that caused the error and the column names match the column names from the table being inserted into (the "DML table")?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Optional set
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
In Oracle, which of below are types of segments?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Data Segment
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 3
What do you mean by Quiescence?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Act of suspending DML activity for all tables in a given replication group
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 4
The disks in a disk group are referred to as ASM disks on Windows operating systems an ASM disk is always a partition, on all other platforms an ASM disk can be _________.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Both 1) & 2)
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 5
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.
View Answer
50/50
Workspace
Report
Discuss
Question 6
Which DBA System Privilege used for the operations authorized for drops a table in any schema?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. DROP ANY TABLE
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 7
Which of the following is / are DML Statements?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Both Insert and Update
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 8
Single-table hash cluster, provides fast access to rows in a table and this table must be the only table in the hash cluster. Essentially, there must be which mapping between hash keys and data rows?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. One-to-one mapping
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 9
Which Shutdown Mode in the ASM instance immediately shuts down without the orderly dismount of disk groups?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. ABORT
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 10
How many types of database links does the oracle database lets you create?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. 3
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss