Question 1 of 30
A database administrator is analyzing the execution plan for a query that joins two tables, $A$ and $B$. Table $A$ has an estimated row count of $N_A = 1000$, and table $B$ has an estimated row count of $N_B = 500$. If the execution plan indicates a nested loop join, what is the estimated cost of this operation based on the formula for nested loop joins?
$501000$
$1000 + 250000$
$1000 + 1000 \times 500$
$1000 + 500 + 1000 \times 500$

Preparing for Oracle Database 23ai Administration Associate? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free