Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
In an Access select query, which criterion entered under a Status field returns only records whose Status value is exactly "Pending"?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• ="Pending" tests the Status field for an exact text match with Pending.
• Like "*Pending*" can also match values containing additional text before or after Pending, so it is broader than an exact-match condition.
• Not "Pending" excludes Pending, while Is Null finds records where no value is stored.
• Like "*Pending*" can also match values containing additional text before or after Pending, so it is broader than an exact-match condition.
• Not "Pending" excludes Pending, while Is Null finds records where no value is stored.
వివరణ:
Question 2
ప్రశ్న 2
A query must retrieve records where an Amount field is less than or equal to 1000. Which criterion is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The <= operator means less than or equal to.
• Therefore <=1000 includes values below 1000 as well as the boundary value 1000.
• <1000 would exclude records whose Amount is exactly 1000.
• Therefore <=1000 includes values below 1000 as well as the boundary value 1000.
• <1000 would exclude records whose Amount is exactly 1000.
వివరణ:
Question 3
ప్రశ్న 3
An Age field must be restricted in a query to values from 18 through 60, including both boundary values. Which criterion is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Between 18 And 60 selects values within the specified range.
• Access includes both endpoints when Between...And is used in this way.
• Therefore ages 18 and 60, as well as all qualifying values between them, are included.
• Access includes both endpoints when Between...And is used in this way.
• Therefore ages 18 and 60, as well as all qualifying values between them, are included.
వివరణ:
Question 4
ప్రశ్న 4
A Contact table contains an Email field. Which query criterion retrieves only records where no Email value has been entered?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Is Null tests specifically for the absence of a value in the field.
• It is the appropriate criterion for finding records where Email has not been entered and the field contains Null.
• Is Not Null performs the opposite test and returns records containing a value.
• It is the appropriate criterion for finding records where Email has not been entered and the field contains Null.
• Is Not Null performs the opposite test and returns records containing a value.
వివరణ:
Question 5
ప్రశ్న 5
Which Access query criterion retrieves records where the OfficerID field contains a non-Null value?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Is Not Null tests whether a field contains a value rather than being Null.
• It is therefore appropriate for finding records where OfficerID has been supplied.
• Access uses Is Null and Is Not Null rather than ordinary equality operators for testing Null values.
• It is therefore appropriate for finding records where OfficerID has been supplied.
• Access uses Is Null and Is Not Null rather than ordinary equality operators for testing Null values.
వివరణ:
Question 6
ప్రశ్న 6
A query should return all records except those whose Status field is exactly "Closed". Which criterion is appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• is the not-equal comparison operator in Access expressions.
• "Closed" therefore excludes records whose Status value is exactly Closed.
• ="Closed" performs the opposite operation by selecting only Closed records.
• "Closed" therefore excludes records whose Status value is exactly Closed.
• ="Closed" performs the opposite operation by selecting only Closed records.
వివరణ:
Question 7
ప్రశ్న 7
Using the default ANSI-89 wildcard convention for ordinary Access .accdb databases, which criterion selects text values that begin with the letter R?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Under the default Access ANSI-89 wildcard convention, * represents zero or more characters.
• Like "R*" therefore requires R as the first character and permits any sequence of characters after it.
• Like "*R" instead matches values ending with R.
• Like "R*" therefore requires R as the first character and permits any sequence of characters after it.
• Like "*R" instead matches values ending with R.
వివరణ:
Question 8
ప్రశ్న 8
Using the default ANSI-89 wildcard convention in an Access .accdb database, which criterion selects place names that end with "pur"?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The leading * permits any sequence of characters before the required ending text.
• Like "*pur" therefore matches values whose final characters are pur.
• Like "pur*" performs the different task of finding values that begin with pur.
• Like "*pur" therefore matches values whose final characters are pur.
• Like "pur*" performs the different task of finding values that begin with pur.
వివరణ:
Question 9
ప్రశ్న 9
Using Access ANSI-89 wildcards, which criterion matches codes such as RA308021, RB308021 and RZ308021, where exactly one character may occur between R and 308021?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The ? wildcard represents exactly one character under the ANSI-89 wildcard convention.
• Like "R?308021" therefore requires R, followed by one arbitrary character, followed by 308021.
• The * wildcard could represent zero or many characters and would not enforce the exactly-one-character requirement.
• Like "R?308021" therefore requires R, followed by one arbitrary character, followed by 308021.
• The * wildcard could represent zero or many characters and would not enforce the exactly-one-character requirement.
వివరణ:
Question 10
ప్రశ్న 10
A District field must match any one of the three values Hyderabad, Warangal or Nizamabad. Which Access query criterion expresses this most directly?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The In operator tests whether a field value belongs to a specified set of values.
• In ("Hyderabad","Warangal","Nizamabad") returns a record when District equals any one of those three entries.
• It is more direct than writing several separate equality conditions joined by Or.
• In ("Hyderabad","Warangal","Nizamabad") returns a record when District equals any one of those three entries.
• It is more direct than writing several separate equality conditions joined by Or.
వివరణ:
Question 11
ప్రశ్న 11
Which criterion correctly represents the exact date 20 August 2026 in an Access Date/Time query criterion?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access date/time literals are enclosed in number-sign characters (#).
• #20-Aug-2026# is therefore interpreted as a Date/Time value rather than ordinary text.
• Quotation marks are primarily used for text strings, while square brackets normally identify field names or parameter prompts.
• #20-Aug-2026# is therefore interpreted as a Date/Time value rather than ordinary text.
• Quotation marks are primarily used for text strings, while square brackets normally identify field names or parameter prompts.
వివరణ:
Question 12
ప్రశ్న 12
A saved select query already returns many records. The user temporarily wants to display only records with Priority = "High" without changing the saved query design. Which feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A filter is useful when the restriction is temporary or changes frequently.
• Filtering can change which records are currently displayed without modifying the underlying saved query criteria.
• Deleting source records would alter the actual database data and is not required for a temporary view.
• Filtering can change which records are currently displayed without modifying the underlying saved query criteria.
• Deleting source records would alter the actual database data and is not required for a temporary view.
వివరణ:
Question 13
ప్రశ్న 13
In Query Design view, Department = "Forensics" is entered under Department and Active = Yes is entered under Active on the same Criteria row. What does Access require for a record to be returned?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Criteria placed on the same Criteria row in different fields are combined using AND logic.
• A returned record must therefore have Department equal to Forensics and Active equal to Yes.
• If either condition is false for a record, that record does not satisfy the complete same-row criteria.
• A returned record must therefore have Department equal to Forensics and Active equal to Yes.
• If either condition is false for a record, that record does not satisfy the complete same-row criteria.
వివరణ:
Question 14
ప్రశ్న 14
A City field has "Hyderabad" in the Criteria row and "Warangal" in the Or row beneath it. What records will the query return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Criteria entered on separate Criteria and Or rows provide alternative conditions.
• A record qualifies when City is Hyderabad or when City is Warangal.
• The record does not need to satisfy both alternatives simultaneously.
• A record qualifies when City is Hyderabad or when City is Warangal.
• The record does not need to satisfy both alternatives simultaneously.
వివరణ:
Question 15
ప్రశ్న 15
A Salary query should prompt the user for a minimum salary whenever the query is run and then return salaries greater than or equal to the entered amount. Which criterion is appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Text inside square brackets that is not a recognized field name can act as a parameter prompt in an Access query.
• >=[Enter minimum salary:] asks the user for a value and compares Salary with the supplied parameter.
• The >= operator includes records equal to the entered minimum as well as records above it.
• >=[Enter minimum salary:] asks the user for a value and compares Salary with the supplied parameter.
• The >= operator includes records equal to the entered minimum as well as records above it.
వివరణ:
Question 16
ప్రశ్న 16
Which statement correctly distinguishes saved query criteria from a temporary filter applied to a query result?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Criteria entered in Query Design become part of the saved query definition when the query is saved.
• A filter can temporarily restrict the records currently displayed without requiring the query design itself to be rewritten.
• This distinction is useful when the permanent retrieval logic should remain unchanged.
• A filter can temporarily restrict the records currently displayed without requiring the query design itself to be rewritten.
• This distinction is useful when the permanent retrieval logic should remain unchanged.
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about Access query criteria:
1. Criteria on the same Criteria row in different fields are normally combined with AND.
2. Criteria placed on different Criteria/Or rows can provide OR alternatives.
3. Between 10 And 20 excludes both 10 and 20.
4. Is Not Null finds records in which the field contains a value.
Which statements are correct?
1. Criteria on the same Criteria row in different fields are normally combined with AND.
2. Criteria placed on different Criteria/Or rows can provide OR alternatives.
3. Between 10 And 20 excludes both 10 and 20.
4. Is Not Null finds records in which the field contains a value.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly describe the AND/OR behaviour of the query design grid.
• Statement 3 is false because Between 10 And 20 includes the boundary values 10 and 20.
• Statement 4 is correct because Is Not Null tests for the presence of a non-Null value.
• Statement 3 is false because Between 10 And 20 includes the boundary values 10 and 20.
• Statement 4 is correct because Is Not Null tests for the presence of a non-Null value.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): For a Date/Time field containing date-only values, the criterion <Date() selects records dated before today.
Reason (R): Date() returns the current system date, and the < operator selects values earlier than that date.
Choose the correct answer.
Reason (R): Date() returns the current system date, and the < operator selects values earlier than that date.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Date() returns the current system date in an Access expression.
• Using <Date() therefore selects date-only values that occur before today's date.
• Both statements are true, and the Reason correctly explains the Assertion.
• Using <Date() therefore selects date-only values that occur before today's date.
• Both statements are true, and the Reason correctly explains the Assertion.
వివరణ:
Question 19
ప్రశ్న 19
An IncidentDate field stores dates without time components. Which criterion returns incidents from 1 August 2026 through 31 August 2026 inclusive?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Between...And can be used with Access date values to define an inclusive date range.
• Because the field is specified as containing date-only values, the criterion includes every date from 1 August through 31 August 2026.
• The second option excludes both boundary dates because it uses strict greater-than and less-than comparisons.
• Because the field is specified as containing date-only values, the criterion includes every date from 1 August through 31 August 2026.
• The second option excludes both boundary dates because it uses strict greater-than and less-than comparisons.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Is Null
(b) Like
(c) Between...And
(d) In(...)
List II
1. Tests whether a value belongs to a specified set
2. Finds missing values
3. Tests whether a value lies within a range
4. Matches text against a pattern, including wildcard patterns
Choose the correct matching code.
List I
(a) Is Null
(b) Like
(c) Between...And
(d) In(...)
List II
1. Tests whether a value belongs to a specified set
2. Finds missing values
3. Tests whether a value lies within a range
4. Matches text against a pattern, including wildcard patterns
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Is Null tests for missing values, giving (a)-2.
• Like performs pattern matching, giving (b)-4, while Between...And tests whether a value lies within a range, giving (c)-3.
• In(...) tests membership in a specified set of values, giving (d)-1.
• Like performs pattern matching, giving (b)-4, while Between...And tests whether a value lies within a range, giving (c)-3.
• In(...) tests membership in a specified set of values, giving (d)-1.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: A. ="Pending" సమాధానం: A.
-
Question 2 ప్రశ్న 2Answer: C. <=1000 సమాధానం: C.
-
Question 3 ప్రశ్న 3Answer: D. Between 18 And 60 సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. Is Null సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. Is Not Null సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: D. "Closed" సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: A. Like "R*" సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: C. Like "*pur" సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: C. Like "R?308021" సమాధానం: C.
-
Question 10 ప్రశ్న 10Answer: B. In ("Hyderabad","Warangal","Nizamabad") సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: D. #20-Aug-2026# సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: A. Apply a filter to the query result సమాధానం: A.
-
Question 13 ప్రశ్న 13Answer: A. The record must satisfy both conditions. సమాధానం: A.
-
Question 14 ప్రశ్న 14Answer: D. Records where City is Hyderabad or Warangal సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: C. >=[Enter minimum salary:] సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: B. Query criteria form part of the query design, whereas a filter can temporarily restrict the displayed result without changing that design. సమాధానం: B.
-
Question 17 ప్రశ్న 17Answer: B. 1, 2 and 4 only సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: C. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: A. Between #1-Aug-2026# And #31-Aug-2026# సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: D. (a)-2, (b)-4, (c)-3, (d)-1 సమాధానం: D.