1Z0-183 by Oracle Valid Free Exam Practice Test

Question 1

What occurs when you execute the ALTER PLUGGABLE DATABASE pdb1 OPEN command without specifying any additional clauses?

A. The PDB opens only for read-only transactions and remains in that mode permanently B. The PDB opens in read-write mode and remains open permanently C. The PDB cannot open unless an instance parameter is modified D. The PDB opens in read-write mode but returns to MOUNT state on CDB restart

Correct Answer: D

Question 2

Which two actions are required to enable the In-Memory Column Store?
(Choose two)

A. Mark objects with the INMEMORY attribute B. Disable redo log archiving C. Enable DB_CACHE_SIZE to maximum D. Set the INMEMORY_SIZE initialization parameter

Correct Answer: A,D

Question 3

Which two actions help troubleshoot slow RMAN backups?
(Choose two)

A. Reduce the number of channels to a single stream B. Review RMAN backup compression settings C. Check I/O bottlenecks on backup destinations D. Disable block change tracking

Correct Answer: B,C

Question 4

Which two elements are part of a sound backup strategy?
(Choose two)

A. Retaining copies of control file and SPFILE backups B. Automating archive log deletion without verification C. Testing recovery scenarios periodically D. Storing all backups on the same server as the database

Correct Answer: A,C

Question 5

Which two tuning actions help reduce SQL execution cost?
(Choose two)

A. Disable SQL plan baselines B. Gather optimizer statistics regularly C. Disable adaptive query optimization D. Use bind variables instead of literals

Correct Answer: B,D

Question 6

Which tool is recommended for pre-upgrade checks before upgrading to Oracle Database 23ai?

A. SQL*Loader B. LogMiner C. AutoUpgrade utility D. RMAN Validate

Correct Answer: C

Question 7

Which two steps are mandatory when transporting tablespaces across platforms with different endian formats?
(Choose two)

A. Make tablespaces READ ONLY before backup B. Recreate redo log files on target platform C. Use RMAN CONVERT TABLESPACE to transform datafiles D. Export/import the control file with Data Pump

Correct Answer: A,C

Question 8

What happens to existing ASM disk groups during a Grid Infrastructure upgrade?

A. They remain intact and are compatible with the new release once upgraded B. They are automatically dropped and recreated C. They require manual migration to new disks D. They are converted to local file systems temporarily

Correct Answer: A

Oracle AI Database Administration Professional - 1Z0-183 Exam Practice Test