IPA IP 2025 Question 66
A question IPA Japan published in 令和7年度 ITパスポート試験 公開問題 問66, translated into English. ITPEC is based on the same exams.
In the “Login record” table and the “Department” table below that are managed in a relational database, which of the following lists all and only the names of the departments to which the employees belong who have had a login result of failure, or who have had a login result of success at or before 09:00:00 on April 10, 2022?
Login record
Department
Explanation
Sales, Systems and Personnel Departments — collect the rows that meet either condition, then look up their department numbers.
The condition is an OR of two parts: the login result is Failure (at any time), or the login result is Success at or before 09:00:00. Rows that qualify:
The success at 09:00:15 (10001) is after 09:00:00 and does not count, but department 001 still appears through the failure of 10011 at 10:00:02. The department numbers are 001, 002 and 003: Sales, Systems and Personnel Departments.
Answer (b)
Why not others:
- •(a) — leaves out the Personnel Department (003), which has failures at 08:50:42 and 09:39:22
- •(c) — leaves out the Systems Department (002), whose employee 10002 succeeded at 08:55:48
- •(d) — leaves out the Sales Department (001), whose employee 10011 failed at 10:00:02; only the late success of 10001 is excluded, not the department
Key rule: With OR, a row qualifies if either condition holds; check each condition over all rows before discarding a group.
Databases · AI-written, may contain errors
This question comes from the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.