ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam
Go to Exam

Exam 1z0-083 topic 1 question 35 discussion

Actual exam question from Oracle's 1z0-083
Question #: 35
Topic #: 1
[All 1z0-083 Questions]

Examine this configuration:
1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEED is open READ ONLY
3. PDB1 is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

  • A. CDB1, PDB$SEED, PDB1, and PDB2
  • B. PDB$SEED, PDB1, and PDB2 only
  • C. CDB1 and PDB$SEED only
  • D. CDB1, PDB1, and PDB2 only
  • E. CDB1, PDB$SEED, and PDB1 only
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by veginha at June 26, 2020, 1:56 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
janw
Highly Voted 3 years, 5 months ago
e correct! For multitenant architecture (CDB and PDB) upgrades, open up all the PDBs that you want the tool to analyze before you run the tool.
upvoted 12 times
Alejandrrro
2 years, 11 months ago
Agree with you. Also tested in my database: [oracle@apex tmp]$ $ORA-CLE_HOME/jdk/bin/java -jar preupgrade.jar TERMINAL TEXT INFORMATION - Container: XEPDB2 is in: MOUNTED status and will not be processed unless opened.
upvoted 1 times
...
...
marcinb32
Highly Voted 3 years, 7 months ago
E is correct https://docs.oracle.com/en/database/oracle/oracle-database/18/spmsu/running-pre-upgrade-information-tool-for-non-cdb-checks.html#GUID-B04CDE73-45F1-4717-98BB-9FCC209DEC01
upvoted 5 times
...
Alvinzzz
Most Recent 7 months, 1 week ago
I think all of them are wrong as PDB$SEED is not open for generate access or modification, preupgrade.jar cannot directly generate fixup script for it. But from the answers above, E is the most correct answer although it includes PDB$SEED. A, B & D must be wrong as PDB2 is wrong.
upvoted 1 times
Guhborges
6 months, 1 week ago
E correct. The script will not perform a change, but will fetch information.
upvoted 1 times
...
...
ScottL
9 months, 1 week ago
Selected Answer: E
E correct
upvoted 1 times
...
_gio_
9 months, 2 weeks ago
Selected Answer: E
i think e
upvoted 1 times
...
vkra
11 months, 3 weeks ago
Selected Answer: E
E is correct
upvoted 1 times
...
ObserverPL
2 years, 8 months ago
I agree, E
upvoted 5 times
...
veginha
3 years, 7 months ago
i think E is correct, right?
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago