What Types of Questions Are Included?
DBExam works in a single question family — multiple choice — in two shapes. A single-answer item wants exactly one option; a multiple-response item wants every correct option and no wrong one, and that second shape is scored all or nothing: one tick short or one tick spare and the whole item falls to zero. There is no partial credit, no typed code, and no live database behind any of it.
What is there to separate? The shapes a multiple-choice item takes, and the boundary that keeps every item a matter of choosing — even when the Oracle topic underneath is thoroughly hands-on.
Single-Answer and Multiple-Response Oracle Items
A single-answer item hands you a set of options where one is right, and the work is reading the requirement closely enough to rule the others out. A multiple-response item states how many to pick and expects them all: asked which two properties let a PL/SQL function back a function-based index, you would need both — that it is declared DETERMINISTIC and that it returns the same result for the same inputs — and nothing else selected. The grading on that shape is unforgiving. Getting three of four right earns exactly what a blank earns, because there is no partial credit and no near miss to reward; a single wrong or missing tick zeroes the item, precisely as the real Oracle paper scores it.
Why an Oracle Item Never Opens a Live SQL Prompt
You reach every answer by selecting one, never by typing it. DBExam opens no SQL*Plus or SQL Developer session, connects you to no running database, and sets no free-text code exercise or hands-on lab — those live with the Oracle vendor exams and with real practice systems, not with this platform. What an item does instead is stage the judgement that such work turns on: it may print a finished block, a query plan or a configuration and ask what results, so you rehearse the call without the keyboard. The reasoning is the part that travels to exam day, and the multiple-choice frame is what carries it there.
So the whole toolkit is two shapes of one format — a single-answer question and a multiple-response question marked all or nothing — and no keyboard anywhere in either. It is a deliberately tight frame, pointed straight at the decisions an Oracle exam makes you commit to under time.
