MCQs on Jira Query Language (JQL) | Jira MCQs Question Answers

Jira Query Language (JQL) is a powerful tool used to search and manage issues within Jira. Mastering JQL can streamline project management by allowing advanced queries, creating filters, and automating tasks for reporting. This quiz will test your knowledge of writing basic and advanced JQL queries, using filters, and leveraging JQL for reporting.

MCQs on Jira Query Language (JQL)

Writing Basic and Advanced JQL Queries

1. What does the following JQL query do? project = "Software" AND status = "Open"
   a) Returns all issues in the Software project that are open
   b) Returns all issues in the Software project regardless of their status
   c) Returns issues with a status of “Open”
   d) Returns issues from any project that are open
2. Which keyword is used to fetch issues assigned to a particular user in JQL?
   a) user
   b) assignee
   c) assigned
   d) owner
3. In JQL, which operator is used to find issues created before a specific date?
   a) >=
   b) <
   c) !=
   d) before
4. How can you find issues that have been updated within the last 7 days in JQL?
   a) updated >= -7d
   b) updated = -7d
   c) updated <= 7d
   d) updated <= -7d
5. What is the function of the OR operator in a JQL query?
   a) It allows searching issues with multiple statuses
   b) It helps to find issues assigned to multiple users
   c) It joins multiple conditions to narrow down results
   d) It retrieves only issues that match all conditions
6. Which of the following is the correct way to find issues that were resolved in the last week?
   a) resolved >= -1w
   b) resolved = -1w
   c) resolved <= -1w
   d) resolved within -1w
7. How do you specify a JQL query to return issues with a specific priority?
   a) priority = High
   b) priority = "High"
   c) priority = "High Priority"
   d) priority == High
8. In JQL, what does the function issuetype in ("Bug", "Story") return?
   a) Issues of the type “Bug” and “Story”
   b) Issues with a bug priority
   c) All issues excluding “Bug” and “Story” types
   d) Only “Story” issues
9. Which of the following operators can be used in JQL to match issues by a list of values?
   a) IN
   b) BETWEEN
   c) LIKE
   d) IS
10. Which of these is a valid JQL function to search for issues reported by a specific user?
    a) reporter = "John Doe"
    b) createdBy = "John Doe"
    c) reportedBy = "John Doe"
    d) submitter = "John Doe"

Using Filters and Automation with JQL

11. How can you save the result of a JQL query for future use?
    a) Create a custom dashboard
    b) Create a filter
    c) Create an issue type
    d) Create a new project
12. What is the benefit of using JQL filters in automation rules?
    a) Automating user permission settings
    b) Automating issue resolutions
    c) Automating notifications and transitions
    d) Automating project creation
13. How do you share a saved filter with other users in Jira?
    a) Go to filter settings and select “Share”
    b) Send the filter link manually
    c) Export the filter as a CSV file
    d) Filters are always public
14. Which Jira user permissions are required to create a filter?
    a) Project Admin
    b) Jira Admin
    c) Browse Projects permission
    d) View Issues permission
15. Which keyword in JQL can be used to check for issues with no assignee?
    a) assignee is EMPTY
    b) assignee = NULL
    c) assignee NOT IN ("")
    d) assignee = "Unassigned"
16. How can JQL be used to automate assigning issues to specific users?
    a) Set up an Automation Rule based on a filter
    b) Use the Bulk Edit feature
    c) Write a script for issue assignment
    d) Set up an approval workflow
17. Which type of automation rule can use JQL to trigger actions?
    a) Issue Created
    b) Issue Updated
    c) Custom Rule
    d) All of the above
18. In Jira, which feature allows you to trigger actions based on JQL queries and conditions?
    a) Automation for Jira
    b) Issue Transition Rules
    c) Workflow Schemes
    d) Permission Schemes
19. How do you trigger a JQL-based filter in Jira automation to send notifications?
    a) Use JQL as a trigger condition for actions
    b) Use a condition in the workflow
    c) Use an event-based rule
    d) Set the filter as the project lead
20. What is the function of the Jira Automation Rules in relation to JQL?
    a) It allows running queries manually
    b) It automatically runs queries and triggers actions
    c) It sends email notifications based on queries
    d) It creates new issues automatically

Leveraging JQL for Reporting

21. How can you create a JQL report for issues assigned to a user in the last 30 days?
    a) assignee = "John Doe" AND created >= -30d
    b) assignee = "John Doe" AND updated >= -30d
    c) assignee = "John Doe" AND createdDate >= -30d
    d) assignee = "John Doe" AND resolved >= -30d
22. Which of the following does a JQL-based report for issues in a project with status “Done” provide?
    a) Issues from the selected project that are completed
    b) Issues from any project marked as done
    c) Unresolved issues from the selected project
    d) Pending tasks from the project
23. How can you generate a report of issues based on a custom field in JQL?
    a) customfield_12345 = value
    b) field = "custom field"
    c) customfield_12345 IN ("value")
    d) field = custom field
24. What is a benefit of using JQL filters for generating custom reports in Jira?
    a) Reports can be exported as CSV files
    b) Reports automatically refresh with real-time data
    c) Reports can be customized based on user roles
    d) All of the above
25. How can you use JQL to generate a report for high-priority unresolved issues?
    a) priority = High AND status != Resolved
    b) priority = High AND resolution = NULL
    c) priority = High AND status = Open
    d) priority = High AND resolved = NULL
26. What type of data can you extract using JQL for reporting purposes?
    a) Issue status
    b) Issue history
    c) Issue comments
    d) All of the above
27. How can JQL-based reports help in visualizing project progress?
    a) Through the creation of dashboards
    b) By generating detailed issue timelines
    c) By categorizing issues by priority
    d) All of the above
28. What is a common use case for JQL filters in reporting?
    a) Tracking overdue tasks
    b) Monitoring team performance
    c) Visualizing open versus closed issues
    d) All of the above
29. Which JQL query would show all issues that were resolved this week?
    a) resolved >= startOfWeek()
    b) resolved = -7d
    c) resolved <= startOfWeek()
    d) resolved >= endOfWeek()
30. How can you use JQL to create reports based on issue comments?
    a) comment ~ "keyword"
    b) comment = "keyword"
    c) comments = "keyword"
    d) comment contains "keyword"

Answer Key