1Z0-149 series practice examsIn development
Oracle Database 23ai Administration Associate
The go-forward administration entry for the 23ai generation: instance against database and what each background process does, the tablespace, segment, extent and block hierarchy, and startup stages that locate a failure before any log is read; then users, privileges and profiles under least privilege, undo and the snapshot too old error, listener diagnosis, and the 23ai additions including JSON Relational Duality and vector search.
What you get
Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.
What the exam covers
| Architecture, instance and storage structures | Not published |
| Administration, security, networking and 23ai features | Not published |
Two sample questions
1. Which file on the client maps a name to a connection descriptor?
- tnsnames.ora — correct
- listener.ora, which configures the listener
- sqlnet.ora, which sets the protocol options
- init.ora, which sets the instance parameters
Why: Easy connect syntax avoids it entirely for a simple connection.
2. What does NOMOUNT read?
- The control file next
- The datafiles and redo
- The parameter file — correct
- The listener naming file
Why: At NOMOUNT the instance starts by reading only the parameter file.
The real 1Z0-149 series exam
| Length | 90 minutes |
|---|---|
| Questions | 60 |
| Pass mark | Around 60%, published per exam version by Oracle |
| Price | Purchased per attempt through Oracle University |
| Recommended before you sit it | None enforced. SQL knowledge is assumed. |
| Valid for | Does not expire, though it is tied to the release examined |
Exam facts as published by Oracle; always check the vendor’s page before you book.
Study 1Z0-149 series with Chiron
Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.