Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
What is the primary purpose of a query in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A query is used to ask questions about data and retrieve information that satisfies specified requirements.
• It can select particular fields, particular records or data from more than one source.
• Tables principally store data, whereas queries provide flexible ways to retrieve and analyze that stored data.
• It can select particular fields, particular records or data from more than one source.
• Tables principally store data, whereas queries provide flexible ways to retrieve and analyze that stored data.
వివరణ:
Question 2
ప్రశ్న 2
Which statement about a standard Access select query is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A select query points to data stored in its underlying tables or other queries.
• Saving the query saves the query definition rather than a separate duplicate of the displayed records.
• When the query is run again, its results are generated from the current data in its defined sources.
• Saving the query saves the query definition rather than a separate duplicate of the displayed records.
• When the query is run again, its results are generated from the current data in its defined sources.
వివరణ:
Question 3
ప్రశ్న 3
Which command path is used to start designing a query manually in current desktop Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Create tab contains Access commands for creating database objects.
• Create > Query Design opens the query designer so that tables or queries can be added as data sources.
• Fields, criteria and sorting instructions can then be entered in the query design grid.
• Create > Query Design opens the query designer so that tables or queries can be added as data sources.
• Fields, criteria and sorting instructions can then be entered in the query design grid.
వివరణ:
Question 4
ప్రశ్న 4
When a select query is run in Microsoft Access, in which view are its returned records normally displayed?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Running a select query causes Access to display its result set in Datasheet view.
• The returned fields appear as columns and the qualifying records appear as rows.
• Design view is used to construct or modify the query rather than to show its ordinary result set.
• The returned fields appear as columns and the qualifying records appear as rows.
• Design view is used to construct or modify the query rather than to show its ordinary result set.
వివరణ:
Question 5
ప్రశ్న 5
In an Access query design grid, what is the primary purpose of the Criteria row?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Query criteria are expressions that Access compares with field values.
• Records satisfying the specified criteria are included in the query result.
• Criteria therefore allow a query to return a more specific subset rather than every source record.
• Records satisfying the specified criteria are included in the query result.
• Criteria therefore allow a query to return a more specific subset rather than every source record.
వివరణ:
Question 6
ప్రశ్న 6
An Access table has a City field. Which criterion entered under City will select records whose City value is exactly Hyderabad?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• ="Hyderabad" tests for an exact text match with Hyderabad.
• Records whose City field contains that exact value satisfy the condition.
• Not excludes the value, while wildcard expressions can match broader text patterns rather than requiring only the exact field value.
• Records whose City field contains that exact value satisfy the condition.
• Not excludes the value, while wildcard expressions can match broader text patterns rather than requiring only the exact field value.
వివరణ:
Question 7
ప్రశ్న 7
A Salary field contains numeric values. Which query criterion returns only records where Salary is greater than 50000?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The greater-than operator selects values strictly above the specified number.
• Therefore >50000 returns salaries greater than 50000 but excludes a salary equal to 50000.
• >=50000 would be required if the boundary value itself also had to be included.
• Therefore >50000 returns salaries greater than 50000 but excludes a salary equal to 50000.
• >=50000 would be required if the boundary value itself also had to be included.
వివరణ:
Question 8
ప్రశ్న 8
Which Access query criterion selects numeric values from 100 through 200, including both 100 and 200?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Between 100 And 200 selects values within that interval.
• In Access query criteria, the two boundary values are included in a Between...And condition.
• Therefore both 100 and 200, together with values between them, can satisfy the criterion.
• In Access query criteria, the two boundary values are included in a Between...And condition.
• Therefore both 100 and 200, together with values between them, can satisfy the criterion.
వివరణ:
Question 9
ప్రశ్న 9
Using the standard Access wildcard convention for an .accdb database, which criterion selects text values that begin with the letter A?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• In the standard Access wildcard convention, * represents any sequence of characters.
• Like "A*" therefore requires A as the first character and permits any characters to follow it.
• Like "*A" instead searches for values ending with A.
• Like "A*" therefore requires A as the first character and permits any characters to follow it.
• Like "*A" instead searches for values ending with A.
వివరణ:
Question 10
ప్రశ్న 10
An Access query has Department = "Forensics" under the Department field and >50000 under the Salary field on the same Criteria row. Which records are returned?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Criteria placed on the same Criteria row across different fields are combined as AND conditions.
• A returned record must therefore have Department equal to Forensics and Salary greater than 50000.
• Failing either condition prevents that record from satisfying the complete same-row criteria.
• A returned record must therefore have Department equal to Forensics and Salary greater than 50000.
• Failing either condition prevents that record from satisfying the complete same-row criteria.
వివరణ:
Question 11
ప్రశ్న 11
A City field has "Hyderabad" in the Criteria row and "Warangal" in the Or row directly below it. What will the query return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Or row is used to specify an alternative criterion.
• A record can therefore qualify when City is Hyderabad or when City is Warangal.
• The record does not need to satisfy both alternatives simultaneously.
• A record can therefore qualify when City is Hyderabad or when City is Warangal.
• The record does not need to satisfy both alternatives simultaneously.
వివరణ:
Question 12
ప్రశ్న 12
A query must use the Department field to restrict results to Department = "Cyber Crime", but Department itself should not appear as a column in the query output. What should be done in Query Design view?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A field can participate in query criteria without being displayed in the final output.
• The field remains in the design grid so that its criterion can be evaluated.
• Clearing its Show check box prevents that field from appearing as a result column.
• The field remains in the design grid so that its criterion can be evaluated.
• Clearing its Show check box prevents that field from appearing as a result column.
వివరణ:
Question 13
ప్రశ్న 13
A query should display the employee with the highest Salary first and then continue toward lower salaries. Which Sort setting should be selected for Salary?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Descending sorting places larger numeric values before smaller values.
• Applied to Salary, the highest salary therefore appears first in the result set.
• Ascending would reverse the required order by placing the lowest salary first.
• Applied to Salary, the highest salary therefore appears first in the result set.
• Ascending would reverse the required order by placing the lowest salary first.
వివరణ:
Question 14
ప్రశ్న 14
A select query is currently open in Design view and the user wants to execute it. Which command is appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Run command in the Results group executes the query currently open in Design view.
• For a select query, the resulting records are then displayed in Datasheet view.
• The user can switch back to Design view later to modify fields, criteria or sorting.
• For a select query, the resulting records are then displayed in Datasheet view.
• The user can switch back to Design view later to modify fields, criteria or sorting.
వివరణ:
Question 15
ప్రశ్న 15
What is actually retained when an ordinary select query is saved in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Saving a select query preserves the instructions that define how its results should be produced.
• The underlying source data normally remains stored in tables rather than being copied into the saved query.
• Reopening or running the saved query can therefore produce results based on the current source data.
• The underlying source data normally remains stored in tables rather than being copied into the saved query.
• Reopening or running the saved query can therefore produce results based on the current source data.
వివరణ:
Question 16
ప్రశ్న 16
Which statement describes an important capability of an Access select query?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access select queries can use tables, other queries or combinations of sources.
• The designer can choose only the fields required for the particular information need.
• This enables queries to combine and focus database information without forcing every source field into the result.
• The designer can choose only the fields required for the particular information need.
• This enables queries to combine and focus database information without forcing every source field into the result.
వివరణ:
Question 17
ప్రశ్న 17
A saved select query is based on an Employees table. A Salary value in Employees is changed from 40000 to 50000, and the query is then run again. What normally happens if that record otherwise satisfies the query conditions?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A select query normally retrieves data from its current underlying sources when it is run.
• Because the saved query does not ordinarily contain a separate frozen copy of the source records, updated source values can appear in new results.
• Therefore the changed Salary value can be reflected the next time the query is executed.
• Because the saved query does not ordinarily contain a separate frozen copy of the source records, updated source values can appear in new results.
• Therefore the changed Salary value can be reflected the next time the query is executed.
వివరణ:
Question 18
ప్రశ్న 18
Which sequence represents the normal basic workflow for creating a select query in Access Design view?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Query creation begins by identifying the tables or queries that supply the required data.
• The required fields are added to the design grid, and criteria can then be entered when only particular records are required.
• Running the query displays the resulting records in Datasheet view.
• The required fields are added to the design grid, and criteria can then be entered when only particular records are required.
• Running the query displays the resulting records in Datasheet view.
వివరణ:
Question 19
ప్రశ్న 19
Consider the following statements about Access select queries:
1. A query can display only selected fields rather than every field in a table.
2. Criteria can restrict the records returned by the query.
3. A saved select query can be reused later.
4. Saving a select query normally saves a separate permanent copy of all returned data.
Which statements are correct?
1. A query can display only selected fields rather than every field in a table.
2. Criteria can restrict the records returned by the query.
3. A saved select query can be reused later.
4. Saving a select query normally saves a separate permanent copy of all returned data.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly describe field selection and record filtering through criteria.
• Statement 3 is correct because a saved query can be reopened and reused, including as a source for other database objects.
• Statement 4 is false because a normal select query points to its source data rather than storing a separate permanent copy of the result records.
• Statement 3 is correct because a saved query can be reopened and reused, including as a source for other database objects.
• Statement 4 is false because a normal select query points to its source data rather than storing a separate permanent copy of the result records.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Query Design
(b) Criteria row
(c) Show check box
(d) Datasheet view
List II
1. Controls whether a field appears as a result column
2. Displays the records returned when a select query is run
3. Provides the interface for manually constructing and modifying a query
4. Holds conditions used to restrict returned records
Choose the correct matching code.
List I
(a) Query Design
(b) Criteria row
(c) Show check box
(d) Datasheet view
List II
1. Controls whether a field appears as a result column
2. Displays the records returned when a select query is run
3. Provides the interface for manually constructing and modifying a query
4. Holds conditions used to restrict returned records
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Query Design is the manual query-construction interface, giving (a)-3.
• The Criteria row defines record-selection conditions, giving (b)-4, while the Show check box controls whether a field is displayed, giving (c)-1.
• Datasheet view displays the query's returned records, giving (d)-2.
• The Criteria row defines record-selection conditions, giving (b)-4, while the Show check box controls whether a field is displayed, giving (c)-1.
• Datasheet view displays the query's returned records, giving (d)-2.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: A. To retrieve, examine or work with selected data according to specified requirements సమాధానం: A.
-
Question 2 ప్రశ్న 2Answer: C. It displays data obtained from its source tables or queries without normally storing a separate copy of that data. సమాధానం: C.
-
Question 3 ప్రశ్న 3Answer: B. Create > Query Design సమాధానం: B.
-
Question 4 ప్రశ్న 4Answer: D. Datasheet view సమాధానం: D.
-
Question 5 ప్రశ్న 5Answer: B. To specify conditions that determine which records are included in the query results సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: A. ="Hyderabad" సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: D. >50000 సమాధానం: D.
-
Question 8 ప్రశ్న 8Answer: C. Between 100 And 200 సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: A. Like "A*" సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: B. Only records where Department is Forensics and Salary is greater than 50000 సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: D. Records whose City is Hyderabad or Warangal సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: C. Keep Department in the design grid with the criterion, but clear its Show check box. సమాధానం: C.
-
Question 13 ప్రశ్న 13Answer: C. Descending సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: A. Query Design > Results > Run సమాధానం: A.
-
Question 15 ప్రశ్న 15Answer: B. The query definition, including its selected sources, fields, criteria and related design instructions సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: D. It can retrieve selected fields from one or more tables, other queries, or combinations of these sources. సమాధానం: D.
-
Question 17 ప్రశ్న 17Answer: B. The query normally reflects the current source value of 50000. సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: D. Choose source tables/queries > add required fields > specify criteria if needed > run the query సమాధానం: D.
-
Question 19 ప్రశ్న 19Answer: A. 1, 2 and 3 only సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: C. (a)-3, (b)-4, (c)-1, (d)-2 సమాధానం: C.