Free Oracle AI Database Administration Professional Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Oracle AI Database Administration Professional practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1When a CREATE PLUGGABLE DATABASE statement specifies both FILE_NAME_CONVERT and CREATE_FILE_DEST, which setting determines the placement of files copied during PDB creation?

   1. A.FILE_NAME_CONVERTCorrect answer: A
   2. B.CREATE_FILE_DEST
   3. C.DB_CREATE_FILE_DEST in the root
   4. D.PDB_FILE_NAME_CONVERT

   Explanation: Oracle states: "In addition, if FILE_NAME_CONVERT and CREATE_FILE_DEST are both specified in the CREATE PLUGGABLE DATABASE statement, then the FILE_NAME_CONVERT setting is used for the files being placed during PDB creation, and the CREATE_FILE_DEST setting is used to set the DB_CREATE_FILE_DEST initialization parameter in the PDB." The clause controls the initial placement, while CREATE_FILE_DEST sets the PDB parameter.

   Reference: Oracle Multitenant Administrator’s Guide: Overview of PDB Creation — PDB File Locations

2. 2Which RMAN command enables automatic control file and server parameter file backups?

   1. A.CONFIGURE CONTROLFILE AUTOBACKUP ONCorrect answer: A
   2. B.CONFIGURE BACKUP OPTIMIZATION ON
   3. C.CONFIGURE RETENTION POLICY TO NONE
   4. D.CONFIGURE DEFAULT DEVICE TYPE TO DISK

   Explanation: Oracle states: "To enable the autobackup feature: CONFIGURE CONTROLFILE AUTOBACKUP ON;" This supports the indicated RMAN behavior.

   Reference: Oracle Backup and Recovery User’s Guide: Configuring the RMAN Environment — 5.6 Configuring Control File and Server Parameter File Autobackups

3. 3Which components are aggregated to calculate Oracle database time?

   1. A.CPU and non-idle wait time of foreground sessionsCorrect answer: A
   2. B.Only elapsed wall-clock time since startup
   3. C.Only CPU time of background processes
   4. D.Idle waits of every database session

   Explanation: Oracle states: "DB time is measured cumulatively from the time of instance startup and is calculated by aggregating the CPU and wait times of all foreground sessions not waiting on idle wait events (non-idle user sessions)." This supports the interpretation described.

   Reference: Oracle Database Performance Tuning Guide: Measuring Database Performance — Time Model Statistics

4. 4For an image-based Grid Infrastructure installation on Linux, where should the image be extracted?

   1. A.Into the newly created Grid homeCorrect answer: A
   2. B.Into the existing database's data file directory
   3. C.Into a temporary staging directory outside the intended Grid home
   4. D.Into the fast recovery area

   Explanation: Oracle states: "To install Oracle Grid Infrastructure, create the new Grid home with the necessary user group permissions, and then extract the image file into the newly-created Grid home, and run the setup wizard to register the Oracle Grid Infrastructure product." This establishes the specified procedure or condition.

   Reference: Oracle Database Installation Guide for Linux: Image-Based Grid Infrastructure Installation — About Image-Based Oracle Grid Infrastructure Installation

5. 5Which description identifies the structure of an HNSW vector index?

   1. A.Use an in-memory neighbor graph for approximate similarity searchCorrect answer: A
   2. B.Use neighbor partitions to narrow the similarity search
   3. C.Use an ordinary B-tree keyed by exact vector equality
   4. D.Scan vectors without an index or neighbor graph

   Explanation: Oracle states: "A Hierarchical Navigable Small World Graph (HNSW) is a form of In-Memory Neighbor Graph vector index." This describes the relevant vector behavior.

   Reference: Oracle AI Vector Search User’s Guide: Optimizer Plans for Vector Indexes — Optimizer Plans for HNSW Vector Indexes

6. 6A DBA wants a new PDB to use Oracle Managed Files with its own default directory independent of the root. Which CREATE PLUGGABLE DATABASE clause serves this purpose?

   1. A.FILE_NAME_CONVERT
   2. B.CREATE_FILE_DESTCorrect answer: B
   3. C.PATH_PREFIX
   4. D.SERVICE_NAME_CONVERT

   Explanation: Oracle states: "The CREATE_FILE_DEST clause of the CREATE PLUGGABLE DATABASE statement enables Oracle Managed Files for the PDB and specifies the default file system directory or Oracle ASM disk group for the PDB files." The clause establishes the PDB's managed-files destination; the others govern name conversion or path restrictions.

   Reference: Oracle Multitenant Administrator’s Guide: Overview of PDB Creation — CREATE_FILE_DEST Clause

7. 7Which RMAN command displays the current backup optimization setting?

   1. A.SHOW RETENTION POLICY
   2. B.SHOW BACKUP OPTIMIZATIONCorrect answer: B
   3. C.SHOW ARCHIVELOG DELETION POLICY
   4. D.SHOW DEFAULT DEVICE TYPE

   Explanation: Oracle states: "You can use the SHOW BACKUP OPTIMIZATION command to view the current settings of backup optimization." This supports the indicated RMAN behavior.

   Reference: Oracle Backup and Recovery User’s Guide: Configuring the RMAN Environment — 5.12.3 Configuring Backup Optimization

8. 8Why can cumulative DB time exceed elapsed time since instance startup?

   1. A.It sums only background CPU time across instances
   2. B.It sums time across multiple non-idle foreground sessionsCorrect answer: B
   3. C.It counts only one session at a time
   4. D.It adds idle wait time to the wall clock

   Explanation: Oracle states: "Because DB time is calculated by combining the times from all non-idle user foreground sessions, it is possible that the DB time can exceed the actual time elapsed after the instance started." This supports the interpretation described.

   Reference: Oracle Database Performance Tuning Guide: Measuring Database Performance — Time Model Statistics

9. 9On a standalone server, what must be installed before database files can be placed on Oracle ASM?

   1. A.Only a database home with no Grid Infrastructure
   2. B.Oracle Grid Infrastructure for a standalone serverCorrect answer: B
   3. C.Only a listener configured in the database home
   4. D.Only an ASM disk group created without installing Grid Infrastructure

   Explanation: Oracle states: "To install Oracle AI Database files on Oracle Automatic Storage Management (Oracle ASM), you must first complete an Oracle Grid Infrastructure for a standalone server installation." This establishes the specified procedure or condition.

   Reference: Oracle Database Installation Guide for Linux: Installing Oracle AI Database — Installing Oracle AI Database

10. 10How does an IVF vector index narrow the search?

    1. A.By traversing a multilayer neighbor graph
    2. B.By using neighbor partitions or clustersCorrect answer: B
    3. C.By selecting rows solely through keyword matching
    4. D.By probing every neighbor partition for every query

    Explanation: Oracle states: "Inverted File Flat (IVF) is a form of Neighbor Partition Vector index. It is a partition-based index that achieves search efficiency by narrowing the search area through the use of neighbor partitions or clusters." This describes the relevant vector behavior.

    Reference: Oracle AI Vector Search User’s Guide: Optimizer Plans for Vector Indexes — Optimizer Plans for IVF Vector Indexes