Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
A laser printer's toner rubs off immediately after printing. Which component should be checked first?
Explanation:
• The fuser bonds toner using heat and pressure.
• Poor fusing leaves toner loose.
• The other components are unrelated to toner adhesion.
• Poor fusing leaves toner loose.
• The other components are unrelated to toner adhesion.
వివరణ:
Question 2
ప్రశ్న 2
Which Access object physically stores rows and fields?
Explanation:
• Tables are primary data-storage objects.
• Rows are records and columns are fields.
• Forms and reports present/interact with stored data.
• Rows are records and columns are fields.
• Forms and reports present/interact with stored data.
వివరణ:
Question 3
ప్రశ్న 3
A new disk is visible in Device Manager but absent from File Explorer. Which administrative tool should be checked next?
Explanation:
• A new disk may require initialization, partitioning or a drive letter.
• Disk Management provides these functions.
• File Explorer will not show an unmounted/unprepared volume.
• Disk Management provides these functions.
• File Explorer will not show an unmounted/unprepared volume.
వివరణ:
Question 4
ప్రశ్న 4
Which technology is appropriate for reading shaded answer bubbles?
Explanation:
• OMR detects marked positions.
• It is commonly used with standardized answer sheets.
• OCR recognizes characters rather than response marks.
• It is commonly used with standardized answer sheets.
• OCR recognizes characters rather than response marks.
వివరణ:
Question 5
ప్రశ్న 5
A cache has a 94% hit rate, 1.5 ns cache access time and a 50 ns miss penalty. Using AMAT = cache time + miss rate × miss penalty, what is AMAT?
Explanation:
• Miss rate = 6% = 0.06.
• 0.06 × 50 ns = 3.0 ns.
• AMAT = 1.5 + 3.0 = 4.5 ns.
• 0.06 × 50 ns = 3.0 ns.
• AMAT = 1.5 + 3.0 = 4.5 ns.
వివరణ:
Question 6
ప్రశ్న 6
In an advanced Paper III scenario, which statement about virtual memory is correct?
Explanation:
• Virtual memory maps virtual addresses to physical memory.
• Backing storage can hold nonresident pages.
• It extends memory management but does not eliminate RAM.
• Backing storage can hold nonresident pages.
• It extends memory management but does not eliminate RAM.
వివరణ:
Question 7
ప్రశ్న 7
A USB webcam is visible in Device Manager, but one conferencing application cannot access it. Which setting is most relevant next?
Explanation:
• Device Manager visibility shows that Windows recognizes the camera.
• Application permissions can still prevent access.
• Storage and CPU configuration are unrelated.
• Application permissions can still prevent access.
• Storage and CPU configuration are unrelated.
వివరణ:
Question 8
ప్రశ్న 8
Which statement correctly compares LAN, MAN and WAN?
Explanation:
• The classifications mainly describe geographic/network scope.
• LAN is local, MAN metropolitan, WAN wide-area.
• They are distinct from topology names such as star or bus.
• LAN is local, MAN metropolitan, WAN wide-area.
• They are distinct from topology names such as star or bus.
వివరణ:
Question 9
ప్రశ్న 9
Which technology reads magnetic-ink characters on bank cheques?
Explanation:
• MICR recognizes magnetic-ink characters.
• It is historically associated with banking documents.
• OMR and OCR use different recognition methods.
• It is historically associated with banking documents.
• OMR and OCR use different recognition methods.
వివరణ:
Question 10
ప్రశ్న 10
A laptop infected with malware establishes a correctly encrypted VPN. Which statement remains true?
Explanation:
• VPNs protect the communication path.
• Endpoint compromise is a separate security problem.
• Layered endpoint controls remain necessary.
• Endpoint compromise is a separate security problem.
• Layered endpoint controls remain necessary.
వివరణ:
Question 11
ప్రశ్న 11
A host is configured as 192.168.10.130/26. Which network address contains this host?
Explanation:
• /26 creates blocks of 64 addresses.
• The ranges are .0-.63, .64-.127, .128-.191 and .192-.255.
• 192.168.10.130 therefore belongs to 192.168.10.128/26.
• The ranges are .0-.63, .64-.127, .128-.191 and .192-.255.
• 192.168.10.130 therefore belongs to 192.168.10.128/26.
వివరణ:
Question 12
ప్రశ్న 12
Which protocol commonly supplies IP address, subnet mask, default gateway and DNS configuration automatically?
Explanation:
• DHCP automates client network configuration.
• It can supply an IP address and related options.
• HTTP and FTP are application protocols.
• It can supply an IP address and related options.
• HTTP and FTP are application protocols.
వివరణ:
Question 13
ప్రశ్న 13
Which property is most appropriate for enforcing Score >= 0 And <= 100?
Explanation:
• Validation Rule enforces logical validity conditions.
• A numeric range can be expressed directly.
• Caption changes only display text.
• A numeric range can be expressed directly.
• Caption changes only display text.
వివరణ:
Question 14
ప్రశ్న 14
Which Access object is used to filter, join, calculate or summarize data?
Explanation:
• Queries retrieve and process data.
• They can join tables, apply criteria and calculate results.
• Forms are primarily interfaces.
• They can join tables, apply criteria and calculate results.
• Forms are primarily interfaces.
వివరణ:
Question 15
ప్రశ్న 15
Ten nodes are connected in a full mesh. How many direct links are required?
Explanation:
• A full mesh requires n(n−1)/2 links.
• 10×9/2 = 45.
• Each unique node pair contributes one link.
• 10×9/2 = 45.
• Each unique node pair contributes one link.
వివరణ:
Question 16
ప్రశ్న 16
Four 3 TB drives are configured as RAID 5. Ignoring formatting overhead, what is the usable capacity and single-drive fault tolerance?
Explanation:
• RAID 5 usable capacity is (N−1) × drive size for equal drives.
• (4−1) × 3 TB = 9 TB.
• RAID 5 tolerates one member-drive failure.
• (4−1) × 3 TB = 9 TB.
• RAID 5 tolerates one member-drive failure.
వివరణ:
Question 17
ప్రశ్న 17
Which wizard helps find records in one table that have no matching record in another table?
Explanation:
• The Find Unmatched Query Wizard identifies unmatched relationships.
• It is useful for relationship audits.
• The other wizards create forms, labels or reports.
• It is useful for relationship audits.
• The other wizards create forms, labels or reports.
వివరణ:
Question 18
ప్రశ్న 18
A program repeatedly executes the same small function. Which locality principle is primarily exploited by cache?
Explanation:
• Temporal locality predicts reuse of recently accessed items.
• Repeated function code is fetched again soon.
• Caches retain recently used blocks to exploit this behavior.
• Repeated function code is fetched again soon.
• Caches retain recently used blocks to exploit this behavior.
వివరణ:
Question 19
ప్రశ్న 19
Which option allows a different first-page header within a section?
Explanation:
• Different First Page separates first-page header/footer content.
• It is useful for title pages.
• Odd/even headers solve another layout requirement.
• It is useful for title pages.
• Odd/even headers solve another layout requirement.
వివరణ:
Question 20
ప్రశ్న 20
A PC powers on, fans spin, but there is no POST after a CPU upgrade. The same motherboard works again with the old CPU. Which diagnosis has highest priority?
Explanation:
• The old CPU proves the board can otherwise initialize.
• A same-socket processor may still require chipset/firmware support.
• The failure occurs before the operating system becomes relevant.
• A same-socket processor may still require chipset/firmware support.
• The failure occurs before the operating system becomes relevant.
వివరణ:
Question 21
ప్రశ్న 21
Which physical connector is normally used for twisted-pair Ethernet from a PC NIC?
Explanation:
• Twisted-pair Ethernet commonly uses RJ45-style modular connectors.
• HDMI carries digital display/audio.
• SATA power and 3.5 mm audio serve different functions.
• HDMI carries digital display/audio.
• SATA power and 3.5 mm audio serve different functions.
వివరణ:
Question 22
ప్రశ్న 22
Which object is most appropriate for guided record entry?
Explanation:
• Forms provide user-friendly data-entry interfaces.
• Controls can be bound to fields.
• Reports are mainly output objects.
• Controls can be bound to fields.
• Reports are mainly output objects.
వివరణ:
Question 23
ప్రశ్న 23
Malware is present but the antivirus reports the system as clean. What is this classification?
Explanation:
• A false negative misses a real threat.
• The system may remain compromised.
• It is the opposite of a false positive.
• The system may remain compromised.
• It is the opposite of a false positive.
వివరణ:
Question 24
ప్రశ్న 24
In an advanced Paper III scenario, which Run command opens Disk Management?
Explanation:
• diskmgmt.msc launches Disk Management.
• It manages disks, volumes and drive letters.
• Other MSC commands open different administrative tools.
• It manages disks, volumes and drive letters.
• Other MSC commands open different administrative tools.
వివరణ:
Question 25
ప్రశ్న 25
Which protocol provides web communication protected by TLS?
Explanation:
• HTTPS is HTTP carried over TLS.
• It provides encrypted web communication.
• Telnet is not secure web browsing.
• It provides encrypted web communication.
• Telnet is not secure web browsing.
వివరణ:
Question 26
ప్రశ్న 26
Which firewall policy is described by 'block everything unless explicitly permitted'?
Explanation:
• Default deny rejects unmatched traffic.
• Only explicitly authorized flows pass.
• This minimizes unnecessary exposure.
• Only explicitly authorized flows pass.
• This minimizes unnecessary exposure.
వివరణ:
Question 27
ప్రశ్న 27
A table has composite primary key (StudentID, CourseID). Attribute StudentName depends only on StudentID. Which normalization problem exists?
Explanation:
• StudentName depends on only part of the composite key.
• That is a partial dependency.
• 2NF removes partial dependencies on candidate-key subsets.
• That is a partial dependency.
• 2NF removes partial dependencies on candidate-key subsets.
వివరణ:
Question 28
ప్రశ్న 28
Consider the statements about CPU registers: 1) Program Counter normally identifies the next instruction address. 2) Instruction Register holds the current instruction. 3) Accumulator may hold intermediate arithmetic results. Which option is correct?
Explanation:
• All three statements describe standard register roles in simple CPU models.
• The Program Counter and Instruction Register have distinct sequencing roles.
• The accumulator is classically associated with intermediate arithmetic/logic results.
• The Program Counter and Instruction Register have distinct sequencing roles.
• The accumulator is classically associated with intermediate arithmetic/logic results.
వివరణ:
Question 29
ప్రశ్న 29
Which statement best compares SSD and HDD random-access behavior?
Explanation:
• HDDs use moving read/write heads and rotating media.
• SSDs use solid-state nonvolatile storage.
• Mechanical seek delay is a major reason HDD random access is slower.
• SSDs use solid-state nonvolatile storage.
• Mechanical seek delay is a major reason HDD random access is slower.
వివరణ:
Question 30
ప్రశ్న 30
Which firewall type maintains state information about active sessions?
Explanation:
• Stateful firewalls track connection context.
• Return traffic can be evaluated based on session state.
• Basic stateless filtering evaluates packets independently.
• Return traffic can be evaluated based on session state.
• Basic stateless filtering evaluates packets independently.
వివరణ:
Question 31
ప్రశ్న 31
Which statement about locking is correct?
Explanation:
• Exclusive locks protect write access.
• Locking coordinates concurrent transactions.
• Poor lock interactions can themselves contribute to deadlock.
• Locking coordinates concurrent transactions.
• Poor lock interactions can themselves contribute to deadlock.
వివరణ:
Question 32
ప్రశ్న 32
In an advanced Paper III scenario, which statement correctly compares SRAM and DRAM?
Explanation:
• SRAM uses bistable storage cells and avoids refresh cycles.
• DRAM stores charge dynamically and must be refreshed.
• The trade-off explains cache versus main-memory use.
• DRAM stores charge dynamically and must be refreshed.
• The trade-off explains cache versus main-memory use.
వివరణ:
Question 33
ప్రశ్న 33
A1:A6 contain 9, 15, 21, 27, 33 and 39. What does =AVERAGE(A1:A6) return?
Explanation:
• The total is 144.
• There are six values.
• 144 ÷ 6 = 24.
• There are six values.
• 144 ÷ 6 = 24.
వివరణ:
Question 34
ప్రశ్న 34
Which function counts empty cells in a range?
Explanation:
• COUNTBLANK counts empty cells.
• COUNTA counts non-empty cells.
• COUNT counts numeric entries.
• COUNTA counts non-empty cells.
• COUNT counts numeric entries.
వివరణ:
Question 35
ప్రశ్న 35
Which query type prompts the user to enter a value when it runs?
Explanation:
• Parameter queries ask for runtime input.
• The entered value can be used as criteria.
• This makes one query reusable for many values.
• The entered value can be used as criteria.
• This makes one query reusable for many values.
వివరణ:
Question 36
ప్రశ్న 36
Which ROM technology is traditionally erased with ultraviolet light?
Explanation:
• EPROM is erasable using ultraviolet light in traditional devices.
• PROM is normally one-time programmable.
• EEPROM is erased electrically.
• PROM is normally one-time programmable.
• EEPROM is erased electrically.
వివరణ:
Question 37
ప్రశ్న 37
A running process requests disk I/O and cannot continue until completion. Which state transition is correct?
Explanation:
• The process cannot proceed while waiting for I/O.
• The OS removes it from the CPU and marks it blocked/waiting.
• After the event it can return to Ready.
• The OS removes it from the CPU and marks it blocked/waiting.
• After the event it can return to Ready.
వివరణ:
Question 38
ప్రశ్న 38
A1:A6 contain 9, 15, 21, 27, 33 and 39. What does =SUM(A1:A6) return?
Explanation:
• 9+15+21+27+33+39 = 144.
• SUM adds all numeric values.
• Therefore the result is 144.
• SUM adds all numeric values.
• Therefore the result is 144.
వివరణ:
Question 39
ప్రశ్న 39
Which output device is best suited to large CAD drawings on wide media?
Explanation:
• Large-format devices are designed for oversized technical graphics.
• They are commonly used in engineering and mapping.
• The alternatives are input devices.
• They are commonly used in engineering and mapping.
• The alternatives are input devices.
వివరణ:
Question 40
ప్రశ్న 40
Which command changes a file from Read-only to writable by clearing the Read-only attribute?
Explanation:
• -R clears the Read-only attribute.
• +R sets Read-only.
• +H sets Hidden.
• +R sets Read-only.
• +H sets Hidden.
వివరణ:
Question 41
ప్రశ్న 41
A filtered data list should sum only visible rows in E2:E500. Which formula is appropriate?
Explanation:
• SUBTOTAL can ignore rows removed by filtering.
• Function number 9 specifies SUM.
• A normal SUM does not provide the same filter-aware behavior.
• Function number 9 specifies SUM.
• A normal SUM does not provide the same filter-aware behavior.
వివరణ:
Question 42
ప్రశ్న 42
Which condition best describes thrashing?
Explanation:
• Thrashing is a virtual-memory performance collapse.
• It occurs when paging overwhelms useful processing.
• Insufficient effective RAM for active working sets is a common cause.
• It occurs when paging overwhelms useful processing.
• Insufficient effective RAM for active working sets is a common cause.
వివరణ:
Question 43
ప్రశ్న 43
Which firewall technology acts as an application-aware intermediary and can terminate client/server application connections?
Explanation:
• An application proxy mediates application sessions.
• It can enforce protocol-aware security policy.
• It performs more than simple packet forwarding.
• It can enforce protocol-aware security policy.
• It performs more than simple packet forwarding.
వివరణ:
Question 44
ప్రశ్న 44
In an advanced Paper III scenario, which statement best defines a process?
Explanation:
• A process is an active executing instance.
• It includes execution state and OS-managed resources.
• A program file alone is passive.
• It includes execution state and OS-managed resources.
• A program file alone is passive.
వివరణ:
Question 45
ప్రశ్న 45
Which peripheral converts sound waves into an input signal?
Explanation:
• A microphone captures acoustic input.
• Speakers are audio output devices.
• Monitors and printers provide visual/hard-copy output.
• Speakers are audio output devices.
• Monitors and printers provide visual/hard-copy output.
వివరణ:
Question 46
ప్రశ్న 46
One Case record must display many related Evidence records on the same screen. Which design is best?
Explanation:
• Main form/subform is suited to one-to-many relationships.
• The parent record appears with related child rows.
• This preserves normalized relational design.
• The parent record appears with related child rows.
• This preserves normalized relational design.
వివరణ:
Question 47
ప్రశ్న 47
Which property is most suitable for enforcing an entry pattern such as a phone number?
Explanation:
• Input Mask controls the pattern of entered characters.
• It is useful for structured identifiers.
• Validation Rule instead checks logical conditions.
• It is useful for structured identifiers.
• Validation Rule instead checks logical conditions.
వివరణ:
Question 48
ప్రశ్న 48
What does =IFERROR(25/0,"DIVERR") return?
Explanation:
• 25/0 produces a division-by-zero error.
• IFERROR returns the alternate value on error.
• Therefore the result is DIVERR.
• IFERROR returns the alternate value on error.
• Therefore the result is DIVERR.
వివరణ:
Question 49
ప్రశ్న 49
An AutoNumber primary key is referenced from another Access table. Which child field type is normally used?
Explanation:
• AutoNumber keys commonly correspond to Long Integer numeric values.
• The child foreign key should use a compatible Number/Long Integer field.
• Text and Attachment do not match the key type.
• The child foreign key should use a compatible Number/Long Integer field.
• Text and Attachment do not match the key type.
వివరణ:
Question 50
ప్రశ్న 50
Which device forwards Ethernet frames within a LAN using learned MAC-address information?
Explanation:
• A switch learns source MAC addresses and forwards frames based on destination MACs.
• It operates primarily within a LAN.
• Routers make inter-network IP forwarding decisions.
• It operates primarily within a LAN.
• Routers make inter-network IP forwarding decisions.
వివరణ:
Question 51
ప్రశ్న 51
Which Arrange command equalizes horizontal spacing among selected objects?
Explanation:
• Distribute Horizontally makes spacing equal.
• Alignment changes object edges/centers rather than spacing.
• Grouping does not redistribute objects.
• Alignment changes object edges/centers rather than spacing.
• Grouping does not redistribute objects.
వివరణ:
Question 52
ప్రశ్న 52
A Windows host self-assigns 169.254.18.33 because it cannot reach DHCP. What addressing mechanism is this?
Explanation:
• Windows can self-assign an address from 169.254.0.0/16.
• This commonly happens when DHCP configuration fails.
• The result is link-local rather than normal routed DHCP addressing.
• This commonly happens when DHCP configuration fails.
• The result is link-local rather than normal routed DHCP addressing.
వివరణ:
Question 53
ప్రశ్న 53
Eight identical 1 TB drives are configured as RAID 10. Ignoring formatting overhead, what is the nominal usable capacity?
Explanation:
• RAID 10 mirrors data and stripes across mirrored pairs.
• With equal drives, usable capacity is approximately half the raw capacity.
• 8 × 1 TB raw becomes 4 TB usable.
• With equal drives, usable capacity is approximately half the raw capacity.
• 8 × 1 TB raw becomes 4 TB usable.
వివరణ:
Question 54
ప్రశ్న 54
Which statement best distinguishes POST from the operating-system boot loader?
Explanation:
• POST belongs to the pre-boot firmware stage.
• The boot loader is invoked after firmware has initialized enough hardware to continue booting.
• The two stages serve different purposes.
• The boot loader is invoked after firmware has initialized enough hardware to continue booting.
• The two stages serve different purposes.
వివరణ:
Question 55
ప్రశ్న 55
Which statement about a foreign key is correct?
Explanation:
• Foreign keys represent relationships between tables.
• Multiple child rows may reference the same parent key.
• Referential integrity can prevent orphaned references.
• Multiple child rows may reference the same parent key.
• Referential integrity can prevent orphaned references.
వివరణ:
Question 56
ప్రశ్న 56
A client can ping a server's IP address but cannot resolve the server's hostname. Which service should be checked first?
Explanation:
• IP reachability already works.
• The failing function is name resolution.
• DNS resolves hostnames into address/resource records.
• The failing function is name resolution.
• DNS resolves hostnames into address/resource records.
వివరణ:
Question 57
ప్రశ్న 57
A laser printer produces repeated ghost images at a fixed interval down the page. Which class of component should be investigated before replacing the computer?
Explanation:
• A fixed repeating interval suggests a rotating printer component.
• Laser-printer imaging/fusing assemblies can create periodic artifacts.
• The computer's CPU, DNS and Excel engine do not cause mechanically periodic page defects.
• Laser-printer imaging/fusing assemblies can create periodic artifacts.
• The computer's CPU, DNS and Excel engine do not cause mechanically periodic page defects.
వివరణ:
Question 58
ప్రశ్న 58
Which feature automatically applies formats when rule conditions are met?
Explanation:
• Conditional Formatting changes appearance based on criteria.
• It can highlight thresholds, duplicates and trends.
• The distractors belong to other applications.
• It can highlight thresholds, duplicates and trends.
• The distractors belong to other applications.
వివరణ:
Question 59
ప్రశ్న 59
Which command creates a directory named CASEFILES in the current directory?
Explanation:
• MD/MKDIR creates directories.
• DEL removes files.
• TYPE displays text-file contents.
• DEL removes files.
• TYPE displays text-file contents.
వివరణ:
Question 60
ప్రశ్న 60
Which device is most appropriate for digitizing a paper photograph?
Explanation:
• A scanner captures paper content as digital image data.
• It is an input device.
• Plotters, speakers and projectors are output devices.
• It is an input device.
• Plotters, speakers and projectors are output devices.
వివరణ:
Question 61
ప్రశ్న 61
Host A is 10.1.5.20/24 and Host B is 10.1.6.20/24. Which statement is correct?
Explanation:
• /24 uses the first three octets as the network portion.
• 10.1.5.0/24 and 10.1.6.0/24 are different networks.
• Inter-network communication normally requires routing.
• 10.1.5.0/24 and 10.1.6.0/24 are different networks.
• Inter-network communication normally requires routing.
వివరణ:
Question 62
ప్రశ్న 62
Which feature is best for changing the formatting of all paragraphs that use the same named style?
Explanation:
• Styles centralize reusable formatting.
• Modifying the style updates all text using it.
• This improves consistency and efficiency.
• Modifying the style updates all text using it.
• This improves consistency and efficiency.
వివరణ:
Question 63
ప్రశ్న 63
Which database object can speed suitable lookups but adds storage and update-maintenance overhead?
Explanation:
• Indexes provide auxiliary access paths.
• They can improve search and sort performance.
• They require storage and maintenance when data changes.
• They can improve search and sort performance.
• They require storage and maintenance when data changes.
వివరణ:
Question 64
ప్రశ్న 64
Print jobs remain queued on a Windows workstation even though the network printer is reachable. Which software component should be checked early?
Explanation:
• The Print Spooler manages the print queue.
• A stalled spooler can block all queued jobs.
• DNS and time services do not process print jobs.
• A stalled spooler can block all queued jobs.
• DNS and time services do not process print jobs.
వివరణ:
Question 65
ప్రశ్న 65
Which What-If Analysis tool changes one input value until a formula reaches a target result?
Explanation:
• Goal Seek solves for one changing input.
• The target is a formula result.
• It is designed for single-variable target solving.
• The target is a formula result.
• It is designed for single-variable target solving.
వివరణ:
Question 66
ప్రశ్న 66
Which VPN type is most appropriate for securely connecting two branch-office networks over the Internet?
Explanation:
• Site-to-site VPNs connect networks through VPN gateways.
• They are commonly used between branch offices.
• Loopback and RAID are unrelated.
• They are commonly used between branch offices.
• Loopback and RAID are unrelated.
వివరణ:
Question 67
ప్రశ్న 67
Which feature controls the visual effect when moving from one slide to the next?
Explanation:
• Transitions operate between slides.
• Animations operate on slide objects.
• The other features belong to different applications.
• Animations operate on slide objects.
• The other features belong to different applications.
వివరణ:
Question 68
ప్రశ్న 68
Which storage is nonvolatile and normally has no mechanical seek head?
Explanation:
• SSDs use solid-state flash storage.
• They retain data without power.
• DRAM, SRAM and registers are volatile.
• They retain data without power.
• DRAM, SRAM and registers are volatile.
వివరణ:
Question 69
ప్రశ్న 69
Which OS technique queues print jobs for a slower shared printer?
Explanation:
• Spooling places output jobs in an intermediate queue.
• The printer processes them asynchronously.
• It allows applications to continue without waiting for each print job.
• The printer processes them asynchronously.
• It allows applications to continue without waiting for each print job.
వివరణ:
Question 70
ప్రశ్న 70
Which Access object is intended for formatted output with grouping and totals?
Explanation:
• Reports provide formatted presentation/printing.
• They support group headers/footers and totals.
• Tables primarily store raw records.
• They support group headers/footers and totals.
• Tables primarily store raw records.
వివరణ:
Question 71
ప్రశ్న 71
Which query type modifies existing records that satisfy criteria?
Explanation:
• Update queries change field values in qualifying records.
• Criteria determine which rows are affected.
• Append queries add rows instead.
• Criteria determine which rows are affected.
• Append queries add rows instead.
వివరణ:
Question 72
ప్రశ్న 72
In an advanced Paper III scenario, which option supports different headers on odd and even pages?
Explanation:
• The option creates separate odd/even headers and footers.
• It is useful in book-style documents.
• Different First Page affects only the first page.
• It is useful in book-style documents.
• Different First Page affects only the first page.
వివరణ:
Question 73
ప్రశ్న 73
Which pane displays a hierarchy of headings for navigation through a long report?
Explanation:
• The Navigation Pane can show heading structure.
• Users can jump directly to sections.
• The other panes/tools belong elsewhere.
• Users can jump directly to sections.
• The other panes/tools belong elsewhere.
వివరణ:
Question 74
ప్రశ్న 74
Which statement about M.2 is technically correct?
Explanation:
• M.2 alone does not imply one storage protocol.
• Compatibility depends on keying and controller/protocol support.
• NVMe commonly uses PCIe, while some M.2 devices use SATA.
• Compatibility depends on keying and controller/protocol support.
• NVMe commonly uses PCIe, while some M.2 devices use SATA.
వివరణ:
Question 75
ప్రశ్న 75
An employee portal is accessible only to authorized staff, including remote staff who first connect by VPN. How should the portal itself be classified?
Explanation:
• The portal remains private to authorized organizational users.
• VPN is simply the protected access method.
• Its role remains that of an intranet service.
• VPN is simply the protected access method.
• Its role remains that of an intranet service.
వివరణ:
Question 76
ప్రశ్న 76
Which technique loads a virtual-memory page only when it is referenced?
Explanation:
• Demand paging defers page loading until needed.
• It is a virtual-memory strategy.
• The other choices are unrelated.
• It is a virtual-memory strategy.
• The other choices are unrelated.
వివరణ:
Question 77
ప్రశ్న 77
A relation has 3,200 rows and 14 columns. What are its cardinality and degree?
Explanation:
• Cardinality is the number of tuples/rows.
• Degree is the number of attributes/columns.
• Therefore the values are 3,200 and 14.
• Degree is the number of attributes/columns.
• Therefore the values are 3,200 and 14.
వివరణ:
Question 78
ప్రశ్న 78
Six 8 GiB DIMMs are installed. What is the nominal total RAM capacity?
Explanation:
• 6 × 8 GiB = 48 GiB.
• Nominal capacities add across modules.
• Usable memory may be slightly lower because of hardware reservations.
• Nominal capacities add across modules.
• Usable memory may be slightly lower because of hardware reservations.
వివరణ:
Question 79
ప్రశ్న 79
B2:B5 contain 5, 3, 4 and 2; C2:C5 contain 7, 6, 8 and 9. What does =SUMPRODUCT(B2:B5,C2:C5) return?
Explanation:
• Products are 35, 18, 32 and 18.
• 35+18+32+18 = 103.
• SUMPRODUCT adds corresponding products.
• 35+18+32+18 = 103.
• SUMPRODUCT adds corresponding products.
వివరణ:
Question 80
ప్రశ్న 80
An automatic Table of Contents shows stale page numbers after editing. What should be done?
Explanation:
• Automatic TOCs can be refreshed.
• Updating recalculates entries and page numbers.
• Reinstallation is unnecessary.
• Updating recalculates entries and page numbers.
• Reinstallation is unnecessary.
వివరణ:
Question 81
ప్రశ్న 81
Why does password plus PIN normally not qualify as two-factor authentication?
Explanation:
• Passwords and PINs are both secrets the user knows.
• Two credentials from one category are not two-factor authentication.
• MFA requires factor-category diversity.
• Two credentials from one category are not two-factor authentication.
• MFA requires factor-category diversity.
వివరణ:
Question 82
ప్రశ్న 82
Which feature is intended to limit the types of edits permitted in a document?
Explanation:
• Restrict Editing can enforce controlled changes.
• It can limit editing modes/areas depending on configuration.
• Zoom and Word Count do not provide protection.
• It can limit editing modes/areas depending on configuration.
• Zoom and Word Count do not provide protection.
వివరణ:
Question 83
ప్రశ్న 83
A cache records 3,840 hits in 4,000 accesses. What is the hit rate?
Explanation:
• Hit rate = hits ÷ accesses.
• 3840 ÷ 4000 = 0.96.
• Therefore the hit rate is 96%.
• 3840 ÷ 4000 = 0.96.
• Therefore the hit rate is 96%.
వివరణ:
Question 84
ప్రశ్న 84
Which system-software component allows the OS to operate a specific hardware device?
Explanation:
• Drivers provide hardware-specific control interfaces.
• They translate OS requests into device operations.
• They are part of system software.
• They translate OS requests into device operations.
• They are part of system software.
వివరణ:
Question 85
ప్రశ్న 85
Which feature is the best place to make a recurring logo appear consistently on slides that use related layouts?
Explanation:
• Slide Master centralizes recurring design elements.
• Layouts inherit master formatting.
• It avoids editing each slide separately.
• Layouts inherit master formatting.
• It avoids editing each slide separately.
వివరణ:
Question 86
ప్రశ్న 86
Which query type displays summarized values with row headings and column headings?
Explanation:
• Crosstab queries provide matrix-style summaries.
• They use row/column headings with an aggregate.
• Action queries serve different purposes.
• They use row/column headings with an aggregate.
• Action queries serve different purposes.
వివరణ:
Question 87
ప్రశ్న 87
Which device provides temporary battery-backed power so a computer can shut down safely during a power failure?
Explanation:
• A UPS provides short-term backup power.
• It allows continued operation or orderly shutdown.
• The other devices do not supply backup electrical power.
• It allows continued operation or orderly shutdown.
• The other devices do not supply backup electrical power.
వివరణ:
Question 88
ప్రశ్న 88
A1:A6 contain 9, 15, 21, 27, 33 and 39. What does =COUNTIF(A1:A6,">=27") return?
Explanation:
• 27, 33 and 39 satisfy >=27.
• COUNTIF counts matching cells.
• Therefore the result is 3.
• COUNTIF counts matching cells.
• Therefore the result is 3.
వివరణ:
Question 89
ప్రశ్న 89
Which feature prevents a child record's foreign key from referencing a nonexistent parent record?
Explanation:
• Referential integrity enforces valid relationships.
• It can prevent orphaned references.
• The other features belong to other Office applications.
• It can prevent orphaned references.
• The other features belong to other Office applications.
వివరణ:
Question 90
ప్రశ్న 90
A program walks through an array sequentially. Which locality principle is primarily exploited?
Explanation:
• Spatial locality concerns nearby addresses.
• Sequential array access touches adjacent memory locations.
• Cache lines bring neighboring data together.
• Sequential array access touches adjacent memory locations.
• Cache lines bring neighboring data together.
వివరణ:
Question 91
ప్రశ్న 91
A Windows service fails at startup. Which pair of tools gives the most direct evidence about service status and logged failure details?
Explanation:
• Services shows configuration, dependencies and current state.
• Event Viewer provides logged service-control and system errors.
• The other tools do not diagnose service startup failures.
• Event Viewer provides logged service-control and system errors.
• The other tools do not diagnose service startup failures.
వివరణ:
Question 92
ప్రశ్న 92
A system with a high-end GPU resets only under combined CPU/GPU stress, while temperatures remain within limits. Which hardware cause is most plausible?
Explanation:
• Combined load sharply increases current demand.
• A weak or undersized PSU can cause abrupt resets without overheating.
• Application-layer settings do not explain electrical load-dependent failure.
• A weak or undersized PSU can cause abrupt resets without overheating.
• Application-layer settings do not explain electrical load-dependent failure.
వివరణ:
Question 93
ప్రశ్న 93
A Status column must allow only 'Open', 'Hold' or 'Closed'. Which feature is best?
Explanation:
• Data Validation can restrict allowed values.
• List validation provides a drop-down.
• This reduces inconsistent data entry.
• List validation provides a drop-down.
• This reduces inconsistent data entry.
వివరణ:
Question 94
ప్రశ్న 94
In an advanced Paper III scenario, which Run command opens Event Viewer?
Explanation:
• eventvwr.msc launches Event Viewer.
• It provides access to Windows logs.
• The other commands open different consoles.
• It provides access to Windows logs.
• The other commands open different consoles.
వివరణ:
Question 95
ప్రశ్న 95
In an advanced Paper III scenario, which Run command opens Device Manager?
Explanation:
• devmgmt.msc opens Device Manager.
• It is used for hardware and driver management.
• The other MSC files open different consoles.
• It is used for hardware and driver management.
• The other MSC files open different consoles.
వివరణ:
Question 96
ప్రశ్న 96
In an advanced Paper III scenario, which Run command opens the Services management console?
Explanation:
• services.msc opens the Services console.
• It lets administrators inspect startup types and current status.
• The other commands open different tools.
• It lets administrators inspect startup types and current status.
• The other commands open different tools.
వివరణ:
Question 97
ప్రశ్న 97
Which statement best describes a cache miss?
Explanation:
• A miss means the lookup failed in that cache level.
• The hierarchy must obtain the data elsewhere.
• It is the opposite of a cache hit.
• The hierarchy must obtain the data elsewhere.
• It is the opposite of a cache hit.
వివరణ:
Question 98
ప్రశ్న 98
Which feature displays presenter notes privately while the audience sees the slide show?
Explanation:
• Presenter View provides private presenter information.
• The audience display remains the presentation.
• It supports live delivery.
• The audience display remains the presentation.
• It supports live delivery.
వివరణ:
Question 99
ప్రశ్న 99
Which connector is normally used for Ethernet over twisted-pair cabling?
Explanation:
• Twisted-pair Ethernet commonly uses RJ45-style connectors.
• HDMI and VGA are display connectors.
• 3.5 mm is typically analog audio.
• HDMI and VGA are display connectors.
• 3.5 mm is typically analog audio.
వివరణ:
Question 100
ప్రశ్న 100
Six 2 TB drives are configured as RAID 6. Ignoring formatting overhead, what is the usable capacity?
Explanation:
• RAID 6 usable capacity is (N−2) × drive size for equal drives.
• (6−2) × 2 TB = 8 TB.
• Two drives' worth of capacity is consumed by dual-parity protection.
• (6−2) × 2 TB = 8 TB.
• Two drives' worth of capacity is consumed by dual-parity protection.
వివరణ:
Question 101
ప్రశ్న 101
A USB keyboard works on rear ports but not on two front-panel ports. Which fault area is most plausible?
Explanation:
• The keyboard works on other ports, proving the device is functional.
• Both front ports failing points to their shared cable/header path.
• Storage and DHCP do not control front-panel USB electrical connectivity.
• Both front ports failing points to their shared cable/header path.
• Storage and DHCP do not control front-panel USB electrical connectivity.
వివరణ:
Question 102
ప్రశ్న 102
Which view is best for quickly changing the sequence of many slides?
Explanation:
• Slide Sorter displays many slide thumbnails.
• Slides can be reordered by dragging.
• Presenter View is intended for delivery.
• Slides can be reordered by dragging.
• Presenter View is intended for delivery.
వివరణ:
Question 103
ప్రశ్న 103
Which ACID property ensures a transaction's operations are treated as an indivisible unit?
Explanation:
• Atomicity provides all-or-nothing semantics.
• A failed transaction can be rolled back.
• Isolation and durability address different guarantees.
• A failed transaction can be rolled back.
• Isolation and durability address different guarantees.
వివరణ:
Question 104
ప్రశ్న 104
In relation R(StudentID, DeptID, DeptName), StudentID is the key and DeptID determines DeptName. Which issue is present?
Explanation:
• StudentID determines DeptID, which determines DeptName.
• Thus DeptName is transitively dependent on the key through a non-key attribute.
• 3NF addresses such transitive dependencies.
• Thus DeptName is transitively dependent on the key through a non-key attribute.
• 3NF addresses such transitive dependencies.
వివరణ:
Question 105
ప్రశ్న 105
T1 and T2 read the same original balance; both compute new values; T2's later write overwrites T1's change. What anomaly is this?
Explanation:
• One concurrent update overwrites another.
• The earlier change is effectively lost.
• Concurrency-control mechanisms are needed to prevent this.
• The earlier change is effectively lost.
• Concurrency-control mechanisms are needed to prevent this.
వివరణ:
Question 106
ప్రశ్న 106
Which OS mechanism allows a hardware device to signal the processor asynchronously?
Explanation:
• Interrupts notify the CPU that an event needs attention.
• The CPU runs an interrupt handler.
• They reduce the need for continuous polling.
• The CPU runs an interrupt handler.
• They reduce the need for continuous polling.
వివరణ:
Question 107
ప్రశ్న 107
A CPU cooler was reinstalled and the machine now throttles heavily. The fan spins normally. Which fault is still likely?
Explanation:
• A spinning fan does not prove good thermal contact.
• Uneven cooler mounting or poor thermal compound application can raise CPU temperature.
• Thermal throttling can occur even when the fan itself is functional.
• Uneven cooler mounting or poor thermal compound application can raise CPU temperature.
• Thermal throttling can occur even when the fan itself is functional.
వివరణ:
Question 108
ప్రశ్న 108
Which statement about a star topology is correct?
Explanation:
• A star depends on a central connecting device.
• Individual access links are separate.
• A central-device failure is therefore a common point of failure.
• Individual access links are separate.
• A central-device failure is therefore a common point of failure.
వివరణ:
Question 109
ప్రశ్న 109
Which ROM technology is erased electrically and rewritten electrically?
Explanation:
• EEPROM is Electrically Erasable Programmable Read-Only Memory.
• EPROM traditionally uses ultraviolet light for erasure.
• DRAM is volatile working memory.
• EPROM traditionally uses ultraviolet light for erasure.
• DRAM is volatile working memory.
వివరణ:
Question 110
ప్రశ్న 110
T1 reads row R twice. Between reads, T2 updates R and commits. T1 sees two different values. What anomaly is this?
Explanation:
• The same existing row changes between reads.
• The intervening change is committed.
• This is a non-repeatable read.
• The intervening change is committed.
• This is a non-repeatable read.
వివరణ:
Question 111
ప్రశ్న 111
Which command displays the directory tree and also includes file names?
Explanation:
• TREE displays the directory hierarchy.
• /F includes files in the tree output.
• DIR /P paginates a normal directory listing.
• /F includes files in the tree output.
• DIR /P paginates a normal directory listing.
వివరణ:
Question 112
ప్రశ్న 112
Which feature is best for summarizing a large table by fields such as District, Month and Total?
Explanation:
• PivotTables group and aggregate worksheet data.
• Fields can be rearranged interactively.
• The other choices belong to different applications.
• Fields can be rearranged interactively.
• The other choices belong to different applications.
వివరణ:
Question 113
ప్రశ్న 113
A Windows image has component-store corruption. Which repair sequence is generally appropriate before resorting to reinstallation?
Explanation:
• DISM can repair the component store used as a repair source.
• SFC can then verify and replace protected system files.
• Formatting is not an appropriate first repair step.
• SFC can then verify and replace protected system files.
• Formatting is not an appropriate first repair step.
వివరణ:
Question 114
ప్రశ్న 114
Which Windows mechanism prompts for administrator consent/credentials when elevation is required?
Explanation:
• UAC mediates privilege elevation.
• It supports running normally without continuous administrator privilege.
• RAID and DHCP are unrelated.
• It supports running normally without continuous administrator privilege.
• RAID and DHCP are unrelated.
వివరణ:
Question 115
ప్రశ్న 115
A process waiting for network input receives the required packet. Which state should it normally enter next?
Explanation:
• The event removes the blocking condition.
• The process becomes runnable.
• It normally enters Ready before being scheduled.
• The process becomes runnable.
• It normally enters Ready before being scheduled.
వివరణ:
Question 116
ప్రశ్న 116
Which OS function includes naming, organizing and protecting files/directories?
Explanation:
• The file system manages files, directories and metadata.
• It also enforces access permissions.
• The other choices are hardware/peripheral functions.
• It also enforces access permissions.
• The other choices are hardware/peripheral functions.
వివరణ:
Question 117
ప్రశ్న 117
A referenced virtual page is not resident in RAM and the OS must retrieve it from backing storage. What has occurred?
Explanation:
• A page fault is triggered by a nonresident required page.
• The OS may load the page from backing storage.
• It is a virtual-memory event rather than a hardware self-test.
• The OS may load the page from backing storage.
• It is a virtual-memory event rather than a hardware self-test.
వివరణ:
Question 118
ప్రశ్న 118
Which statement defines volatile memory?
Explanation:
• Volatile memory loses state without power.
• Ordinary DRAM and SRAM are volatile.
• Volatility describes retention, not access speed.
• Ordinary DRAM and SRAM are volatile.
• Volatility describes retention, not access speed.
వివరణ:
Question 119
ప్రశ్న 119
Which component most directly decodes an instruction's opcode and coordinates execution control signals?
Explanation:
• The Control Unit interprets instructions and issues coordination signals.
• The ALU performs arithmetic/logic operations.
• Cooling and storage controllers do not decode CPU instructions.
• The ALU performs arithmetic/logic operations.
• Cooling and storage controllers do not decode CPU instructions.
వివరణ:
Question 120
ప్రశ్న 120
Which capability can detect and correct certain memory bit errors on supported systems?
Explanation:
• ECC uses additional check information.
• Common ECC implementations can correct certain single-bit errors.
• It does not make memory nonvolatile.
• Common ECC implementations can correct certain single-bit errors.
• It does not make memory nonvolatile.
వివరణ:
Question 121
ప్రశ్న 121
A system spends most of its time paging rather than executing application code. What condition is most likely?
Explanation:
• Thrashing is excessive paging activity.
• It often results from insufficient effective physical memory for active working sets.
• Useful CPU progress becomes very low.
• It often results from insufficient effective physical memory for active working sets.
• Useful CPU progress becomes very low.
వివరణ:
Question 122
ప్రశ్న 122
Which print layout shows one slide together with its speaker notes?
Explanation:
• Notes Pages combine the slide image with notes.
• They are useful for presenter reference.
• Handouts primarily arrange thumbnails.
• They are useful for presenter reference.
• Handouts primarily arrange thumbnails.
వివరణ:
Question 123
ప్రశ్న 123
Cell F3 contains =$B3+C$1+D3 and is copied to H6. What formula appears in H6?
Explanation:
• The copy moves two columns right and three rows down.
• $B3 becomes $B6, C$1 becomes E$1, and D3 becomes F6.
• Absolute and relative components move independently.
• $B3 becomes $B6, C$1 becomes E$1, and D3 becomes F6.
• Absolute and relative components move independently.
వివరణ:
Question 124
ప్రశ్న 124
Which command removes locally cached DNS resolver entries?
Explanation:
• ipconfig /flushdns clears the DNS resolver cache.
• It is useful for stale name-resolution entries.
• SFC and CHKDSK serve different maintenance purposes.
• It is useful for stale name-resolution entries.
• SFC and CHKDSK serve different maintenance purposes.
వివరణ:
Question 125
ప్రశ్న 125
A motherboard reports a CPU_FAN warning even though the cooler fan spins from a chassis-fan header. What is the most appropriate correction?
Explanation:
• Firmware commonly monitors the dedicated CPU_FAN header.
• A fan on another header may spin but still trigger a warning.
• The correct header also enables intended CPU-fan control behavior.
• A fan on another header may spin but still trigger a warning.
• The correct header also enables intended CPU-fan control behavior.
వివరణ:
Question 126
ప్రశ్న 126
Which constraint is best suited to enforcing Quantity >= 0 at the database level?
Explanation:
• CHECK validates a Boolean condition on stored values.
• Quantity >= 0 is a direct rule.
• ORDER BY merely sorts query output.
• Quantity >= 0 is a direct rule.
• ORDER BY merely sorts query output.
వివరణ:
Question 127
ప్రశ్న 127
Which feature can replace all occurrences of a term while also allowing formatting criteria to be specified?
Explanation:
• Find and Replace can search text and formatting.
• It can replace repeated content efficiently.
• Mail Merge does not perform general global replacement.
• It can replace repeated content efficiently.
• Mail Merge does not perform general global replacement.
వివరణ:
Question 128
ప్రశ్న 128
Which printer type uses an ink ribbon and impact pins?
Explanation:
• Dot-matrix printers are impact devices.
• Pins strike an inked ribbon against paper.
• Laser and inkjet printers are non-impact technologies.
• Pins strike an inked ribbon against paper.
• Laser and inkjet printers are non-impact technologies.
వివరణ:
Question 129
ప్రశ్న 129
Which component decides which ready task receives CPU time?
Explanation:
• The scheduler selects among runnable tasks.
• Its policy influences responsiveness and fairness.
• The other components do not assign CPU execution.
• Its policy influences responsiveness and fairness.
• The other components do not assign CPU execution.
వివరణ:
Question 130
ప్రశ్న 130
In an advanced Paper III scenario, which description best fits an intranet?
Explanation:
• An intranet serves an organization's authorized users.
• It may use standard Internet technologies such as HTTP/HTTPS.
• It is not the global public Internet.
• It may use standard Internet technologies such as HTTP/HTTPS.
• It is not the global public Internet.
వివరణ:
Question 131
ప్రశ్న 131
Which tool copies formatting attributes without copying the original text content?
Explanation:
• Format Painter transfers formatting.
• It is useful for consistent appearance.
• The other choices belong to different Office functions.
• It is useful for consistent appearance.
• The other choices belong to different Office functions.
వివరణ:
Question 132
ప్రశ్న 132
A system completes POST and lists an NVMe SSD, but the firmware boot menu contains no Windows Boot Manager entry. The SSD was cloned from a legacy BIOS/MBR machine. Which explanation is most technically appropriate?
Explanation:
• UEFI boot typically relies on a compatible boot structure and firmware boot entry.
• A legacy BIOS/MBR clone may require conversion or boot repair for native UEFI startup.
• SSD detection alone does not guarantee a valid UEFI boot path.
• A legacy BIOS/MBR clone may require conversion or boot repair for native UEFI startup.
• SSD detection alone does not guarantee a valid UEFI boot path.
వివరణ:
Question 133
ప్రశ్న 133
A login uses a password and hardware token. Which factor categories are combined?
Explanation:
• A password is something the user knows.
• A hardware token is something the user possesses.
• Using two distinct categories provides MFA.
• A hardware token is something the user possesses.
• Using two distinct categories provides MFA.
వివరణ:
Question 134
ప్రశ్న 134
Cell G5 contains =D$2+$E5+F5 and is copied to J8. What formula appears in J8?
Explanation:
• The copy moves three columns right and three rows down.
• D$2 becomes G$2; $E5 becomes $E8.
• Relative F5 becomes I8.
• D$2 becomes G$2; $E5 becomes $E8.
• Relative F5 becomes I8.
వివరణ:
Question 135
ప్రశ్న 135
Which mechanism separates ordinary application privilege from privileged operating-system execution?
Explanation:
• Kernel mode permits privileged operations.
• User-mode applications are restricted.
• This separation improves protection and stability.
• User-mode applications are restricted.
• This separation improves protection and stability.
వివరణ:
Question 136
ప్రశ్న 136
Which command displays hidden and system files as part of a directory listing?
Explanation:
• DIR /A displays entries based on attributes and, without a specific attribute filter, includes hidden/system items.
• DIR /W only changes listing width.
• CD and TYPE do not provide attribute-based directory listing.
• DIR /W only changes listing width.
• CD and TYPE do not provide attribute-based directory listing.
వివరణ:
Question 137
ప్రశ్న 137
A monitor displays 'No Signal' while the PC appears to boot normally. Which troubleshooting step should come first?
Explanation:
• No Signal indicates missing video input rather than an application failure.
• Input selection and physical video path are immediate checks.
• Database, document and DNS settings are irrelevant.
• Input selection and physical video path are immediate checks.
• Database, document and DNS settings are irrelevant.
వివరణ:
Question 138
ప్రశ్న 138
What does =MOD(97,12) return?
Explanation:
• 97 = 12×8 + 1.
• MOD returns the remainder.
• Therefore the result is 1.
• MOD returns the remainder.
• Therefore the result is 1.
వివరణ:
Question 139
ప్రశ్న 139
Which feature is best when edits must be recorded so a reviewer can later accept or reject them?
Explanation:
• Track Changes records revisions as they occur.
• Reviewers can accept/reject them later.
• Compare is more appropriate for already separate document versions.
• Reviewers can accept/reject them later.
• Compare is more appropriate for already separate document versions.
వివరణ:
Question 140
ప్రశ్న 140
What does =POWER(6,3) return?
Explanation:
• POWER(6,3) means 6 cubed.
• 6×6×6 = 216.
• Therefore the function returns 216.
• 6×6×6 = 216.
• Therefore the function returns 216.
వివరణ:
Question 141
ప్రశ్న 141
In an advanced Paper III scenario, which statement about PROM is correct?
Explanation:
• PROM is one-time programmable in the traditional form.
• EPROM and EEPROM are erasable alternatives.
• PROM is nonvolatile and does not require DRAM-style refresh.
• EPROM and EEPROM are erasable alternatives.
• PROM is nonvolatile and does not require DRAM-style refresh.
వివరణ:
Question 142
ప్రశ్న 142
Which command shows active connections and listening ports?
Explanation:
• netstat reports network connection/socket information.
• It is useful for troubleshooting active/listening endpoints.
• MD, DEL and CLS are shell/file commands.
• It is useful for troubleshooting active/listening endpoints.
• MD, DEL and CLS are shell/file commands.
వివరణ:
Question 143
ప్రశ్న 143
Which feature creates an audience-specific subset and order of slides without deleting any slides?
Explanation:
• Custom Slide Show defines an alternate subset/order.
• The original presentation remains intact.
• It is suitable for different audiences.
• The original presentation remains intact.
• It is suitable for different audiences.
వివరణ:
Question 144
ప్రశ్న 144
Which command traces successive IP hops toward a destination?
Explanation:
• tracert reveals route hops using TTL-limited probes.
• It helps diagnose path problems.
• COPY, VER and CLS are unrelated.
• It helps diagnose path problems.
• COPY, VER and CLS are unrelated.
వివరణ:
Question 145
ప్రశ్న 145
B2 contains 78 and C2 contains 82. What does =IF(AND(B2>=75,C2>=80),"SELECT","REJECT") return?
Explanation:
• 78>=75 is TRUE.
• 82>=80 is TRUE.
• AND is TRUE, so IF returns SELECT.
• 82>=80 is TRUE.
• AND is TRUE, so IF returns SELECT.
వివరణ:
Question 146
ప్రశ్న 146
Which query type creates a new table from its result set?
Explanation:
• Make-table queries create a physical table.
• The table is populated from the query output.
• Update/delete operate on existing data.
• The table is populated from the query output.
• Update/delete operate on existing data.
వివరణ:
Question 147
ప్రశ్న 147
P1 holds Resource A and waits for B; P2 holds B and waits for A. Which condition exists?
Explanation:
• The processes form a circular wait.
• Neither can proceed without intervention.
• This is a classic deadlock.
• Neither can proceed without intervention.
• This is a classic deadlock.
వివరణ:
Question 148
ప్రశ్న 148
What does =ROUND(91.445,2) return in Excel?
Explanation:
• The third decimal digit is 5.
• Rounding to two decimal places increases the hundredths digit.
• The result is 91.45.
• Rounding to two decimal places increases the hundredths digit.
• The result is 91.45.
వివరణ:
Question 149
ప్రశ్న 149
Which function counts non-empty cells regardless of whether they contain numbers or text?
Explanation:
• COUNTA counts non-empty cells.
• COUNT counts numeric cells.
• COUNTBLANK counts empty cells.
• COUNT counts numeric cells.
• COUNTBLANK counts empty cells.
వివరణ:
Question 150
ప్రశ్న 150
Two independently edited versions of a contract must be analyzed for differences. Which feature is most appropriate?
Explanation:
• Compare identifies differences between document versions.
• It is useful when edits were made separately.
• Mail Merge serves personalized document creation.
• It is useful when edits were made separately.
• Mail Merge serves personalized document creation.
వివరణ:
Question 151
ప్రశ్న 151
Which device chooses a next hop for packets destined to another IP network?
Explanation:
• Routers inspect destination IP networks.
• They use routing information to choose next hops.
• A basic switch does not perform inter-network routing.
• They use routing information to choose next hops.
• A basic switch does not perform inter-network routing.
వివరణ:
Question 152
ప్రశ్న 152
Which mechanism primarily protects confidentiality by converting plaintext into ciphertext?
Explanation:
• Encryption protects information from unauthorized disclosure.
• Authorized parties use keys to decrypt.
• Hashing is not intended to be reversible.
• Authorized parties use keys to decrypt.
• Hashing is not intended to be reversible.
వివరణ:
Question 153
ప్రశ్న 153
In an advanced Paper III scenario, which statement about RAID 0 is correct?
Explanation:
• RAID 0 is pure striping.
• It has no parity or mirroring.
• A member-drive failure can make the array data unavailable.
• It has no parity or mirroring.
• A member-drive failure can make the array data unavailable.
వివరణ:
Question 154
ప్రశ్న 154
In an advanced Paper III scenario, which memory type is commonly used for processor cache?
Explanation:
• SRAM provides low latency.
• It does not need periodic refresh while powered.
• Its higher cost/density trade-off makes it suitable for smaller caches.
• It does not need periodic refresh while powered.
• Its higher cost/density trade-off makes it suitable for smaller caches.
వివరణ:
Question 155
ప్రశ్న 155
T1 holds Lock A and waits for B; T2 holds Lock B and waits for A. What condition exists?
Explanation:
• The transactions form a circular wait.
• Neither can continue without intervention.
• The DBMS may abort a victim transaction to resolve the deadlock.
• Neither can continue without intervention.
• The DBMS may abort a victim transaction to resolve the deadlock.
వివరణ:
Question 156
ప్రశ్న 156
Which statement correctly distinguishes authentication and authorization?
Explanation:
• Authentication answers who the user is.
• Authorization answers what that authenticated identity may do.
• The controls are related but distinct.
• Authorization answers what that authenticated identity may do.
• The controls are related but distinct.
వివరణ:
Question 157
ప్రశ్న 157
Which CPU stage immediately follows fetch in the simplified fetch-decode-execute cycle?
Explanation:
• The processor first fetches an instruction.
• It then decodes the instruction to determine the required operation.
• Execution follows decoding.
• It then decodes the instruction to determine the required operation.
• Execution follows decoding.
వివరణ:
Question 158
ప్రశ్న 158
Which statement about a primary key is correct?
Explanation:
• A primary key uniquely identifies records.
• Null cannot serve as a primary-key value.
• Foreign keys are a different relationship mechanism.
• Null cannot serve as a primary-key value.
• Foreign keys are a different relationship mechanism.
వివరణ:
Question 159
ప్రశ్న 159
Which command displays detailed adapter configuration including DNS and DHCP information?
Explanation:
• ipconfig /all shows detailed TCP/IP adapter settings.
• It commonly displays DHCP and DNS information.
• The other commands are file-system commands.
• It commonly displays DHCP and DNS information.
• The other commands are file-system commands.
వివరణ:
Question 160
ప్రశ్న 160
A SATA SSD is visible intermittently and the drive's SMART data show no obvious media problem. Which low-level physical checks are appropriate first?
Explanation:
• Intermittent detection can result from cabling or power issues.
• SATA data and power paths should be verified before software reinstallation.
• Office and network configuration are unrelated to device enumeration.
• SATA data and power paths should be verified before software reinstallation.
• Office and network configuration are unrelated to device enumeration.
వివరణ:
Question 161
ప్రశ్న 161
Which component is specifically intended to hold desktop RAM modules?
Explanation:
• Desktop memory modules install in DIMM sockets.
• PCIe slots hold expansion cards.
• SATA and RJ45 serve storage and networking.
• PCIe slots hold expansion cards.
• SATA and RJ45 serve storage and networking.
వివరణ:
Question 162
ప్రశ్న 162
In an advanced Paper III scenario, which query type inserts selected records into an existing table?
Explanation:
• Append queries add new rows.
• They do not modify existing rows in place.
• Update queries alter existing values.
• They do not modify existing rows in place.
• Update queries alter existing values.
వివరణ:
Question 163
ప్రశ్న 163
Which statement best distinguishes COMMIT from ROLLBACK?
Explanation:
• COMMIT finalizes transaction changes.
• ROLLBACK cancels applicable uncommitted work.
• They are complementary transaction-control operations.
• ROLLBACK cancels applicable uncommitted work.
• They are complementary transaction-control operations.
వివరణ:
Question 164
ప్రశ్న 164
Which isolation-level family offers the strongest protection against dirty reads, non-repeatable reads and phantoms among the standard SQL levels?
Explanation:
• Serializable is intended to make concurrent execution equivalent to some serial order.
• It prevents the classic dirty/non-repeatable/phantom anomalies.
• Lower standard isolation levels permit more concurrency anomalies.
• It prevents the classic dirty/non-repeatable/phantom anomalies.
• Lower standard isolation levels permit more concurrency anomalies.
వివరణ:
Question 165
ప్రశ్న 165
Only one chapter of a long document needs landscape orientation and different margins. Which Word feature provides the necessary formatting boundary?
Explanation:
• Section breaks create independently formatted regions.
• Orientation and margins can differ by section.
• A page break does not create an independent formatting section.
• Orientation and margins can differ by section.
• A page break does not create an independent formatting section.
వివరణ:
Question 166
ప్రశ్న 166
T1 reads a value written by T2 before T2 commits. What anomaly is this?
Explanation:
• A dirty read observes uncommitted data.
• T2 may later roll back the value.
• Stronger isolation levels can prevent dirty reads.
• T2 may later roll back the value.
• Stronger isolation levels can prevent dirty reads.
వివరణ:
Question 167
ప్రశ్న 167
Which control examines packet header fields such as addresses, protocol and ports without necessarily maintaining connection state?
Explanation:
• Stateless packet filtering applies header-based rules to individual packets.
• It does not inherently maintain session state.
• An application proxy acts at the application layer.
• It does not inherently maintain session state.
• An application proxy acts at the application layer.
వివరణ:
Question 168
ప్రశ్న 168
A discrete GPU is installed, but the monitor remains connected to a motherboard video output that firmware has disabled when the discrete GPU is primary. What is the best first action?
Explanation:
• The active graphics adapter determines which outputs carry video.
• Discrete GPU installation can change primary-display routing.
• Storage and database actions are unrelated.
• Discrete GPU installation can change primary-display routing.
• Storage and database actions are unrelated.
వివరణ:
Question 169
ప్రశ్న 169
Which statement correctly distinguishes the 24-pin ATX connector from the CPU auxiliary power connector?
Explanation:
• Modern ATX systems use the 24-pin connector for motherboard rails.
• The CPU receives additional power through a dedicated auxiliary connector.
• The two connectors are electrically and functionally distinct.
• The CPU receives additional power through a dedicated auxiliary connector.
• The two connectors are electrically and functionally distinct.
వివరణ:
Question 170
ప్రశ్న 170
A PC loses date/time after long power-off periods but retains installed software and files. Which conclusion is strongest?
Explanation:
• The coin-cell maintains RTC information while main power is absent.
• User files persist because SSD/HDD storage is nonvolatile.
• The symptom specifically points to RTC backup power rather than data storage.
• User files persist because SSD/HDD storage is nonvolatile.
• The symptom specifically points to RTC backup power rather than data storage.
వివరణ:
Question 171
ప్రశ్న 171
Which statement correctly distinguishes scanner and printer roles?
Explanation:
• A scanner captures information from physical media into the computer.
• A printer produces physical output from digital data.
• Their primary data directions are opposite.
• A printer produces physical output from digital data.
• Their primary data directions are opposite.
వివరణ:
Question 172
ప్రశ్న 172
A taken conditional branch changes normal sequential execution. Which register must receive the branch target address?
Explanation:
• The Program Counter determines the next instruction fetch address.
• A taken branch modifies that address.
• The Instruction Register still represents the current instruction.
• A taken branch modifies that address.
• The Instruction Register still represents the current instruction.
వివరణ:
Question 173
ప్రశ్న 173
What does =ROUNDUP(-18.701,2) return?
Explanation:
• ROUNDUP rounds away from zero.
• At two decimals, -18.701 becomes -18.71.
• It does not round toward zero.
• At two decimals, -18.701 becomes -18.71.
• It does not round toward zero.
వివరణ:
Question 174
ప్రశ్న 174
Which mechanism prevents one process from freely overwriting another process's protected memory?
Explanation:
• Memory protection enforces address-space boundaries.
• It improves security and stability.
• The other options are unrelated.
• It improves security and stability.
• The other options are unrelated.
వివరణ:
Question 175
ప్రశ్న 175
Which memory type is commonly used for large-capacity main memory?
Explanation:
• DRAM offers high density and relatively low cost per bit.
• It is therefore common for system RAM.
• SRAM is typically used for smaller caches.
• It is therefore common for system RAM.
• SRAM is typically used for smaller caches.
వివరణ:
Question 176
ప్రశ్న 176
A byte-addressable system has 24 address lines. What is the maximum directly addressable space?
Explanation:
• 24 address bits provide 2^24 addresses.
• With byte addressing, that is 2^24 bytes.
• 2^24 bytes equals 16 MiB.
• With byte addressing, that is 2^24 bytes.
• 2^24 bytes equals 16 MiB.
వివరణ:
Question 177
ప్రశ్న 177
Antivirus quarantines a legitimate executable as malware. What is this classification?
Explanation:
• A false positive incorrectly flags benign content.
• It can cause unnecessary disruption.
• A false negative instead misses actual malware.
• It can cause unnecessary disruption.
• A false negative instead misses actual malware.
వివరణ:
Question 178
ప్రశ్న 178
Which statement about a motherboard chipset/platform controller is correct?
Explanation:
• The platform controller handles motherboard I/O functions.
• The CPU's ALU performs arithmetic/logic operations.
• The chipset is neither primary storage nor a printer component.
• The CPU's ALU performs arithmetic/logic operations.
• The chipset is neither primary storage nor a printer component.
వివరణ:
Question 179
ప్రశ్న 179
Which feature inserts reference notes at the bottom of the same page?
Explanation:
• Footnotes appear at the bottom of the current page.
• They are linked to reference markers in the body text.
• Endnotes are normally collected later.
• They are linked to reference markers in the body text.
• Endnotes are normally collected later.
వివరణ:
Question 180
ప్రశ్న 180
Which feature combines one main document with records from an Excel recipient list?
Explanation:
• Mail Merge inserts data fields into a common document.
• Excel can serve as a data source.
• This produces personalized letters/labels efficiently.
• Excel can serve as a data source.
• This produces personalized letters/labels efficiently.
వివరణ:
Question 181
ప్రశ్న 181
Which order correctly represents the normal hierarchy from fastest to slowest?
Explanation:
• Registers are the fastest storage closest to execution units.
• Cache is faster than main memory.
• Secondary storage is much slower but larger.
• Cache is faster than main memory.
• Secondary storage is much slower but larger.
వివరణ:
Question 182
ప్రశ్న 182
Which mechanism produces a one-way digest useful for integrity verification?
Explanation:
• Hash functions map data to fixed-size digests.
• They are designed to be one-way.
• Digest comparison can reveal modifications.
• They are designed to be one-way.
• Digest comparison can reveal modifications.
వివరణ:
Question 183
ప్రశ్న 183
Which feature can make a shape jump to another slide during the presentation?
Explanation:
• Actions/hyperlinks can navigate to specified slides.
• They support interactive presentations.
• The other features do not provide navigation.
• They support interactive presentations.
• The other features do not provide navigation.
వివరణ:
Question 184
ప్రశ్న 184
Process P1's execution state is saved and P2's saved state is restored. What is this called?
Explanation:
• A context switch saves the outgoing task's CPU state.
• It restores another task's execution state.
• This allows the processor to switch between tasks.
• It restores another task's execution state.
• This allows the processor to switch between tasks.
వివరణ:
Question 185
ప్రశ్న 185
In an advanced Paper III scenario, which service resolves domain names into resource records such as IP addresses?
Explanation:
• DNS provides distributed name resolution.
• It maps names to resource records.
• DHCP performs host configuration instead.
• It maps names to resource records.
• DHCP performs host configuration instead.
వివరణ:
Question 186
ప్రశ్న 186
T1 repeats a range query and sees extra rows inserted and committed by T2. What anomaly is this?
Explanation:
• Phantoms change the set of rows satisfying a predicate.
• Concurrent inserts/deletes are common causes.
• This differs from rereading one changed row.
• Concurrent inserts/deletes are common causes.
• This differs from rereading one changed row.
వివరణ:
Question 187
ప్రశ్న 187
A firewall allows TCP port 443 but cannot inspect encrypted HTTPS payloads. Which statement is most accurate?
Explanation:
• A firewall can permit traffic based on IP/protocol/port metadata.
• Encrypted payload inspection requires additional TLS-inspection capability.
• Port permission alone does not reveal encrypted application content.
• Encrypted payload inspection requires additional TLS-inspection capability.
• Port permission alone does not reveal encrypted application content.
వివరణ:
Question 188
ప్రశ్న 188
Which statement about a database view is correct?
Explanation:
• A view presents query-derived data.
• It usually stores the query definition rather than duplicating all rows.
• It is a logical database object.
• It usually stores the query definition rather than duplicating all rows.
• It is a logical database object.
వివరణ:
Question 189
ప్రశ్న 189
B2:B7 contain East, West, East, North, East, West and C2:C7 contain 45, 55, 65, 75, 85, 95. What does =SUMIFS(C2:C7,B2:B7,"East",C2:C7,">70") return?
Explanation:
• East rows contain 45, 65 and 85.
• Only 85 is strictly greater than 70.
• Therefore SUMIFS returns 85.
• Only 85 is strictly greater than 70.
• Therefore SUMIFS returns 85.
వివరణ:
Question 190
ప్రశ్న 190
A computer has 64 GiB of RAM. Using 1 GiB = 1024 MiB, what is this in MiB?
Explanation:
• 64 × 1024 = 65536.
• Binary unit conversion uses 1024 MiB per GiB.
• Therefore 64 GiB equals 65536 MiB.
• Binary unit conversion uses 1024 MiB per GiB.
• Therefore 64 GiB equals 65536 MiB.
వివరణ:
Question 191
ప్రశ్న 191
Which technology converts scanned printed text into editable/searchable characters?
Explanation:
• OCR recognizes character shapes from image data.
• It converts scanned text into machine-readable form.
• OMR and MICR serve different input functions.
• It converts scanned text into machine-readable form.
• OMR and MICR serve different input functions.
వివరణ:
Question 192
ప్రశ్న 192
Which statement about preemptive scheduling is correct?
Explanation:
• Preemptive scheduling allows forced CPU reallocation.
• It supports time slicing and priority scheduling.
• It is unrelated to storage redundancy.
• It supports time slicing and priority scheduling.
• It is unrelated to storage redundancy.
వివరణ:
Question 193
ప్రశ్న 193
Which ACID property requires committed changes to remain persistent after a crash?
Explanation:
• Durability concerns persistence after COMMIT.
• Recovery mechanisms help preserve committed effects.
• Atomicity concerns all-or-nothing behavior.
• Recovery mechanisms help preserve committed effects.
• Atomicity concerns all-or-nothing behavior.
వివరణ:
Question 194
ప్రశ్న 194
A desktop is completely dead after assembly. The PSU self-test is normal. Which motherboard-side checks should be performed before replacing the board?
Explanation:
• A dead pre-POST system should be troubleshot at the power and physical-assembly level.
• Missing CPU power or incorrect front-panel wiring can prevent startup.
• Improper standoffs can also create electrical shorts.
• Missing CPU power or incorrect front-panel wiring can prevent startup.
• Improper standoffs can also create electrical shorts.
వివరణ:
Question 195
ప్రశ్న 195
A document uses Heading styles consistently. Which pair of Word features benefits directly from that structure?
Explanation:
• Heading styles feed the Navigation Pane's heading hierarchy.
• They also provide structure for an automatic Table of Contents.
• The distractors belong to other Office applications.
• They also provide structure for an automatic Table of Contents.
• The distractors belong to other Office applications.
వివరణ:
Question 196
ప్రశ్న 196
Which statement about a classic bus topology is correct?
Explanation:
• Traditional bus networks use a shared medium.
• Terminators reduce reflected signals at the ends.
• That characteristic differs from star and mesh topologies.
• Terminators reduce reflected signals at the ends.
• That characteristic differs from star and mesh topologies.
వివరణ:
Question 197
ప్రశ్న 197
In an advanced Paper III scenario, which feature records narration and slide timings?
Explanation:
• Record Slide Show captures narration and timing.
• It supports recorded/self-running presentations.
• The distractors serve unrelated functions.
• It supports recorded/self-running presentations.
• The distractors serve unrelated functions.
వివరణ:
Question 198
ప్రశ్న 198
Which query type permanently removes qualifying records?
Explanation:
• Delete queries remove matching rows.
• They can affect many records at once.
• Criteria should be verified carefully before execution.
• They can affect many records at once.
• Criteria should be verified carefully before execution.
వివరణ:
Question 199
ప్రశ్న 199
In an advanced Paper III scenario, which statement correctly describes the Internet?
Explanation:
• The Internet connects many independently operated networks.
• TCP/IP is fundamental to this interconnection.
• It is much broader than one private organizational network.
• TCP/IP is fundamental to this interconnection.
• It is much broader than one private organizational network.
వివరణ:
Question 200
ప్రశ్న 200
Which feature controls entrance, emphasis, exit and motion-path effects on objects?
Explanation:
• Animations affect slide objects.
• They can be ordered and timed.
• Transitions apply between slides.
• They can be ordered and timed.
• Transitions apply between slides.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. Fuser assembly సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: C. Table సమాధానం: C.
-
Question 3 ప్రశ్న 3Answer: A. Disk Management సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: B. OMR సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. 4.5 ns సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: D. It gives processes a virtual address-space abstraction and can use secondary storage as backing for nonresident pages. సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: B. Application/camera privacy permission settings సమాధానం: B.
-
Question 8 ప్రశ్న 8Answer: B. LAN covers a local area, MAN typically spans a metropolitan area, and WAN spans large geographic distances. సమాధానం: B.
-
Question 9 ప్రశ్న 9Answer: B. MICR సమాధానం: B.
-
Question 10 ప్రశ్న 10Answer: D. The VPN protects communication but does not remove malware from the endpoint. సమాధానం: D.
-
Question 11 ప్రశ్న 11Answer: C. 192.168.10.128/26 సమాధానం: C.
-
Question 12 ప్రశ్న 12Answer: D. DHCP సమాధానం: D.
-
Question 13 ప్రశ్న 13Answer: C. Validation Rule సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: C. Query సమాధానం: C.
-
Question 15 ప్రశ్న 15Answer: D. 45 సమాధానం: D.
-
Question 16 ప్రశ్న 16Answer: C. 9 TB usable; one drive failure tolerated. సమాధానం: C.
-
Question 17 ప్రశ్న 17Answer: A. Find Unmatched Query Wizard సమాధానం: A.
-
Question 18 ప్రశ్న 18Answer: A. Temporal locality సమాధానం: A.
-
Question 19 ప్రశ్న 19Answer: B. Different First Page సమాధానం: B.
-
Question 20 ప్రశ్న 20Answer: D. The new CPU may be unsupported by the motherboard chipset/firmware despite socket compatibility. సమాధానం: D.
-
Question 21 ప్రశ్న 21Answer: C. RJ45 సమాధానం: C.
-
Question 22 ప్రశ్న 22Answer: A. Form సమాధానం: A.
-
Question 23 ప్రశ్న 23Answer: D. False negative సమాధానం: D.
-
Question 24 ప్రశ్న 24Answer: D. diskmgmt.msc సమాధానం: D.
-
Question 25 ప్రశ్న 25Answer: B. HTTPS సమాధానం: B.
-
Question 26 ప్రశ్న 26Answer: A. Default deny సమాధానం: A.
-
Question 27 ప్రశ్న 27Answer: C. Partial dependency; the table violates Second Normal Form. సమాధానం: C.
-
Question 28 ప్రశ్న 28Answer: C. 1, 2 and 3 are correct. సమాధానం: C.
-
Question 29 ప్రశ్న 29Answer: A. SSDs usually have much lower random-access latency because they have no mechanical seek operation. సమాధానం: A.
-
Question 30 ప్రశ్న 30Answer: A. Stateful firewall సమాధానం: A.
-
Question 31 ప్రశ్న 31Answer: B. An exclusive lock is generally used when a transaction must modify a protected data item so conflicting access can be restricted. సమాధానం: B.
-
Question 32 ప్రశ్న 32Answer: C. SRAM is faster and does not require periodic refresh; DRAM is denser and requires refresh. సమాధానం: C.
-
Question 33 ప్రశ్న 33Answer: C. 24 సమాధానం: C.
-
Question 34 ప్రశ్న 34Answer: C. COUNTBLANK సమాధానం: C.
-
Question 35 ప్రశ్న 35Answer: A. Parameter query సమాధానం: A.
-
Question 36 ప్రశ్న 36Answer: D. EPROM సమాధానం: D.
-
Question 37 ప్రశ్న 37Answer: D. Running → Waiting/Blocked సమాధానం: D.
-
Question 38 ప్రశ్న 38Answer: A. 144 సమాధానం: A.
-
Question 39 ప్రశ్న 39Answer: C. Large-format plotter/printer సమాధానం: C.
-
Question 40 ప్రశ్న 40Answer: A. ATTRIB -R filename సమాధానం: A.
-
Question 41 ప్రశ్న 41Answer: B. =SUBTOTAL(9,E2:E500) సమాధానం: B.
-
Question 42 ప్రశ్న 42Answer: B. Excessive page faults and paging dominate system activity, leaving little useful execution. సమాధానం: B.
-
Question 43 ప్రశ్న 43Answer: C. Application-proxy gateway సమాధానం: C.
-
Question 44 ప్రశ్న 44Answer: A. A program in execution together with its current state and allocated resources. సమాధానం: A.
-
Question 45 ప్రశ్న 45Answer: A. Microphone సమాధానం: A.
-
Question 46 ప్రశ్న 46Answer: A. A main form with a linked subform సమాధానం: A.
-
Question 47 ప్రశ్న 47Answer: B. Input Mask సమాధానం: B.
-
Question 48 ప్రశ్న 48Answer: A. DIVERR సమాధానం: A.
-
Question 49 ప్రశ్న 49Answer: B. Number with Field Size Long Integer సమాధానం: B.
-
Question 50 ప్రశ్న 50Answer: A. Switch సమాధానం: A.
-
Question 51 ప్రశ్న 51Answer: D. Distribute Horizontally సమాధానం: D.
-
Question 52 ప్రశ్న 52Answer: D. APIPA/IPv4 link-local addressing సమాధానం: D.
-
Question 53 ప్రశ్న 53Answer: C. 4 TB సమాధానం: C.
-
Question 54 ప్రశ్న 54Answer: D. POST is firmware-controlled hardware initialization/checking; the boot loader later loads or starts the operating system. సమాధానం: D.
-
Question 55 ప్రశ్న 55Answer: B. It references a key in another related table and can be constrained by referential integrity. సమాధానం: B.
-
Question 56 ప్రశ్న 56Answer: B. DNS సమాధానం: B.
-
Question 57 ప్రశ్న 57Answer: B. The printer's imaging/fuser path, especially a rotating component associated with the repeating interval. సమాధానం: B.
-
Question 58 ప్రశ్న 58Answer: B. Conditional Formatting సమాధానం: B.
-
Question 59 ప్రశ్న 59Answer: A. MD CASEFILES సమాధానం: A.
-
Question 60 ప్రశ్న 60Answer: D. Scanner సమాధానం: D.
-
Question 61 ప్రశ్న 61Answer: D. They are in different /24 networks and normally require a router to communicate. సమాధానం: D.
-
Question 62 ప్రశ్న 62Answer: D. Modify the style definition సమాధానం: D.
-
Question 63 ప్రశ్న 63Answer: A. Index సమాధానం: A.
-
Question 64 ప్రశ్న 64Answer: A. Print Spooler service సమాధానం: A.
-
Question 65 ప్రశ్న 65Answer: C. Goal Seek సమాధానం: C.
-
Question 66 ప్రశ్న 66Answer: C. Site-to-site VPN సమాధానం: C.
-
Question 67 ప్రశ్న 67Answer: C. Transition సమాధానం: C.
-
Question 68 ప్రశ్న 68Answer: A. SSD సమాధానం: A.
-
Question 69 ప్రశ్న 69Answer: A. Spooling సమాధానం: A.
-
Question 70 ప్రశ్న 70Answer: B. Report సమాధానం: B.
-
Question 71 ప్రశ్న 71Answer: B. Update query సమాధానం: B.
-
Question 72 ప్రశ్న 72Answer: C. Different Odd & Even Pages సమాధానం: C.
-
Question 73 ప్రశ్న 73Answer: A. Navigation Pane సమాధానం: A.
-
Question 74 ప్రశ్న 74Answer: A. M.2 describes a physical form factor/interface family; a slot may support SATA, PCIe/NVMe or both depending on implementation. సమాధానం: A.
-
Question 75 ప్రశ్న 75Answer: C. An intranet resource సమాధానం: C.
-
Question 76 ప్రశ్న 76Answer: C. Demand paging సమాధానం: C.
-
Question 77 ప్రశ్న 77Answer: A. Cardinality = 3,200; Degree = 14 సమాధానం: A.
-
Question 78 ప్రశ్న 78Answer: B. 48 GiB సమాధానం: B.
-
Question 79 ప్రశ్న 79Answer: D. 103 సమాధానం: D.
-
Question 80 ప్రశ్న 80Answer: A. Update the Table of Contents సమాధానం: A.
-
Question 81 ప్రశ్న 81Answer: D. Both are knowledge factors. సమాధానం: D.
-
Question 82 ప్రశ్న 82Answer: B. Restrict Editing సమాధానం: B.
-
Question 83 ప్రశ్న 83Answer: D. 96% సమాధానం: D.
-
Question 84 ప్రశ్న 84Answer: C. Device driver సమాధానం: C.
-
Question 85 ప్రశ్న 85Answer: B. Slide Master సమాధానం: B.
-
Question 86 ప్రశ్న 86Answer: D. Crosstab query సమాధానం: D.
-
Question 87 ప్రశ్న 87Answer: B. UPS సమాధానం: B.
-
Question 88 ప్రశ్న 88Answer: C. 3 సమాధానం: C.
-
Question 89 ప్రశ్న 89Answer: B. Referential integrity సమాధానం: B.
-
Question 90 ప్రశ్న 90Answer: B. Spatial locality సమాధానం: B.
-
Question 91 ప్రశ్న 91Answer: B. Services console and Event Viewer సమాధానం: B.
-
Question 92 ప్రశ్న 92Answer: A. Insufficient or unstable PSU output under peak load. సమాధానం: A.
-
Question 93 ప్రశ్న 93Answer: A. Data Validation with a List సమాధానం: A.
-
Question 94 ప్రశ్న 94Answer: B. eventvwr.msc సమాధానం: B.
-
Question 95 ప్రశ్న 95Answer: C. devmgmt.msc సమాధానం: C.
-
Question 96 ప్రశ్న 96Answer: D. services.msc సమాధానం: D.
-
Question 97 ప్రశ్న 97Answer: D. The requested block is not present in the checked cache, so a lower memory level must be accessed. సమాధానం: D.
-
Question 98 ప్రశ్న 98Answer: B. Presenter View సమాధానం: B.
-
Question 99 ప్రశ్న 99Answer: A. RJ45 సమాధానం: A.
-
Question 100 ప్రశ్న 100Answer: A. 8 TB సమాధానం: A.
-
Question 101 ప్రశ్న 101Answer: C. Front-panel USB cable/header connection or front-port hardware సమాధానం: C.
-
Question 102 ప్రశ్న 102Answer: B. Slide Sorter సమాధానం: B.
-
Question 103 ప్రశ్న 103Answer: A. Atomicity సమాధానం: A.
-
Question 104 ప్రశ్న 104Answer: D. A transitive dependency that can violate Third Normal Form. సమాధానం: D.
-
Question 105 ప్రశ్న 105Answer: B. Lost update సమాధానం: B.
-
Question 106 ప్రశ్న 106Answer: C. Interrupt సమాధానం: C.
-
Question 107 ప్రశ్న 107Answer: B. Poor heat-sink contact or incorrect thermal-interface application. సమాధానం: B.
-
Question 108 ప్రశ్న 108Answer: A. Failure of the central switch can affect all nodes, while one endpoint cable failure usually affects only that endpoint. సమాధానం: A.
-
Question 109 ప్రశ్న 109Answer: B. EEPROM సమాధానం: B.
-
Question 110 ప్రశ్న 110Answer: A. Non-repeatable read సమాధానం: A.
-
Question 111 ప్రశ్న 111Answer: C. TREE /F సమాధానం: C.
-
Question 112 ప్రశ్న 112Answer: A. PivotTable సమాధానం: A.
-
Question 113 ప్రశ్న 113Answer: C. Run DISM /Online /Cleanup-Image /RestoreHealth, then run sfc /scannow. సమాధానం: C.
-
Question 114 ప్రశ్న 114Answer: A. User Account Control (UAC) సమాధానం: A.
-
Question 115 ప్రశ్న 115Answer: B. Ready సమాధానం: B.
-
Question 116 ప్రశ్న 116Answer: C. File-system management సమాధానం: C.
-
Question 117 ప్రశ్న 117Answer: A. Page fault సమాధానం: A.
-
Question 118 ప్రశ్న 118Answer: B. It requires power to retain stored contents. సమాధానం: B.
-
Question 119 ప్రశ్న 119Answer: C. Control Unit సమాధానం: C.
-
Question 120 ప్రశ్న 120Answer: C. ECC సమాధానం: C.
-
Question 121 ప్రశ్న 121Answer: A. Thrashing సమాధానం: A.
-
Question 122 ప్రశ్న 122Answer: B. Notes Pages సమాధానం: B.
-
Question 123 ప్రశ్న 123Answer: C. =$B6+E$1+F6 సమాధానం: C.
-
Question 124 ప్రశ్న 124Answer: A. ipconfig /flushdns సమాధానం: A.
-
Question 125 ప్రశ్న 125Answer: C. Connect the cooler fan to the CPU_FAN header and verify monitoring/control. సమాధానం: C.
-
Question 126 ప్రశ్న 126Answer: C. CHECK constraint సమాధానం: C.
-
Question 127 ప్రశ్న 127Answer: B. Find and Replace సమాధానం: B.
-
Question 128 ప్రశ్న 128Answer: C. Dot-matrix printer సమాధానం: C.
-
Question 129 ప్రశ్న 129Answer: C. Scheduler సమాధానం: C.
-
Question 130 ప్రశ్న 130Answer: C. A private organizational network/information environment intended mainly for authorized users సమాధానం: C.
-
Question 131 ప్రశ్న 131Answer: D. Format Painter సమాధానం: D.
-
Question 132 ప్రశ్న 132Answer: D. The cloned disk may not contain a UEFI-compatible boot configuration; firmware mode and disk boot structure must be made compatible. సమాధానం: D.
-
Question 133 ప్రశ్న 133Answer: B. Knowledge and possession సమాధానం: B.
-
Question 134 ప్రశ్న 134Answer: A. =G$2+$E8+I8 సమాధానం: A.
-
Question 135 ప్రశ్న 135Answer: D. User mode and kernel mode సమాధానం: D.
-
Question 136 ప్రశ్న 136Answer: B. DIR /A సమాధానం: B.
-
Question 137 ప్రశ్న 137Answer: A. Verify the selected input, video cable, and connection to the active graphics output. సమాధానం: A.
-
Question 138 ప్రశ్న 138Answer: C. 1 సమాధానం: C.
-
Question 139 ప్రశ్న 139Answer: C. Track Changes సమాధానం: C.
-
Question 140 ప్రశ్న 140Answer: D. 216 సమాధానం: D.
-
Question 141 ప్రశ్న 141Answer: D. Traditional PROM is intended to be programmed once and is not routinely erasable. సమాధానం: D.
-
Question 142 ప్రశ్న 142Answer: C. netstat సమాధానం: C.
-
Question 143 ప్రశ్న 143Answer: D. Custom Slide Show సమాధానం: D.
-
Question 144 ప్రశ్న 144Answer: D. tracert సమాధానం: D.
-
Question 145 ప్రశ్న 145Answer: D. SELECT సమాధానం: D.
-
Question 146 ప్రశ్న 146Answer: B. Make-table query సమాధానం: B.
-
Question 147 ప్రశ్న 147Answer: C. Deadlock సమాధానం: C.
-
Question 148 ప్రశ్న 148Answer: A. 91.45 సమాధానం: A.
-
Question 149 ప్రశ్న 149Answer: C. COUNTA సమాధానం: C.
-
Question 150 ప్రశ్న 150Answer: A. Compare Documents సమాధానం: A.
-
Question 151 ప్రశ్న 151Answer: D. Router సమాధానం: D.
-
Question 152 ప్రశ్న 152Answer: B. Encryption సమాధానం: B.
-
Question 153 ప్రశ్న 153Answer: B. It stripes data for performance/capacity but provides no redundancy. సమాధానం: B.
-
Question 154 ప్రశ్న 154Answer: C. SRAM సమాధానం: C.
-
Question 155 ప్రశ్న 155Answer: B. Deadlock సమాధానం: B.
-
Question 156 ప్రశ్న 156Answer: D. Authentication verifies identity; authorization determines permitted actions/resources. సమాధానం: D.
-
Question 157 ప్రశ్న 157Answer: D. Decode సమాధానం: D.
-
Question 158 ప్రశ్న 158Answer: D. It uniquely identifies each row and cannot contain Null. సమాధానం: D.
-
Question 159 ప్రశ్న 159Answer: B. ipconfig /all సమాధానం: B.
-
Question 160 ప్రశ్న 160Answer: B. Reseat or replace the SATA data cable and verify SATA power connection. సమాధానం: B.
-
Question 161 ప్రశ్న 161Answer: C. DIMM slot సమాధానం: C.
-
Question 162 ప్రశ్న 162Answer: C. Append query సమాధానం: C.
-
Question 163 ప్రశ్న 163Answer: B. COMMIT makes a successful transaction's changes permanent; ROLLBACK reverses applicable uncommitted changes. సమాధానం: B.
-
Question 164 ప్రశ్న 164Answer: A. Serializable సమాధానం: A.
-
Question 165 ప్రశ్న 165Answer: D. Section Break సమాధానం: D.
-
Question 166 ప్రశ్న 166Answer: D. Dirty read సమాధానం: D.
-
Question 167 ప్రశ్న 167Answer: A. Stateless packet filter సమాధానం: A.
-
Question 168 ప్రశ్న 168Answer: D. Connect the monitor to the discrete GPU's output and verify firmware graphics settings. సమాధానం: D.
-
Question 169 ప్రశ్న 169Answer: D. The 24-pin connector supplies main motherboard power; the CPU auxiliary connector supplies dedicated processor power. సమాధానం: D.
-
Question 170 ప్రశ్న 170Answer: A. The RTC/CMOS coin-cell battery is likely weak; storage media are not implicated by this symptom. సమాధానం: A.
-
Question 171 ప్రశ్న 171Answer: A. A scanner is primarily an input device, while a printer is primarily an output device. సమాధానం: A.
-
Question 172 ప్రశ్న 172Answer: A. Program Counter సమాధానం: A.
-
Question 173 ప్రశ్న 173Answer: C. -18.71 సమాధానం: C.
-
Question 174 ప్రశ్న 174Answer: C. Memory protection సమాధానం: C.
-
Question 175 ప్రశ్న 175Answer: B. DRAM సమాధానం: B.
-
Question 176 ప్రశ్న 176Answer: B. 16 MiB సమాధానం: B.
-
Question 177 ప్రశ్న 177Answer: A. False positive సమాధానం: A.
-
Question 178 ప్రశ్న 178Answer: D. It supports and coordinates platform I/O/connectivity functions rather than replacing the CPU's ALU. సమాధానం: D.
-
Question 179 ప్రశ్న 179Answer: D. Footnote సమాధానం: D.
-
Question 180 ప్రశ్న 180Answer: D. Mail Merge సమాధానం: D.
-
Question 181 ప్రశ్న 181Answer: C. Registers → Cache → RAM → SSD/HDD సమాధానం: C.
-
Question 182 ప్రశ్న 182Answer: A. Cryptographic hash function సమాధానం: A.
-
Question 183 ప్రశ్న 183Answer: B. Action or Hyperlink సమాధానం: B.
-
Question 184 ప్రశ్న 184Answer: D. Context switch సమాధానం: D.
-
Question 185 ప్రశ్న 185Answer: B. DNS సమాధానం: B.
-
Question 186 ప్రశ్న 186Answer: D. Phantom read సమాధానం: D.
-
Question 187 ప్రశ్న 187Answer: D. Header-level permission can allow the connection even when payload content remains opaque without TLS inspection/decryption. సమాధానం: D.
-
Question 188 ప్రశ్న 188Answer: D. A conventional view is a virtual table defined by a query over underlying data. సమాధానం: D.
-
Question 189 ప్రశ్న 189Answer: D. 85 సమాధానం: D.
-
Question 190 ప్రశ్న 190Answer: D. 65536 MiB సమాధానం: D.
-
Question 191 ప్రశ్న 191Answer: D. OCR సమాధానం: D.
-
Question 192 ప్రశ్న 192Answer: C. The operating system may interrupt a running task and schedule another runnable task. సమాధానం: C.
-
Question 193 ప్రశ్న 193Answer: D. Durability సమాధానం: D.
-
Question 194 ప్రశ్న 194Answer: C. Verify the 24-pin ATX connector, CPU auxiliary power connector, front-panel power-switch pins and possible shorts/standoffs. సమాధానం: C.
-
Question 195 ప్రశ్న 195Answer: A. Navigation Pane and automatic Table of Contents సమాధానం: A.
-
Question 196 ప్రశ్న 196Answer: A. The shared backbone should be properly terminated at both ends to reduce signal reflections. సమాధానం: A.
-
Question 197 ప్రశ్న 197Answer: B. Record Slide Show సమాధానం: B.
-
Question 198 ప్రశ్న 198Answer: D. Delete query సమాధానం: D.
-
Question 199 ప్రశ్న 199Answer: A. A global system of interconnected networks using standard networking protocols సమాధానం: A.
-
Question 200 ప్రశ్న 200Answer: C. Animation సమాధానం: C.
