1Z0-183 Oracle AI Database Administration Professional Practice Questions
Prepare for 1Z0-183 with more than an answer.
- Exam fee
- $245 USD
- Level
- Professional
- Valid for
- Certain Oracle Database Credentials require periodic recertification (per Oracle Certification Program Guidelines). Check Oracle's recertification policy for the most current requirements.
Domains covered on the exam 5
- Managing Multitenant Architecture20%
- Performing Backup and Recovery20%
- Managing and Tuning Performance25%
- Deploying, Patching and Upgrades15%
- New Feature in Oracle AI Database20%
- 1
You are implementing a security strategy for a multitenant environment. You need to restrict the privileges of a common user
C##ADMINwhen they connect to a specific PDBHR_PDB. The user should not be able to executeALTER SYSTEMcommands within that PDB, even though they have the privilege granted commonly. Which feature should you use?Show answer details
Correct answer: A
Lockdown Profiles allow you to restrict operations that are otherwise allowed by privileges. By creating a lockdown profile that disables
ALTER SYSTEMand applying it toHR_PDB, you can restrict the common user's ability to perform that action within that specific PDB scope, regardless of their granted privileges. - 2
A financial application requires an immutable audit trail of all transactions. You have been asked to implement a table where rows can be inserted but never updated or deleted by any user, including administrators, for a retention period of 5 years. Which Oracle 23ai feature satisfies this requirement?
Show answer details
Correct answer: A
Blockchain Tables are specialized append-only tables that provide cryptographic chaining of rows. Rows inserted into a blockchain table are tamper-proof; they cannot be updated or deleted (until the retention period expires, if configured). This ensures an immutable audit trail required for compliance.
- 3
You need to clone a remote PDB
SRC_PDBto a new PDBTGT_PDBin a different CDB. The source PDB is large (5 TB), and you want to minimize the downtime and network traffic. You have decided to use the 'remote cloning' feature. Which pre-requisite must be met regarding the database link used for this operation?Show answer details
Correct answer: A
For remote PDB cloning, you create a database link in the target CDB pointing to the source CDB. The user defined in the dblink must have sufficient privileges in the source (like
CREATE PLUGGABLE DATABASEorSYSOPER) to read the data files. The link connects TO the source FROM the target. - 4
A developer wants to bridge the gap between relational data and JSON documents. They want to expose a set of relational tables (Orders, Items, Products) as a single JSON document for an application API, while allowing the application to update the JSON document and have those updates automatically reflected in the underlying relational tables. Which Oracle 23ai feature enables this?
Show answer details
Correct answer: A
JSON Relational Duality Views allow data to be stored in highly efficient relational tables but accessed and modified as JSON documents. The database handles the mapping, allowing 'duality'—the same data is both relational and JSON. Updates to the view are ACID-compliant updates to the underlying tables.
- 5
A multinational financial organization uses a Container Database (CDB) named
FINCDBwith 50 Pluggable Databases (PDBs). The architecture team wants to implement a standardized schema and application logic updates across 15 specific PDBs used by the European division. These PDBs must share common database objects while maintaining their own unique data. Updates to the common objects should be propagated centrally. Which architectural component should you implement to meet these requirements with minimal administrative overhead?Show answer details
Correct answer: A
An Application Container consists of an Application Root and one or more Application PDBs. This architecture allows for the definition of a master application definition (metadata and common data) in the Application Root, which is then shared with the Application PDBs. This is the exact use case for sharing logic and schema while keeping data separate and managing updates centrally.
- 6
You are the Senior DBA for a healthcare provider running Oracle Database 23ai. You need to configure a new backup strategy for a mission-critical PDB named
PATIENTS. The requirements state that you must be able to recover the PDB to any point in time within the last 30 days, and you must minimize the backup window. You decide to use RMAN with Block Change Tracking (BCT). Where must the Block Change Tracking file be enabled?Show answer details
Correct answer: A
In a Multitenant architecture, the Block Change Tracking (BCT) file is a global resource managed at the Container Database (CDB) level. It tracks changes for the entire CDB, including all PDBs. You cannot enable BCT for an individual PDB; it must be enabled on the CDB root using
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING.
