Exam 1z0-062 topic 1 question 281 discussion

Actual exam question from Oracle's 1z0-062

Question #: 281
Topic #: 1

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command:

SQL> STARTUP UPGRADE -
Which three statements are true about the upgrade process? (Choose three.)

A. All system triggers are disabled during the upgrade process.
B. Only queries on fixed views execute without errors until you run the catctl.pl script.
C. The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command.
D. All job queues remain active during the upgrade process.
E. Only connections AS SYSDBA are allowed during the upgrade process.

Show Suggested Answer

Suggested Answer: ADE 🗳️

by rdnkrkmz at Jan. 23, 2019, 1:44 p.m.

Comments

Submit Cancel

rdnkrkmz

Highly Voted 5 years, 10 months ago

I think it should by ABE (D is incorrect)

upvoted 8 times

...

Answer: ABE – https://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE – https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52867 – You wouldn’t want to set the COMPATIBLE parameter to 12.1.0 so early because you wouldn’t be able to downgrade the database back to its original version if you find problems after the upgrade.

upvoted 8 times

...

dfabac

Most Recent 2 years, 6 months ago

Selected Answer: ABE

Answer is ABE D is incorrect: "In a job definition, if ALLOW_RUNS_IN_RESTRICTED_MODE is set to TRUE, the job is permitted to run when the database is in restricted or upgrade mode, provided that the job owner is permitted to log in during this mode. The default setting is FALSE."

upvoted 1 times

...

Ray520

2 years, 6 months ago

Selected Answer: ABD

STARTUP UPGRADE: Restricts logons to AS SYSDBA sessions. Disables system triggers. Once the database is started in upgrade mode, only queries on fixed views execute without errors until after the catctl.pl script is run. The COMPATIBLE initialization parameter should be set to a value eual or more than 11.0.0.

upvoted 2 times

...

Muhammadnagah

5 years, 1 month ago

A,B,E are true for D check the following upgrade error WWU-00009: The DBMS job queue was disabled. There were jobs that would have run immediately if it were enabled. Cause: Jobs submitted for the current repository may not run properly under the upgraded version. Action: You have two options: 1. Remove the jobs from the queue. 2. Re-enable the job queue by raising the job_queue_processes database parameter to a value greater than 0, and allow the jobs to complete. For a list of all jobs, look under the "Analyze Product Schema" step in the upgrade log

upvoted 3 times

...

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam