Close
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

Search Current Affairs by date
Other Category List