Oracle
1Z0-883 · Question #41
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?
The correct answer is B. Columns that are common to both versions of the table must be defined in the same order on the D. Columns that are common to both versions of the table must come first in the table definition, before. See the full explanation below for the reasoning.
Question
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?
Options
- AEach extra column in the copy with more columns must not have a default value.
- BColumns that are common to both versions of the table must be defined in the same order on the
- CThe slave database cannot have more columns than the master.
- DColumns that are common to both versions of the table must come first in the table definition, before
- EThe master database cannot have more columns than the slave.
How the community answered
(38 responses)- A13% (5)
- B74% (28)
- C5% (2)
- E8% (3)
Community Discussion
No community discussion yet for this question.