Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
A CPU begins overheating immediately after its cooler has been reinstalled. What is the most appropriate first action?
Explanation:
• The timing of the fault strongly points to the cooling installation.
• Poor heatsink contact, fan failure or incorrect thermal material can cause rapid temperature rise.
• Continuing to stress an overheating CPU can worsen the problem.
• Poor heatsink contact, fan failure or incorrect thermal material can cause rapid temperature rise.
• Continuing to stress an overheating CPU can worsen the problem.
వివరణ:
Question 2
ప్రశ్న 2
Which action is the main purpose of antivirus quarantine?
Explanation:
• Quarantine places a detected item in a controlled isolated state.
• This prevents ordinary use or execution while allowing later review, deletion or restoration if appropriate.
• It is a containment mechanism rather than privilege escalation.
• This prevents ordinary use or execution while allowing later review, deletion or restoration if appropriate.
• It is a containment mechanism rather than privilege escalation.
వివరణ:
Question 3
ప్రశ్న 3
What is the primary purpose of User Account Control (UAC)?
Explanation:
• UAC reduces routine use of unrestricted administrative privileges.
• Operations requiring elevation can prompt for consent or administrator credentials.
• It supports least privilege but does not replace malware protection.
• Operations requiring elevation can prompt for consent or administrator credentials.
• It supports least privilege but does not replace malware protection.
వివరణ:
Question 4
ప్రశ్న 4
Two independently edited versions of the same Word document must be checked for differences. Which feature is most appropriate?
Explanation:
• Compare identifies differences between two document versions.
• It is useful when changes were made separately rather than recorded live by Track Changes.
• Format Painter copies formatting but does not compare document revisions.
• It is useful when changes were made separately rather than recorded live by Track Changes.
• Format Painter copies formatting but does not compare document revisions.
వివరణ:
Question 5
ప్రశ్న 5
Which component of the CPU directs and coordinates the execution of instructions?
Explanation:
• The Control Unit interprets instructions and directs the sequence of operations.
• The ALU performs arithmetic and logical operations under that control.
• Both are central to CPU operation but serve different functions.
• The ALU performs arithmetic and logical operations under that control.
• Both are central to CPU operation but serve different functions.
వివరణ:
Question 6
ప్రశ్న 6
A 50-page report uses Heading styles correctly. Which feature can automatically create a list of headings with page numbers?
Explanation:
• Word can generate an automatic Table of Contents from heading styles.
• The table can be updated when headings or pagination change.
• Mail Merge and Format Painter serve unrelated purposes.
• The table can be updated when headings or pagination change.
• Mail Merge and Format Painter serve unrelated purposes.
వివరణ:
Question 7
ప్రశ్న 7
Which statement correctly distinguishes authentication from authorization?
Explanation:
• Authentication establishes confidence in an identity claim.
• Authorization determines what an authenticated entity may access or do.
• They are related but distinct access-control functions.
• Authorization determines what an authenticated entity may access or do.
• They are related but distinct access-control functions.
వివరణ:
Question 8
ప్రశ్న 8
Which Word feature displays document headings in a hierarchical pane for quick navigation when heading styles are used?
Explanation:
• The Navigation Pane can display structured document headings.
• Users can click headings to move quickly through long documents.
• Correct heading styles are important for this hierarchy.
• Users can click headings to move quickly through long documents.
• Correct heading styles are important for this hierarchy.
వివరణ:
Question 9
ప్రశ్న 9
Four identical 3 TB drives are configured as RAID 5. Ignoring overhead, what is the approximate usable capacity?
Explanation:
• RAID 5 usable capacity is approximately (N−1) times the smallest drive capacity.
• With four 3 TB drives, (4−1)×3 TB = 9 TB.
• The equivalent capacity of one drive is consumed by distributed parity.
• With four 3 TB drives, (4−1)×3 TB = 9 TB.
• The equivalent capacity of one drive is consumed by distributed parity.
వివరణ:
Question 10
ప్రశ్న 10
Which statement about RAM is correct?
Explanation:
• Main-memory RAM stores active programs and data while the system is running.
• Ordinary RAM is volatile, so its contents are not retained without power.
• Persistent files are normally stored on non-volatile secondary storage.
• Ordinary RAM is volatile, so its contents are not retained without power.
• Persistent files are normally stored on non-volatile secondary storage.
వివరణ:
Question 11
ప్రశ్న 11
B2:B6 contain {East,West,East,East,West} and C2:C6 contain {100,200,300,400,500}. What does =SUMIF(B2:B6,"East",C2:C6) return?
Explanation:
• The East rows correspond to amounts 100, 300 and 400.
• SUMIF adds the sum-range values whose criterion-range entries match East.
• 100+300+400 = 800.
• SUMIF adds the sum-range values whose criterion-range entries match East.
• 100+300+400 = 800.
వివరణ:
Question 12
ప్రశ్న 12
Cell D2 contains =$A2*B$1. If copied to F5, what formula appears?
Explanation:
• The move from D2 to F5 is two columns right and three rows down.
• $A2 keeps column A fixed while row 2 becomes 5; B$1 keeps row 1 fixed while column B becomes D.
• The copied formula is therefore =$A5*D$1.
• $A2 keeps column A fixed while row 2 becomes 5; B$1 keeps row 1 fixed while column B becomes D.
• The copied formula is therefore =$A5*D$1.
వివరణ:
Question 13
ప్రశ్న 13
Which component provides regulated DC power to internal desktop PC components?
Explanation:
• The switched-mode power supply converts incoming electrical power to regulated DC outputs.
• Motherboards, storage devices and expansion hardware depend on these supply rails.
• NICs and scanners handle networking and input rather than power conversion.
• Motherboards, storage devices and expansion hardware depend on these supply rails.
• NICs and scanners handle networking and input rather than power conversion.
వివరణ:
Question 14
ప్రశ్న 14
Which condition occurs when two processes each wait indefinitely for a resource held by the other?
Explanation:
• Deadlock can occur when processes form a circular wait for resources.
• Neither can proceed unless the operating system or application breaks the cycle.
• Thrashing and spooling are different memory and I/O phenomena.
• Neither can proceed unless the operating system or application breaks the cycle.
• Thrashing and spooling are different memory and I/O phenomena.
వివరణ:
Question 15
ప్రశ్న 15
A Windows service should start automatically when the operating system boots. Which startup type is appropriate?
Explanation:
• Automatic startup instructs Windows to start the service during the normal boot process.
• Manual requires a trigger or explicit start, while Disabled prevents normal startup.
• Startup type and current service state are separate settings.
• Manual requires a trigger or explicit start, while Disabled prevents normal startup.
• Startup type and current service state are separate settings.
వివరణ:
Question 16
ప్రశ్న 16
Which statement about buses in a computer system is correct?
Explanation:
• System buses provide communication paths among processors, memory and devices.
• Data, address and control information may use logically distinct bus functions.
• A bus is an interconnection mechanism rather than a storage device.
• Data, address and control information may use logically distinct bus functions.
• A bus is an interconnection mechanism rather than a storage device.
వివరణ:
Question 17
ప్రశ్న 17
Which Windows console is most appropriate for creating, deleting and resizing disk volumes?
Explanation:
• Disk Management provides graphical administration of disks, partitions and volumes.
• It can assign drive letters and perform supported volume operations.
• Task Manager monitors processes and performance instead.
• It can assign drive letters and perform supported volume operations.
• Task Manager monitors processes and performance instead.
వివరణ:
Question 18
ప్రశ్న 18
What is a context switch?
Explanation:
• A context switch allows the processor to stop one task and resume another.
• Registers and other execution state must be saved and restored.
• Context switching enables multitasking but introduces some overhead.
• Registers and other execution state must be saved and restored.
• Context switching enables multitasking but introduces some overhead.
వివరణ:
Question 19
ప్రశ్న 19
Which statement best describes an intranet?
Explanation:
• An intranet provides internal services to an organization's authorized users.
• It can use standard Internet technologies such as TCP/IP, HTTP and HTTPS.
• Controlled Internet connectivity does not make protected intranet resources public.
• It can use standard Internet technologies such as TCP/IP, HTTP and HTTPS.
• Controlled Internet connectivity does not make protected intranet resources public.
వివరణ:
Question 20
ప్రశ్న 20
Which dependency is principally addressed when moving a suitable 2NF relation to 3NF?
Explanation:
• 3NF removes problematic transitive dependencies of non-key attributes.
• A non-key attribute should depend on the key rather than indirectly through another non-key attribute.
• This reduces redundancy and update anomalies.
• A non-key attribute should depend on the key rather than indirectly through another non-key attribute.
• This reduces redundancy and update anomalies.
వివరణ:
Question 21
ప్రశ్న 21
Which feature can reduce the file size of supported embedded audio and video in a presentation?
Explanation:
• Compress Media reduces the size of supported embedded media files.
• Compression may trade some quality for smaller presentation size.
• The other options do not perform media compression.
• Compression may trade some quality for smaller presentation size.
• The other options do not perform media compression.
వివరణ:
Question 22
ప్రశ్న 22
Which protocol is primarily used to transfer web pages securely between a browser and web server?
Explanation:
• HTTPS is HTTP carried over TLS-protected communication.
• It provides encrypted web transport and server authentication when certificates are properly validated.
• SMTP and POP3 are email protocols.
• It provides encrypted web transport and server authentication when certificates are properly validated.
• SMTP and POP3 are email protocols.
వివరణ:
Question 23
ప్రశ్న 23
A PC completes POST, detects the system SSD, but reports that no bootable device is available. What should be investigated first?
Explanation:
• Firmware detection shows that the SSD is visible at the hardware level.
• A no-boot condition can result from incorrect boot priority or missing/corrupted boot structures.
• Display and printer settings do not determine whether the SSD contains bootable software.
• A no-boot condition can result from incorrect boot priority or missing/corrupted boot structures.
• Display and printer settings do not determine whether the SSD contains bootable software.
వివరణ:
Question 24
ప్రశ్న 24
Which ordering represents typical geographical scope from smaller to larger?
Explanation:
• A LAN normally covers a limited local area.
• A MAN spans a metropolitan region and a WAN covers much larger geographic distances.
• The progression is therefore LAN, MAN, WAN.
• A MAN spans a metropolitan region and a WAN covers much larger geographic distances.
• The progression is therefore LAN, MAN, WAN.
వివరణ:
Question 25
ప్రశ్న 25
Which statement correctly distinguishes a process from a program?
Explanation:
• A program is a set of instructions stored in a file or other medium.
• A process is a running instance with execution state, memory and operating-system resources.
• Multiple processes can execute instances of the same program.
• A process is a running instance with execution state, memory and operating-system resources.
• Multiple processes can execute instances of the same program.
వివరణ:
Question 26
ప్రశ్న 26
Cells A1:A4 contain 10, 20, 30 and 40. What does =AVERAGE(A1:A4) return?
Explanation:
• The four values total 100.
• AVERAGE divides the sum by the count of numeric values: 100÷4 = 25.
• The function returns the arithmetic mean.
• AVERAGE divides the sum by the count of numeric values: 100÷4 = 25.
• The function returns the arithmetic mean.
వివరణ:
Question 27
ప్రశ్న 27
Which display interface can carry both digital video and audio and is common on televisions and computer displays?
Explanation:
• HDMI carries digital video and audio over one connection.
• It is widely used for monitors, televisions and multimedia devices.
• PS/2, parallel and RJ11 connectors serve different purposes.
• It is widely used for monitors, televisions and multimedia devices.
• PS/2, parallel and RJ11 connectors serve different purposes.
వివరణ:
Question 28
ప్రశ్న 28
Which CPU register typically holds the address of the next instruction to be fetched?
Explanation:
• The Program Counter tracks the address of the next instruction.
• Branches and interrupts can change its value.
• The Instruction Register instead holds the instruction currently being decoded or executed.
• Branches and interrupts can change its value.
• The Instruction Register instead holds the instruction currently being decoded or executed.
వివరణ:
Question 29
ప్రశ్న 29
Six identical 2 TB drives are configured as RAID 6. Ignoring overhead, what is the approximate usable capacity?
Explanation:
• RAID 6 usable capacity is approximately (N−2)×drive capacity.
• With six 2 TB drives, (6−2)×2 TB = 8 TB.
• The equivalent capacity of two drives is used for dual parity.
• With six 2 TB drives, (6−2)×2 TB = 8 TB.
• The equivalent capacity of two drives is used for dual parity.
వివరణ:
Question 30
ప్రశ్న 30
Which effect controls how one slide changes to the next during a slide show?
Explanation:
• A transition is applied between slides.
• Animations affect objects within a slide.
• Themes control overall design rather than slide-to-slide motion.
• Animations affect objects within a slide.
• Themes control overall design rather than slide-to-slide motion.
వివరణ:
Question 31
ప్రశ్న 31
Which statement best describes a firewall?
Explanation:
• A firewall permits or blocks network communications according to configured policy.
• It can be implemented in software, hardware appliances or integrated systems.
• Its purpose is traffic control rather than storage or application authoring.
• It can be implemented in software, hardware appliances or integrated systems.
• Its purpose is traffic control rather than storage or application authoring.
వివరణ:
Question 32
ప్రశ్న 32
A main form shows one Case, and a related child object must show all EvidenceItems for that CaseID. Which design is most appropriate?
Explanation:
• A subform is well suited to displaying the many side of a one-to-many relationship.
• Link Master Fields and Link Child Fields can synchronize records through CaseID.
• This preserves relational structure instead of packing multiple child records into one field.
• Link Master Fields and Link Child Fields can synchronize records through CaseID.
• This preserves relational structure instead of packing multiple child records into one field.
వివరణ:
Question 33
ప్రశ్న 33
Which statement best describes a device driver?
Explanation:
• Device drivers implement the software interface between the OS and hardware devices.
• They translate generic operating-system requests into device-specific operations.
• Drivers are system software rather than hardware or database structures.
• They translate generic operating-system requests into device-specific operations.
• Drivers are system software rather than hardware or database structures.
వివరణ:
Question 34
ప్రశ్న 34
Consider the following statements about RAID:
1. RAID 5 normally tolerates one member-drive failure.
2. RAID 6 normally tolerates two member-drive failures.
3. RAID 0 provides no RAID-level redundancy.
4. RAID is a complete substitute for independent backups.
Which statements are correct?
1. RAID 5 normally tolerates one member-drive failure.
2. RAID 6 normally tolerates two member-drive failures.
3. RAID 0 provides no RAID-level redundancy.
4. RAID is a complete substitute for independent backups.
Which statements are correct?
Explanation:
• Statements 1, 2 and 3 correctly describe the normal fault-tolerance properties of these RAID levels.
• RAID can improve availability after certain drive failures.
• Statement 4 is false because RAID does not protect against all causes of data loss such as deletion, ransomware or loss of the whole array.
• RAID can improve availability after certain drive failures.
• Statement 4 is false because RAID does not protect against all causes of data loss such as deletion, ransomware or loss of the whole array.
వివరణ:
Question 35
ప్రశ్న 35
Which printer type uses toner, an electro-photographic process and a fuser assembly?
Explanation:
• Laser printers use toner rather than liquid ink.
• The electro-photographic process transfers toner to paper and the fuser bonds it using heat and pressure.
• Inkjet and impact printers use different printing mechanisms.
• The electro-photographic process transfers toner to paper and the fuser bonds it using heat and pressure.
• Inkjet and impact printers use different printing mechanisms.
వివరణ:
Question 36
ప్రశ్న 36
Which feature is most appropriate for summarizing a large table by categories and rearranging fields interactively?
Explanation:
• PivotTables summarize and aggregate structured worksheet data.
• Fields can be moved among row, column, filter and value areas.
• This enables flexible multidimensional analysis without rewriting the source data.
• Fields can be moved among row, column, filter and value areas.
• This enables flexible multidimensional analysis without rewriting the source data.
వివరణ:
Question 37
ప్రశ్న 37
In a relational table, what does a row normally represent?
Explanation:
• Rows represent individual tuples or records in a relation.
• Columns represent attributes or fields.
• This row-column structure is fundamental to the relational model.
• Columns represent attributes or fields.
• This row-column structure is fundamental to the relational model.
వివరణ:
Question 38
ప్రశ్న 38
Which Word feature applies a reusable set of formatting characteristics to headings and other document elements?
Explanation:
• Styles provide reusable formatting definitions for document elements.
• Changing a style can update text using that style consistently.
• Styles also support structured features such as navigation and automatic tables of contents.
• Changing a style can update text using that style consistently.
• Styles also support structured features such as navigation and automatic tables of contents.
వివరణ:
Question 39
ప్రశ్న 39
Which ordering correctly represents a typical memory hierarchy from fastest/smallest to slower/larger?
Explanation:
• Registers are directly used by the CPU and are typically the fastest storage locations.
• Cache sits between registers/CPU execution and main memory to reduce average access time.
• RAM is faster than secondary storage but slower than registers and cache.
• Cache sits between registers/CPU execution and main memory to reduce average access time.
• RAM is faster than secondary storage but slower than registers and cache.
వివరణ:
Question 40
ప్రశ్న 40
Which statement correctly compares symmetric and asymmetric cryptography?
Explanation:
• Symmetric systems use secret-key material for corresponding encryption/decryption operations.
• Asymmetric systems use mathematically related public and private keys.
• The two approaches are often combined in secure protocols.
• Asymmetric systems use mathematically related public and private keys.
• The two approaches are often combined in secure protocols.
వివరణ:
Question 41
ప్రశ్న 41
A newly installed PCIe card is not detected, although the system otherwise boots normally. Which troubleshooting step is most appropriate first?
Explanation:
• A newly installed expansion-card detection problem should first be checked at the hardware interface.
• Seating, slot compatibility and auxiliary power are common causes.
• Application reinstallations are unrelated to whether the card is electrically detected.
• Seating, slot compatibility and auxiliary power are common causes.
• Application reinstallations are unrelated to whether the card is electrically detected.
వివరణ:
Question 42
ప్రశ్న 42
What does =ROUNDUP(12.341,2) return?
Explanation:
• ROUNDUP rounds away from zero to the specified number of digits.
• At two decimal places, the remaining nonzero digits require the hundredths place to increase.
• The result is 12.35.
• At two decimal places, the remaining nonzero digits require the hundredths place to increase.
• The result is 12.35.
వివరణ:
Question 43
ప్రశ్న 43
Which functional unit performs arithmetic and logical operations on data?
Explanation:
• The ALU performs arithmetic operations and logical comparisons.
• The Control Unit directs instruction execution but is not the primary arithmetic unit.
• ALU and Control Unit are major components of the CPU.
• The Control Unit directs instruction execution but is not the primary arithmetic unit.
• ALU and Control Unit are major components of the CPU.
వివరణ:
Question 44
ప్రశ్న 44
Which option allows the first page of a section to use a different header or footer from later pages?
Explanation:
• Different First Page separates the first-page header/footer from later pages in that section.
• It is useful for title pages and chapter openings.
• Different Odd & Even Pages addresses alternating pages instead.
• It is useful for title pages and chapter openings.
• Different Odd & Even Pages addresses alternating pages instead.
వివరణ:
Question 45
ప్రశ్న 45
Which feature can assign a shape to jump to a specified slide when clicked during a slide show?
Explanation:
• Actions and hyperlinks can create interactive navigation from objects.
• A shape can be configured to jump to a specific slide.
• Master and timing features do not provide this direct click navigation.
• A shape can be configured to jump to a specific slide.
• Master and timing features do not provide this direct click navigation.
వివరణ:
Question 46
ప్రశ్న 46
A user must replace every occurrence of 'Dept.' with 'Department' throughout a document. Which feature is most appropriate?
Explanation:
• Find and Replace searches for specified text and substitutes replacement text.
• It can process repeated occurrences efficiently.
• Advanced use can also search for or replace formatting.
• It can process repeated occurrences efficiently.
• Advanced use can also search for or replace formatting.
వివరణ:
Question 47
ప్రశ్న 47
Which break should be used when the next page must have a different page orientation and separate section formatting?
Explanation:
• A Next Page section break begins a new section on the next page.
• Section-level settings such as orientation, headers and numbering can then differ.
• A simple page break does not create a new independently formatted section.
• Section-level settings such as orientation, headers and numbering can then differ.
• A simple page break does not create a new independently formatted section.
వివరణ:
Question 48
ప్రశ్న 48
Using binary units, how many MiB are in 6 GiB?
Explanation:
• One GiB equals 1024 MiB.
• 6×1024 = 6144 MiB.
• The question explicitly uses binary units rather than decimal gigabytes.
• 6×1024 = 6144 MiB.
• The question explicitly uses binary units rather than decimal gigabytes.
వివరణ:
Question 49
ప్రశ్న 49
Which device primarily forwards IP packets between different networks?
Explanation:
• Routers operate at the network layer and forward IP packets between networks.
• They choose next hops using routing information.
• Input/output peripherals do not perform IP routing.
• They choose next hops using routing information.
• Input/output peripherals do not perform IP routing.
వివరణ:
Question 50
ప్రశ్న 50
Which sequence best represents the high-level startup order of a modern PC?
Explanation:
• Firmware and POST operate immediately after power-on.
• A boot manager or loader is then invoked to start the operating system.
• User sign-in occurs only after operating-system initialization.
• A boot manager or loader is then invoked to start the operating system.
• User sign-in occurs only after operating-system initialization.
వివరణ:
Question 51
ప్రశ్న 51
What does the ACID property Atomicity require?
Explanation:
• Atomicity means either the transaction completes as a unit or its partial effects are undone.
• It prevents half-completed logical operations such as a debit without the matching credit.
• Durability and isolation address different transaction properties.
• It prevents half-completed logical operations such as a debit without the matching credit.
• Durability and isolation address different transaction properties.
వివరణ:
Question 52
ప్రశ్న 52
A cache has a hit time of 2 ns, hit ratio 0.9 and miss penalty of 40 ns beyond the cache lookup. What is the average memory access time?
Explanation:
• Average access time = hit time + miss rate × miss penalty.
• Miss rate = 1−0.9 = 0.1, so 2 + 0.1×40 = 6 ns.
• The stated miss penalty is additional to the cache lookup, so it is not multiplied by the hit ratio.
• Miss rate = 1−0.9 = 0.1, so 2 + 0.1×40 = 6 ns.
• The stated miss penalty is additional to the cache lookup, so it is not multiplied by the hit ratio.
వివరణ:
Question 53
ప్రశ్న 53
A byte-addressable system has 24 address lines and can use every address. What is the directly addressable memory space?
Explanation:
• Twenty-four address bits provide 2^24 distinct 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 54
ప్రశ్న 54
Match List I with List II:
(a) Switch
(b) Router
(c) DHCP
(d) DNS
1. Name resolution
2. IP configuration service
3. Frame forwarding within LAN
4. Packet forwarding between networks
Choose the correct code.
(a) Switch
(b) Router
(c) DHCP
(d) DNS
1. Name resolution
2. IP configuration service
3. Frame forwarding within LAN
4. Packet forwarding between networks
Choose the correct code.
Explanation:
• A switch forwards LAN frames and a router forwards packets between networks.
• DHCP supplies configuration and DNS performs name resolution.
• The correct mapping is therefore 3-4-2-1.
• DHCP supplies configuration and DNS performs name resolution.
• The correct mapping is therefore 3-4-2-1.
వివరణ:
Question 55
ప్రశ్న 55
Which technology is most closely associated with first-generation electronic computers?
Explanation:
• First-generation electronic computers used vacuum tubes for switching and amplification.
• Transistors and integrated circuits characterized later generations.
• Microprocessors became central to fourth-generation systems.
• Transistors and integrated circuits characterized later generations.
• Microprocessors became central to fourth-generation systems.
వివరణ:
Question 56
ప్రశ్న 56
Which device is primarily used to convert a paper document into a digital image?
Explanation:
• A scanner captures printed pages or photographs as digital image data.
• It is therefore an input device.
• Plotters, projectors and speakers are primarily output devices.
• It is therefore an input device.
• Plotters, projectors and speakers are primarily output devices.
వివరణ:
Question 57
ప్రశ్న 57
Which computer generation is most closely associated with the widespread use of integrated circuits instead of individual transistors?
Explanation:
• Third-generation computers are commonly associated with integrated circuits.
• First-generation systems used vacuum tubes and second-generation systems used transistors.
• Fourth-generation systems are associated with microprocessors using highly integrated circuitry.
• First-generation systems used vacuum tubes and second-generation systems used transistors.
• Fourth-generation systems are associated with microprocessors using highly integrated circuitry.
వివరణ:
Question 58
ప్రశ్న 58
In Goal Seek, which item is the formula cell whose result you want to force to a specific value?
Explanation:
• Goal Seek changes one input cell to make one formula cell reach a target.
• The formula cell is specified as the Set cell.
• The adjustable input is specified separately as the By changing cell.
• The formula cell is specified as the Set cell.
• The adjustable input is specified separately as the By changing cell.
వివరణ:
Question 59
ప్రశ్న 59
A paragraph heading must stay on the same page as the following paragraph whenever possible. Which paragraph option is designed for this?
Explanation:
• Keep with next prevents an unwanted page break between selected consecutive paragraphs when possible.
• It is useful for keeping a heading with the paragraph that follows.
• Widow/Orphan control addresses isolated lines at page boundaries instead.
• It is useful for keeping a heading with the paragraph that follows.
• Widow/Orphan control addresses isolated lines at page boundaries instead.
వివరణ:
Question 60
ప్రశ్న 60
Which scheduling goal is most important for an interactive multi-user system?
Explanation:
• Interactive users expect the system to respond quickly to commands and events.
• Schedulers therefore balance responsiveness with throughput and fairness.
• Printer consumables and file naming are unrelated scheduling objectives.
• Schedulers therefore balance responsiveness with throughput and fairness.
• Printer consumables and file naming are unrelated scheduling objectives.
వివరణ:
Question 61
ప్రశ్న 61
Which feature controls common presentation-wide fonts, placeholders and repeated design elements?
Explanation:
• Slide Master provides centralized control over common slide design and layout elements.
• Changes to a master or layout can propagate to slides using it.
• Animation Pane and Presenter View serve different presentation functions.
• Changes to a master or layout can propagate to slides using it.
• Animation Pane and Presenter View serve different presentation functions.
వివరణ:
Question 62
ప్రశ్న 62
Which service resolves domain names such as example.com to IP-address information?
Explanation:
• DNS provides distributed name-resolution services.
• Applications use it to obtain records such as IP addresses for domain names.
• DHCP configures hosts, while SMTP and FTP serve email and file-transfer roles.
• Applications use it to obtain records such as IP addresses for domain names.
• DHCP configures hosts, while SMTP and FTP serve email and file-transfer roles.
వివరణ:
Question 63
ప్రశ్న 63
What is the primary purpose of OMR technology?
Explanation:
• OMR detects the presence and position of marks on structured forms.
• It is commonly used for answer sheets and surveys.
• OCR recognizes characters, while MICR reads specially printed magnetic-ink characters.
• It is commonly used for answer sheets and surveys.
• OCR recognizes characters, while MICR reads specially printed magnetic-ink characters.
వివరణ:
Question 64
ప్రశ్న 64
Which query type prompts the user for a value each time it runs and uses that value as a criterion?
Explanation:
• A parameter query requests input at run time.
• The entered value can be used in criteria or calculations.
• This allows one saved query to be reused with different input values.
• The entered value can be used in criteria or calculations.
• This allows one saved query to be reused with different input values.
వివరణ:
Question 65
ప్రశ్న 65
A workstation can reach a website by numerical IP address but not by its domain name. Which service should be investigated first?
Explanation:
• Successful access by IP indicates that basic network connectivity to the server exists.
• Failure only when using a name points strongly to DNS or another name-resolution issue.
• Storage and printing components do not resolve Internet hostnames.
• Failure only when using a name points strongly to DNS or another name-resolution issue.
• Storage and printing components do not resolve Internet hostnames.
వివరణ:
Question 66
ప్రశ్న 66
Which field property guides data entry into a pattern such as a telephone-number format?
Explanation:
• Input Mask specifies a pattern for character positions during data entry.
• It can guide consistent entry of formatted values.
• Validation rules test acceptability rather than merely the display/input pattern.
• It can guide consistent entry of formatted values.
• Validation rules test acceptability rather than merely the display/input pattern.
వివరణ:
Question 67
ప్రశ్న 67
Consider the following statements:
1. Buffering can temporarily hold data while producer and consumer speeds differ.
2. Spooling can queue jobs for a peripheral.
3. A context switch changes the CPU from one executing task to another.
4. A device driver is a physical connector.
Which statements are correct?
1. Buffering can temporarily hold data while producer and consumer speeds differ.
2. Spooling can queue jobs for a peripheral.
3. A context switch changes the CPU from one executing task to another.
4. A device driver is a physical connector.
Which statements are correct?
Explanation:
• Buffering, spooling and context switching are correctly described in statements 1 through 3.
• A driver is software that enables operating-system control of hardware.
• Therefore statement 4 is false.
• A driver is software that enables operating-system control of hardware.
• Therefore statement 4 is false.
వివరణ:
Question 68
ప్రశ్న 68
What does MICR primarily read?
Explanation:
• MICR stands for Magnetic Ink Character Recognition.
• It reads specially encoded characters printed with magnetic ink or toner.
• The technology is traditionally associated with banking documents such as cheques.
• It reads specially encoded characters printed with magnetic ink or toner.
• The technology is traditionally associated with banking documents such as cheques.
వివరణ:
Question 69
ప్రశ్న 69
A running process requests disk I/O and cannot continue until the request completes. Which state transition normally occurs?
Explanation:
• A process waiting for an I/O event cannot continue executing.
• The operating system normally moves it from Running to Waiting/Blocked.
• When the event completes, it can return to the Ready state.
• The operating system normally moves it from Running to Waiting/Blocked.
• When the event completes, it can return to the Ready state.
వివరణ:
Question 70
ప్రశ్న 70
Which command is used to check protected Windows system files and repair corrupted copies when possible?
Explanation:
• System File Checker scans protected Windows system files.
• The /scannow option performs an immediate verification and repair attempt.
• It is commonly used after DISM repair when the Windows component store is also suspected.
• The /scannow option performs an immediate verification and repair attempt.
• It is commonly used after DISM repair when the Windows component store is also suspected.
వివరణ:
Question 71
ప్రశ్న 71
Which statement about virtual memory is correct?
Explanation:
• Virtual memory separates a process's logical address space from the amount of physical RAM currently resident.
• Pages can be moved between RAM and backing storage as needed.
• Virtual memory is an operating-system memory-management technique, not extra physical RAM.
• Pages can be moved between RAM and backing storage as needed.
• Virtual memory is an operating-system memory-management technique, not extra physical RAM.
వివరణ:
Question 72
ప్రశ్న 72
Which command clears the Windows DNS client resolver cache?
Explanation:
• ipconfig /flushdns clears cached DNS resolver entries on Windows.
• It is useful when a workstation continues using stale local DNS information.
• CHKDSK and SFC are storage and system-file utilities.
• It is useful when a workstation continues using stale local DNS information.
• CHKDSK and SFC are storage and system-file utilities.
వివరణ:
Question 73
ప్రశ్న 73
Which protocol/service normally provides IPv4 configuration such as an address, subnet mask and default gateway automatically to clients?
Explanation:
• DHCP provides automatic host network configuration.
• It can supply IP address, subnet mask, gateway and DNS options.
• DNS resolves names rather than assigning IP configurations.
• It can supply IP address, subnet mask, gateway and DNS options.
• DNS resolves names rather than assigning IP configurations.
వివరణ:
Question 74
ప్రశ్న 74
A USB keyboard works in one computer but not in any USB port on another computer. Which troubleshooting conclusion is most reasonable?
Explanation:
• Working correctly on another computer is evidence that the keyboard hardware is functional.
• Failure on all ports of the second PC points toward that PC's USB hardware, drivers or configuration.
• Cross-testing helps isolate the failing side of a peripheral connection.
• Failure on all ports of the second PC points toward that PC's USB hardware, drivers or configuration.
• Cross-testing helps isolate the failing side of a peripheral connection.
వివరణ:
Question 75
ప్రశ్న 75
Which command is used on Windows to trace successive IP routing hops toward a destination?
Explanation:
• tracert sends probes with controlled TTL values to reveal successive hops.
• It helps identify where routing paths or delays occur.
• ATTRIB, FORMAT and TREE are file/storage commands.
• It helps identify where routing paths or delays occur.
• ATTRIB, FORMAT and TREE are file/storage commands.
వివరణ:
Question 76
ప్రశ్న 76
Which normal form specifically removes partial dependency of a non-key attribute on part of a composite candidate key?
Explanation:
• 2NF requires 1NF and removal of partial dependency on part of a composite candidate key.
• 1NF focuses on atomic values and absence of repeating groups.
• 3NF additionally addresses transitive dependencies involving non-key attributes.
• 1NF focuses on atomic values and absence of repeating groups.
• 3NF additionally addresses transitive dependencies involving non-key attributes.
వివరణ:
Question 77
ప్రశ్న 77
Which component is normally closest to the CPU execution units in the memory hierarchy?
Explanation:
• Registers are located within the processor and are directly used during instruction execution.
• Cache is also very close to the CPU but sits below registers in the usual hierarchy.
• RAM and secondary storage have substantially higher access latency.
• Cache is also very close to the CPU but sits below registers in the usual hierarchy.
• RAM and secondary storage have substantially higher access latency.
వివరణ:
Question 78
ప్రశ్న 78
Which statement most accurately describes the Internet?
Explanation:
• The Internet interconnects independently operated networks on a global scale.
• TCP/IP protocols provide the common communication foundation.
• It is broader than any single organizational network.
• TCP/IP protocols provide the common communication foundation.
• It is broader than any single organizational network.
వివరణ:
Question 79
ప్రశ్న 79
Which view can show speaker notes and upcoming slides to the presenter while the audience sees only the current slide?
Explanation:
• Presenter View provides presenter-oriented information on a separate display.
• The audience normally sees only the slide-show output.
• It can show notes, timing and navigation controls.
• The audience normally sees only the slide-show output.
• It can show notes, timing and navigation controls.
వివరణ:
Question 80
ప్రశ్న 80
Which Access data type is normally used for an automatically generated unique numeric identifier such as a primary key?
Explanation:
• AutoNumber can generate a unique numeric value for each new record.
• It is commonly used for surrogate primary keys.
• Long Text, Attachment and Yes/No serve different data-storage purposes.
• It is commonly used for surrogate primary keys.
• Long Text, Attachment and Yes/No serve different data-storage purposes.
వివరణ:
Question 81
ప్రశ్న 81
Which statement most accurately compares an SSD with a traditional HDD?
Explanation:
• HDDs use rotating magnetic platters and mechanical heads.
• SSDs use non-volatile semiconductor storage and therefore avoid mechanical seek and rotational delay.
• This normally gives SSDs much lower random-access latency.
• SSDs use non-volatile semiconductor storage and therefore avoid mechanical seek and rotational delay.
• This normally gives SSDs much lower random-access latency.
వివరణ:
Question 82
ప్రశ్న 82
Which memory type is normally programmable only once after manufacture by the user?
Explanation:
• PROM can be programmed once after manufacture and is not normally erasable for reuse.
• EPROM can be ultraviolet-erased and EEPROM can be electrically erased.
• DRAM is volatile working memory rather than firmware ROM.
• EPROM can be ultraviolet-erased and EEPROM can be electrically erased.
• DRAM is volatile working memory rather than firmware ROM.
వివరణ:
Question 83
ప్రశ్న 83
What does enforcing referential integrity between related Access tables help prevent?
Explanation:
• Referential integrity keeps foreign-key relationships valid.
• It prevents orphaned child references to nonexistent parent keys, subject to relationship settings.
• It does not prohibit all duplicates or all possible data-entry mistakes.
• It prevents orphaned child references to nonexistent parent keys, subject to relationship settings.
• It does not prohibit all duplicates or all possible data-entry mistakes.
వివరణ:
Question 84
ప్రశ్న 84
Which query type changes field values in existing records that satisfy specified criteria?
Explanation:
• Update queries modify data in existing rows.
• Criteria determine which records are affected.
• A Select query retrieves data without performing the update.
• Criteria determine which records are affected.
• A Select query retrieves data without performing the update.
వివరణ:
Question 85
ప్రశ్న 85
What is the result of =IF(AND(70>=60,55>=60),"PASS","FAIL")?
Explanation:
• The first comparison is TRUE but the second is FALSE.
• AND returns TRUE only when all its arguments are TRUE.
• Therefore IF selects the FALSE branch and returns FAIL.
• AND returns TRUE only when all its arguments are TRUE.
• Therefore IF selects the FALSE branch and returns FAIL.
వివరణ:
Question 86
ప్రశ్న 86
Match List I with List II:
(a) Table
(b) Query
(c) Form
(d) Report
1. Data storage
2. Data retrieval/manipulation
3. Interactive record interface
4. Formatted output
Choose the correct code.
(a) Table
(b) Query
(c) Form
(d) Report
1. Data storage
2. Data retrieval/manipulation
3. Interactive record interface
4. Formatted output
Choose the correct code.
Explanation:
• Tables store data and queries retrieve or manipulate it.
• Forms provide interactive interfaces for records.
• Reports provide formatted output, giving 1-2-3-4.
• Forms provide interactive interfaces for records.
• Reports provide formatted output, giving 1-2-3-4.
వివరణ:
Question 87
ప్రశ్న 87
Which register normally holds the instruction currently being decoded or executed?
Explanation:
• The Instruction Register holds the current instruction for decoding/execution.
• The Program Counter normally identifies the next instruction address.
• Different CPU registers therefore serve distinct control and data-handling roles.
• The Program Counter normally identifies the next instruction address.
• Different CPU registers therefore serve distinct control and data-handling roles.
వివరణ:
Question 88
ప్రశ్న 88
Which statement best describes System Restore?
Explanation:
• System Restore is designed to reverse certain system-level changes.
• It is useful after problematic drivers, updates or configuration changes.
• It is not a substitute for independent personal-data backups.
• It is useful after problematic drivers, updates or configuration changes.
• It is not a substitute for independent personal-data backups.
వివరణ:
Question 89
ప్రశ్న 89
Which view is best for quickly reordering many slides by dragging thumbnails?
Explanation:
• Slide Sorter displays slide thumbnails in a grid.
• It is designed for rapid reordering, copying or deleting of slides.
• Notes Page focuses on speaker notes instead.
• It is designed for rapid reordering, copying or deleting of slides.
• Notes Page focuses on speaker notes instead.
వివరణ:
Question 90
ప్రశ్న 90
A legitimate file is incorrectly detected as malware by antivirus software. What is this called?
Explanation:
• A false positive is a benign item incorrectly classified as malicious.
• A false negative is malicious content that is missed.
• These terms describe detection outcomes, not malware types.
• A false negative is malicious content that is missed.
• These terms describe detection outcomes, not malware types.
వివరణ:
Question 91
ప్రశ్న 91
What is spooling?
Explanation:
• Spooling decouples a producer from a slower peripheral such as a printer.
• Jobs are queued and processed by the device at its own rate.
• Printer queues are a common example of spooling.
• Jobs are queued and processed by the device at its own rate.
• Printer queues are a common example of spooling.
వివరణ:
Question 92
ప్రశ్న 92
A filtered table should be summed while excluding rows hidden by the filter. Which formula is appropriate for range D2:D100?
Explanation:
• SUBTOTAL can ignore rows removed by AutoFilter.
• Function number 9 specifies SUM.
• Therefore SUBTOTAL(9,D2:D100) sums the filtered visible records.
• Function number 9 specifies SUM.
• Therefore SUBTOTAL(9,D2:D100) sums the filtered visible records.
వివరణ:
Question 93
ప్రశ్న 93
Which query type adds selected records to the end of an existing table?
Explanation:
• Append queries insert records into an existing destination table.
• Existing destination records remain in place.
• Update changes existing values and Delete removes records.
• Existing destination records remain in place.
• Update changes existing values and Delete removes records.
వివరణ:
Question 94
ప్రశ్న 94
What is the primary function of a sound card or integrated audio adapter?
Explanation:
• Audio adapters provide interfaces for sound input and output.
• They convert between digital audio data and signals used by speakers, microphones or related devices.
• They are not storage, routing or power-supply components.
• They convert between digital audio data and signals used by speakers, microphones or related devices.
• They are not storage, routing or power-supply components.
వివరణ:
Question 95
ప్రశ్న 95
What is the primary purpose of POST during computer startup?
Explanation:
• POST performs early hardware checks and initialization during startup.
• It occurs before the operating system is loaded.
• POST failures can indicate problems such as memory, processor or other essential hardware faults.
• It occurs before the operating system is loaded.
• POST failures can indicate problems such as memory, processor or other essential hardware faults.
వివరణ:
Question 96
ప్రశ్న 96
Which authentication-factor pairing represents true multi-factor authentication?
Explanation:
• A password is a knowledge factor and a hardware token is a possession factor.
• Using independently verified factors from different categories provides MFA.
• Password, PIN and security-question answers are all knowledge factors.
• Using independently verified factors from different categories provides MFA.
• Password, PIN and security-question answers are all knowledge factors.
వివరణ:
Question 97
ప్రశ్న 97
Match List I with List II:
(a) ALU
(b) Control Unit
(c) Program Counter
(d) POST
1. Holds address of next instruction
2. Performs arithmetic/logical operations
3. Coordinates instruction execution
4. Early startup hardware checking
Choose the correct code.
(a) ALU
(b) Control Unit
(c) Program Counter
(d) POST
1. Holds address of next instruction
2. Performs arithmetic/logical operations
3. Coordinates instruction execution
4. Early startup hardware checking
Choose the correct code.
Explanation:
• ALU maps to arithmetic/logical operations and the Control Unit coordinates execution.
• The Program Counter tracks the next instruction address.
• POST performs early startup hardware checks, so the mapping is 2-3-1-4.
• The Program Counter tracks the next instruction address.
• POST performs early startup hardware checks, so the mapping is 2-3-1-4.
వివరణ:
Question 98
ప్రశ్న 98
Which device is best suited to producing large engineering drawings or maps on paper?
Explanation:
• Plotters are designed for precise large-format graphical output.
• They are commonly associated with engineering drawings, CAD output and maps.
• OMR readers, microphones and webcams are input devices.
• They are commonly associated with engineering drawings, CAD output and maps.
• OMR readers, microphones and webcams are input devices.
వివరణ:
Question 99
ప్రశ్న 99
Which account type should normally be used for ordinary daily work when administrative rights are not required?
Explanation:
• A standard account limits unnecessary system-wide privileges.
• Administrative elevation can be used only when required.
• This follows the principle of least privilege.
• Administrative elevation can be used only when required.
• This follows the principle of least privilege.
వివరణ:
Question 100
ప్రశ్న 100
What distinguishes a stateful firewall from a basic stateless packet filter?
Explanation:
• Stateful inspection tracks active communication state.
• Packets can be evaluated in the context of an established connection.
• A stateless filter evaluates packets without equivalent per-connection context.
• Packets can be evaluated in the context of an established connection.
• A stateless filter evaluates packets without equivalent per-connection context.
వివరణ:
Question 101
ప్రశ్న 101
Which relational design is most appropriate for a many-to-many relationship between Students and Courses?
Explanation:
• Many-to-many relationships are resolved using an associative or junction table.
• Each junction row represents one Student-Course association.
• Foreign keys preserve links to the parent tables without repeating variable-length lists.
• Each junction row represents one Student-Course association.
• Foreign keys preserve links to the parent tables without repeating variable-length lists.
వివరణ:
Question 102
ప్రశ్న 102
Which feature controls entrance, emphasis, exit and motion-path effects applied to slide objects?
Explanation:
• Animations apply effects to objects such as text, shapes and pictures.
• Entrance, emphasis, exit and motion paths are animation categories.
• Transitions instead operate between slides.
• Entrance, emphasis, exit and motion paths are animation categories.
• Transitions instead operate between slides.
వివరణ:
Question 103
ప్రశ్న 103
Which command should be used to display detailed Windows TCP/IP configuration including DHCP and DNS information?
Explanation:
• ipconfig /all displays detailed configuration for network adapters.
• The output can include IP addresses, DHCP status, gateways and DNS servers.
• The other commands perform unrelated file or storage operations.
• The output can include IP addresses, DHCP status, gateways and DNS servers.
• The other commands perform unrelated file or storage operations.
వివరణ:
Question 104
ప్రశ్న 104
Which Windows recovery tool attempts to fix problems that prevent Windows from starting correctly?
Explanation:
• Startup Repair is available through Windows recovery options.
• It targets startup-related configuration and boot problems.
• Disk Cleanup removes unneeded files but is not a boot-repair tool.
• It targets startup-related configuration and boot problems.
• Disk Cleanup removes unneeded files but is not a boot-repair tool.
వివరణ:
Question 105
ప్రశ్న 105
Which feature allows a presenter to show only selected slides in a chosen order without deleting other slides?
Explanation:
• Custom Slide Show defines a subset and order of slides for a particular audience.
• The original presentation retains all slides.
• It is useful when one deck supports multiple briefings.
• The original presentation retains all slides.
• It is useful when one deck supports multiple briefings.
వివరణ:
Question 106
ప్రశ్న 106
Which feature copies formatting from selected text to another location without copying the text itself?
Explanation:
• Format Painter copies formatting properties from one selection to another.
• It can quickly reproduce fonts, paragraph formatting and related styling.
• It does not copy the actual text content.
• It can quickly reproduce fonts, paragraph formatting and related styling.
• It does not copy the actual text content.
వివరణ:
Question 107
ప్రశ్న 107
Which key is selected from candidate keys to uniquely identify each row in a table?
Explanation:
• A candidate key is a minimal unique identifier for rows.
• One candidate key is chosen as the primary key.
• Primary-key values must be unique and non-null.
• One candidate key is chosen as the primary key.
• Primary-key values must be unique and non-null.
వివరణ:
Question 108
ప్రశ్న 108
Which device primarily forwards Ethernet frames within a LAN using learned MAC-address information?
Explanation:
• An Ethernet switch learns source MAC addresses and builds a forwarding table.
• It uses destination MAC information to forward frames within the LAN.
• Routers primarily forward IP packets between networks.
• It uses destination MAC information to forward frames within the LAN.
• Routers primarily forward IP packets between networks.
వివరణ:
Question 109
ప్రశ్న 109
What is the main purpose of a foreign key?
Explanation:
• A foreign key stores values that reference a candidate/primary key in a related relation.
• It represents relationships among rows in tables.
• Referential-integrity rules can prevent invalid references.
• It represents relationships among rows in tables.
• Referential-integrity rules can prevent invalid references.
వివరణ:
Question 110
ప్రశ్న 110
Which field property is used to reject values that do not satisfy a condition such as >=0 And <=100?
Explanation:
• Validation Rule defines a logical condition that entered data must satisfy.
• A numeric range can therefore be enforced at the field or control level.
• Input Mask controls entry pattern rather than the complete value rule.
• A numeric range can therefore be enforced at the field or control level.
• Input Mask controls entry pattern rather than the complete value rule.
వివరణ:
Question 111
ప్రశ్న 111
What is an ordinary non-materialized database view?
Explanation:
• A view stores a query definition and presents its result like a table.
• The underlying data normally remains in base tables.
• Views can simplify access and expose selected rows or columns.
• The underlying data normally remains in base tables.
• Views can simplify access and expose selected rows or columns.
వివరణ:
Question 112
ప్రశ్న 112
Which VPN type is most appropriate for securely connecting two branch-office networks through VPN gateways over the Internet?
Explanation:
• A site-to-site VPN connects entire networks through VPN gateways.
• Traffic between the sites travels through a protected virtual path.
• Remote-access VPNs instead primarily connect individual remote endpoints.
• Traffic between the sites travels through a protected virtual path.
• Remote-access VPNs instead primarily connect individual remote endpoints.
వివరణ:
Question 113
ప్రశ్న 113
Which RAID level provides striping without redundancy?
Explanation:
• RAID 0 stripes data across drives for capacity and performance.
• It stores no mirror or parity redundancy.
• Failure of a member drive can therefore cause loss of the array's data.
• It stores no mirror or parity redundancy.
• Failure of a member drive can therefore cause loss of the array's data.
వివరణ:
Question 114
ప్రశ్న 114
An AutoNumber primary key in a parent table is referenced by a child table. Which field type is commonly used for the child foreign key?
Explanation:
• Access AutoNumber primary keys commonly use a Long Integer underlying numeric size.
• The related foreign-key field is therefore typically Number with Field Size Long Integer.
• Making the child field AutoNumber would generate unrelated values rather than store the parent's key.
• The related foreign-key field is therefore typically Number with Field Size Long Integer.
• Making the child field AutoNumber would generate unrelated values rather than store the parent's key.
వివరణ:
Question 115
ప్రశ్న 115
Which Windows tool is used to view and manage installed hardware devices and their drivers?
Explanation:
• Device Manager displays hardware devices recognized by Windows.
• It allows driver updates, disabling devices and troubleshooting device status.
• Event Viewer, Disk Management and Task Scheduler serve different administrative purposes.
• It allows driver updates, disabling devices and troubleshooting device status.
• Event Viewer, Disk Management and Task Scheduler serve different administrative purposes.
వివరణ:
Question 116
ప్రశ్న 116
Which query type summarizes aggregate values using both row headings and column headings?
Explanation:
• Crosstab queries present summarized values in a matrix.
• One set of fields forms row headings and another forms column headings.
• An aggregate such as Sum or Count normally supplies the values.
• One set of fields forms row headings and another forms column headings.
• An aggregate such as Sum or Count normally supplies the values.
వివరణ:
Question 117
ప్రశ్న 117
Match List I with List II:
(a) Transition
(b) Animation
(c) Slide Master
(d) Presenter View
1. Object effect
2. Slide-to-slide effect
3. Central design control
4. Presenter-only tools/notes
Choose the correct code.
(a) Transition
(b) Animation
(c) Slide Master
(d) Presenter View
1. Object effect
2. Slide-to-slide effect
3. Central design control
4. Presenter-only tools/notes
Choose the correct code.
Explanation:
• Transitions act between slides and animations act on objects.
• Slide Master centralizes common design.
• Presenter View provides presenter-only controls and notes, giving 2-1-3-4.
• Slide Master centralizes common design.
• Presenter View provides presenter-only controls and notes, giving 2-1-3-4.
వివరణ:
Question 118
ప్రశ్న 118
Which ACID property requires committed transaction effects to persist after a subsequent system failure?
Explanation:
• Durability means successful committed changes survive later failures.
• Recovery logs and stable storage mechanisms help enforce it.
• Atomicity concerns all-or-nothing completion rather than post-commit persistence.
• Recovery logs and stable storage mechanisms help enforce it.
• Atomicity concerns all-or-nothing completion rather than post-commit persistence.
వివరణ:
Question 119
ప్రశ్న 119
Which practice best reduces the risk of malware infection from unknown removable media?
Explanation:
• Scanning untrusted media can identify known or suspicious malicious content before execution.
• Restricting automatic execution reduces a common propagation path.
• Patch management and backups are complementary protections and should not be disabled.
• Restricting automatic execution reduces a common propagation path.
• Patch management and backups are complementary protections and should not be disabled.
వివరణ:
Question 120
ప్రశ్న 120
Which Windows tool is used to examine Application, System and Security event logs?
Explanation:
• Event Viewer provides access to Windows event logs.
• Errors, warnings and informational records can help diagnose system and application problems.
• Device Manager focuses on hardware rather than recorded event history.
• Errors, warnings and informational records can help diagnose system and application problems.
• Device Manager focuses on hardware rather than recorded event history.
వివరణ:
Question 121
ప్రశ్న 121
Which input device commonly uses an optical sensor to detect relative movement across a surface?
Explanation:
• An optical mouse uses an optical sensor to measure movement across a surface.
• The movement is translated into pointer motion.
• Printers, speakers and UPS units perform unrelated output or power functions.
• The movement is translated into pointer motion.
• Printers, speakers and UPS units perform unrelated output or power functions.
వివరణ:
Question 122
ప్రశ్న 122
Which anomaly occurs when one transaction reads data written by another transaction that has not yet committed?
Explanation:
• A dirty read observes another transaction's uncommitted data.
• If the writer rolls back, the reader has seen a value that never became committed.
• Appropriate isolation levels prevent dirty reads.
• If the writer rolls back, the reader has seen a value that never became committed.
• Appropriate isolation levels prevent dirty reads.
వివరణ:
Question 123
ప్రశ్న 123
What does a cache hit mean?
Explanation:
• A cache hit occurs when the requested item is already present in the relevant cache.
• The CPU can then obtain it without waiting for a slower lower-level access for that request.
• A cache miss means the requested item is not found at that cache level.
• The CPU can then obtain it without waiting for a slower lower-level access for that request.
• A cache miss means the requested item is not found at that cache level.
వివరణ:
Question 124
ప్రశ్న 124
What is the primary purpose of Track Changes?
Explanation:
• Track Changes records revisions made to a Word document.
• Reviewers can later accept or reject changes.
• It is a collaboration/review feature, not a storage or spreadsheet function.
• Reviewers can later accept or reject changes.
• It is a collaboration/review feature, not a storage or spreadsheet function.
వివరణ:
Question 125
ప్రశ్న 125
What is Windows Safe Mode primarily used for?
Explanation:
• Safe Mode loads a reduced environment to help isolate startup, driver or software problems.
• If a fault disappears in Safe Mode, a normally loaded driver or service may be involved.
• Safe Mode is a troubleshooting environment, not a performance mode.
• If a fault disappears in Safe Mode, a normally loaded driver or service may be involved.
• Safe Mode is a troubleshooting environment, not a performance mode.
వివరణ:
Question 126
ప్రశ్న 126
Which command changes the current directory to its parent directory?
Explanation:
• Two dots represent the parent directory in this command-line context.
• CD .. moves the working directory up one level.
• CD instead moves directly to the root of the current drive.
• CD .. moves the working directory up one level.
• CD instead moves directly to the root of the current drive.
వివరణ:
Question 127
ప్రశ్న 127
Which component provides the main circuit board on which the CPU, memory slots and expansion interfaces are interconnected?
Explanation:
• The motherboard is the primary printed circuit board of a computer.
• It provides sockets, slots, buses and interfaces connecting major internal components.
• The SMPS supplies power, while an SSD provides storage.
• It provides sockets, slots, buses and interfaces connecting major internal components.
• The SMPS supplies power, while an SSD provides storage.
వివరణ:
Question 128
ప్రశ్న 128
Assertion (A): In a typical 64-bit processor architecture, general-purpose registers can hold wider integer values than the general-purpose registers of a typical 32-bit processor architecture.
Reason (R): Processor word size commonly relates to the width of general-purpose registers and major internal data paths.
Choose the correct answer.
Reason (R): Processor word size commonly relates to the width of general-purpose registers and major internal data paths.
Choose the correct answer.
Explanation:
• A typical 64-bit architecture provides general-purpose registers capable of holding 64-bit integer values, while a typical 32-bit architecture commonly uses 32-bit general-purpose integer registers.
• Processor word size is closely related to the natural width of general-purpose registers and important internal data paths.
• Both statements are true, and the Reason explains the architectural basis of the Assertion.
• Processor word size is closely related to the natural width of general-purpose registers and important internal data paths.
• Both statements are true, and the Reason explains the architectural basis of the Assertion.
వివరణ:
Question 129
ప్రశ్న 129
Which query type permanently removes records meeting specified criteria?
Explanation:
• Delete queries remove qualifying records from a table.
• Because the action is destructive, criteria and backups should be checked carefully.
• Select and parameter queries do not inherently delete records.
• Because the action is destructive, criteria and backups should be checked carefully.
• Select and parameter queries do not inherently delete records.
వివరణ:
Question 130
ప్రశ్న 130
Which statement about relative references is correct?
Explanation:
• A1 contains no dollar signs, so both components are relative.
• Copying a formula adjusts the reference according to the movement.
• $A$1 is absolute, while A$1 fixes only the row.
• Copying a formula adjusts the reference according to the movement.
• $A$1 is absolute, while A$1 fixes only the row.
వివరణ:
Question 131
ప్రశ్న 131
What does the file system primarily provide?
Explanation:
• A file system defines how files and directories are represented on storage.
• It manages names, metadata, allocation and access to stored data.
• It is a storage-management function of the operating system.
• It manages names, metadata, allocation and access to stored data.
• It is a storage-management function of the operating system.
వివరణ:
Question 132
ప్రశ్న 132
Which device allows one keyboard, monitor and mouse to control multiple computers?
Explanation:
• KVM stands for Keyboard, Video and Mouse.
• A KVM switch lets one console be switched among multiple computers.
• It is common in server or equipment rooms.
• A KVM switch lets one console be switched among multiple computers.
• It is common in server or equipment rooms.
వివరణ:
Question 133
ప్రశ్న 133
Which device stores data using magnetic platters?
Explanation:
• Traditional HDDs store data magnetically on rotating platters.
• SSDs and USB flash drives use semiconductor flash memory.
• Optical discs use laser-based optical storage.
• SSDs and USB flash drives use semiconductor flash memory.
• Optical discs use laser-based optical storage.
వివరణ:
Question 134
ప్రశ్న 134
B2:B6 contain 10, 20, 30, 40 and 50. What does =COUNTIF(B2:B6,">25") return?
Explanation:
• Values greater than 25 are 30, 40 and 50.
• COUNTIF counts cells that satisfy the specified criterion.
• Therefore the result is 3.
• COUNTIF counts cells that satisfy the specified criterion.
• Therefore the result is 3.
వివరణ:
Question 135
ప్రశ్న 135
Which statement about RAID 1 is correct?
Explanation:
• RAID 1 duplicates data across mirrored members.
• With two equal drives, usable capacity is approximately one drive's capacity.
• Its redundancy model differs from parity-based RAID 5 and RAID 6.
• With two equal drives, usable capacity is approximately one drive's capacity.
• Its redundancy model differs from parity-based RAID 5 and RAID 6.
వివరణ:
Question 136
ప్రశ్న 136
What is returned by =IFERROR(10/0,"Error")?
Explanation:
• 10/0 generates a division-by-zero error.
• IFERROR returns its second argument when the first expression results in an error.
• Therefore the displayed result is the text Error.
• IFERROR returns its second argument when the first expression results in an error.
• Therefore the displayed result is the text Error.
వివరణ:
Question 137
ప్రశ్న 137
In the basic Input–Process–Output–Storage cycle, which stage transforms input data according to program instructions?
Explanation:
• Processing applies instructions to input data to produce results.
• Input acquires data, output presents results, and storage retains data.
• The CPU is the principal hardware responsible for the processing stage.
• Input acquires data, output presents results, and storage retains data.
• The CPU is the principal hardware responsible for the processing stage.
వివరణ:
Question 138
ప్రశ్న 138
What is the main purpose of an interrupt?
Explanation:
• Interrupts notify the processor of events needing service.
• The CPU saves enough context and executes an interrupt-handling routine.
• This avoids constant polling for every event in many designs.
• The CPU saves enough context and executes an interrupt-handling routine.
• This avoids constant polling for every event in many designs.
వివరణ:
Question 139
ప్రశ్న 139
Which RAID level normally combines striping and mirroring and requires at least four drives?
Explanation:
• RAID 10 stripes data across mirrored sets.
• A conventional arrangement requires at least four drives.
• Its fault tolerance depends on which members fail within each mirror pair.
• A conventional arrangement requires at least four drives.
• Its fault tolerance depends on which members fail within each mirror pair.
వివరణ:
Question 140
ప్రశ్న 140
Which statement correctly distinguishes BIOS/UEFI firmware from an operating system?
Explanation:
• Firmware begins executing at power-on and prepares the system for boot.
• The operating system loads later and manages processes, memory, files and devices.
• UEFI is a modern firmware interface, not a replacement for the operating system itself.
• The operating system loads later and manages processes, memory, files and devices.
• UEFI is a modern firmware interface, not a replacement for the operating system itself.
వివరణ:
Question 141
ప్రశ్న 141
Consider the following statements:
1. COUNT counts numeric cells.
2. COUNTA counts non-empty cells.
3. MAX returns the largest numeric value.
4. MIN returns the average.
Which statements are correct?
1. COUNT counts numeric cells.
2. COUNTA counts non-empty cells.
3. MAX returns the largest numeric value.
4. MIN returns the average.
Which statements are correct?
Explanation:
• COUNT, COUNTA and MAX are correctly described in statements 1 through 3.
• MIN returns the smallest numeric value, not the average.
• AVERAGE is the function used for the arithmetic mean.
• MIN returns the smallest numeric value, not the average.
• AVERAGE is the function used for the arithmetic mean.
వివరణ:
Question 142
ప్రశ్న 142
A newly assembled PC shows no power at all. Which check should normally be performed before replacing the motherboard?
Explanation:
• A completely dead system first suggests a power-delivery or front-panel connection problem.
• Main ATX and CPU power connectors must be correctly attached before the system can start.
• Operating-system troubleshooting is irrelevant if the machine does not power on.
• Main ATX and CPU power connectors must be correctly attached before the system can start.
• Operating-system troubleshooting is irrelevant if the machine does not power on.
వివరణ:
Question 143
ప్రశ్న 143
Consider the following statements:
1. A primary key uniquely identifies rows.
2. A foreign key can reference a related table's key.
3. Normalization can reduce redundancy.
4. A primary key may contain NULL in some rows.
Which statements are correct?
1. A primary key uniquely identifies rows.
2. A foreign key can reference a related table's key.
3. Normalization can reduce redundancy.
4. A primary key may contain NULL in some rows.
Which statements are correct?
Explanation:
• Statements 1 and 2 correctly describe primary and foreign keys.
• Normalization aims to reduce undesirable redundancy and anomalies.
• Statement 4 is false because primary-key attributes cannot be null.
• Normalization aims to reduce undesirable redundancy and anomalies.
• Statement 4 is false because primary-key attributes cannot be null.
వివరణ:
Question 144
ప్రశ్న 144
What is the primary purpose of a default gateway on an IP host?
Explanation:
• The default gateway is the next-hop router for non-local destinations when no specific route applies.
• Hosts send local-subnet traffic directly, but remote traffic is typically sent to the gateway.
• Gateway configuration is therefore part of IP routing.
• Hosts send local-subnet traffic directly, but remote traffic is typically sent to the gateway.
• Gateway configuration is therefore part of IP routing.
వివరణ:
Question 145
ప్రశ్న 145
Which SQL transaction-control command makes the current successful transaction changes permanent?
Explanation:
• COMMIT completes the transaction and makes its changes durable.
• ROLLBACK cancels applicable uncommitted changes.
• SELECT and ORDER BY retrieve or arrange data rather than complete a transaction.
• ROLLBACK cancels applicable uncommitted changes.
• SELECT and ORDER BY retrieve or arrange data rather than complete a transaction.
వివరణ:
Question 146
ప్రశ్న 146
Which Access object physically stores records in rows and fields in columns?
Explanation:
• Tables are the primary storage objects for structured database records.
• Fields define attributes and rows contain individual records.
• Queries, forms and reports normally work with data stored in tables.
• Fields define attributes and rows contain individual records.
• Queries, forms and reports normally work with data stored in tables.
వివరణ:
Question 147
ప్రశ్న 147
Host A is 192.168.5.20/24 and Host B is 192.168.5.200/24. Assuming normal configuration, which statement is correct?
Explanation:
• A /24 prefix fixes the first three octets as the network portion.
• Both hosts belong to 192.168.5.0/24.
• Local subnet traffic can be delivered over the LAN without using the default gateway as an IP router.
• Both hosts belong to 192.168.5.0/24.
• Local subnet traffic can be delivered over the LAN without using the default gateway as an IP router.
వివరణ:
Question 148
ప్రశ్న 148
Which Word feature is used to create many personalized letters from one main document and a recipient list?
Explanation:
• Mail Merge combines a main document with variable recipient data.
• Fields such as name and address are inserted as merge fields.
• The result can produce many personalized documents efficiently.
• Fields such as name and address are inserted as merge fields.
• The result can produce many personalized documents efficiently.
వివరణ:
Question 149
ప్రశ్న 149
Which Access object is primarily used to retrieve, filter, calculate or manipulate data according to specified criteria?
Explanation:
• Queries retrieve or manipulate data from one or more tables or other queries.
• Criteria can restrict which records are returned or affected.
• Tables store data, while forms and reports focus on interaction and presentation.
• Criteria can restrict which records are returned or affected.
• Tables store data, while forms and reports focus on interaction and presentation.
వివరణ:
Question 150
ప్రశ్న 150
Which utility is designed to run programs or scripts automatically at specified times or in response to triggers?
Explanation:
• Task Scheduler creates and manages tasks based on schedules or triggers.
• It can launch programs or scripts without manual execution.
• Resource Monitor and System Information are primarily diagnostic tools.
• It can launch programs or scripts without manual execution.
• Resource Monitor and System Information are primarily diagnostic tools.
వివరణ:
Question 151
ప్రశ్న 151
Which sequence best represents a typical Mail Merge workflow?
Explanation:
• The main document is prepared first and connected to a recipient source.
• Merge fields are inserted and previewed before final output.
• Finish & Merge is the final stage rather than the starting step.
• Merge fields are inserted and previewed before final output.
• Finish & Merge is the final stage rather than the starting step.
వివరణ:
Question 152
ప్రశ్న 152
Which behavior is more characteristic of a worm than of a traditional file-infecting virus?
Explanation:
• A worm is generally a self-contained malicious program capable of propagating independently.
• Traditional viruses normally replicate by infecting other executable content.
• Both are malware, but their replication mechanisms differ.
• Traditional viruses normally replicate by infecting other executable content.
• Both are malware, but their replication mechanisms differ.
వివరణ:
Question 153
ప్రశ్న 153
Match List I with List II:
(a) Event Viewer
(b) Device Manager
(c) Task Scheduler
(d) Disk Management
1. Hardware devices and drivers
2. Event logs
3. Scheduled/triggered tasks
4. Disks and volumes
Choose the correct code.
(a) Event Viewer
(b) Device Manager
(c) Task Scheduler
(d) Disk Management
1. Hardware devices and drivers
2. Event logs
3. Scheduled/triggered tasks
4. Disks and volumes
Choose the correct code.
Explanation:
• Event Viewer maps to logs and Device Manager maps to devices/drivers.
• Task Scheduler manages scheduled or triggered tasks.
• Disk Management manages disks and volumes, giving 2-1-3-4.
• Task Scheduler manages scheduled or triggered tasks.
• Disk Management manages disks and volumes, giving 2-1-3-4.
వివరణ:
Question 154
ప్రశ్న 154
A table has 900 rows and 12 columns. What are its cardinality and degree?
Explanation:
• Cardinality of a relation is its number of rows or tuples.
• Degree is its number of attributes or columns.
• Therefore the values are 900 and 12 respectively.
• Degree is its number of attributes or columns.
• Therefore the values are 900 and 12 respectively.
వివరణ:
Question 155
ప్రశ్న 155
Which Access object is designed primarily for formatted, grouped and printable presentation of data?
Explanation:
• Reports are designed for formatted output and summarization.
• They support grouping, sorting and totals for presentation or printing.
• Tables store the underlying records.
• They support grouping, sorting and totals for presentation or printing.
• Tables store the underlying records.
వివరణ:
Question 156
ప్రశ్న 156
Which operating-system function decides which ready process receives CPU time next?
Explanation:
• CPU scheduling selects among ready processes or threads for processor execution.
• The scheduler supports multiprogramming and responsiveness.
• Disk formatting and document operations are unrelated to CPU allocation.
• The scheduler supports multiprogramming and responsiveness.
• Disk formatting and document operations are unrelated to CPU allocation.
వివరణ:
Question 157
ప్రశ్న 157
Which fields can a basic packet filter commonly use when deciding whether to permit traffic?
Explanation:
• Packet filters commonly inspect network and transport header information.
• Addresses, protocols and ports are typical policy fields.
• They do not make decisions from unrelated document or printer settings.
• Addresses, protocols and ports are typical policy fields.
• They do not make decisions from unrelated document or printer settings.
వివరణ:
Question 158
ప్రశ్న 158
Which command copies all .TXT files from the current directory to D:BACKUP?
Explanation:
• The wildcard *.TXT selects files with the TXT extension.
• COPY duplicates those matching files to the specified destination.
• REN, TYPE and DEL perform rename, display and deletion operations.
• COPY duplicates those matching files to the specified destination.
• REN, TYPE and DEL perform rename, display and deletion operations.
వివరణ:
Question 159
ప్రశ్న 159
Which statement about an LCD monitor is correct?
Explanation:
• LCD stands for Liquid Crystal Display.
• Liquid-crystal elements modulate light to form the displayed image.
• LCD is a display technology rather than a storage or printing method.
• Liquid-crystal elements modulate light to form the displayed image.
• LCD is a display technology rather than a storage or printing method.
వివరణ:
Question 160
ప్రశ్న 160
Which cell reference fixes both the column and row when copied?
Explanation:
• A dollar sign before the column fixes the column.
• A dollar sign before the row fixes the row.
• $C$5 is therefore an absolute reference to both components.
• A dollar sign before the row fixes the row.
• $C$5 is therefore an absolute reference to both components.
వివరణ:
Question 161
ప్రశ్న 161
What does =MOD(38,7) return?
Explanation:
• MOD returns the remainder after division.
• 38 = 7×5 + 3.
• Therefore the remainder is 3.
• 38 = 7×5 + 3.
• Therefore the remainder is 3.
వివరణ:
Question 162
ప్రశ్న 162
Which integrity rule helps prevent an Order row from referring to a CustomerID that does not exist in the Customers table?
Explanation:
• Referential integrity requires foreign-key references to correspond to valid referenced keys, subject to allowed null behavior.
• It keeps relationships between tables logically consistent.
• This is distinct from display or compression features.
• It keeps relationships between tables logically consistent.
• This is distinct from display or compression features.
వివరణ:
Question 163
ప్రశ్న 163
What is the main performance trade-off of creating an index on a frequently searched column?
Explanation:
• Indexes provide auxiliary structures that can speed suitable lookups.
• The DBMS must update affected index entries when underlying data changes.
• Thus read performance can improve at the cost of storage and write overhead.
• The DBMS must update affected index entries when underlying data changes.
• Thus read performance can improve at the cost of storage and write overhead.
వివరణ:
Question 164
ప్రశ్న 164
Which chart type is generally most suitable for showing a trend over time?
Explanation:
• Line charts emphasize changes across an ordered sequence such as time.
• They make rises, falls and trends easy to compare.
• Pie charts are intended primarily for part-to-whole composition at one point.
• They make rises, falls and trends easy to compare.
• Pie charts are intended primarily for part-to-whole composition at one point.
వివరణ:
Question 165
ప్రశ్న 165
Which device converts sound into an electrical/digital input signal for a computer?
Explanation:
• A microphone is an audio input device.
• It converts acoustic energy into a signal that can be digitized and processed.
• Speakers are output devices that perform the reverse direction of conversion.
• It converts acoustic energy into a signal that can be digitized and processed.
• Speakers are output devices that perform the reverse direction of conversion.
వివరణ:
Question 166
ప్రశ్న 166
Which motherboard interface is most commonly used for a modern high-performance discrete graphics card?
Explanation:
• Modern discrete graphics cards normally use PCI Express expansion slots.
• An x16 mechanical slot provides the lane arrangement commonly used for GPUs.
• DIMM slots hold memory and SATA connectors attach storage devices.
• An x16 mechanical slot provides the lane arrangement commonly used for GPUs.
• DIMM slots hold memory and SATA connectors attach storage devices.
వివరణ:
Question 167
ప్రశ్న 167
Which print layout places one slide on a page together with its associated speaker notes?
Explanation:
• Notes Pages combine the slide image with its speaker notes.
• They are useful as a presenter reference.
• Handouts usually arrange multiple slide thumbnails for audience use.
• They are useful as a presenter reference.
• Handouts usually arrange multiple slide thumbnails for audience use.
వివరణ:
Question 168
ప్రశ్న 168
Which memory technology can traditionally be erased by exposure to ultraviolet light and then reprogrammed?
Explanation:
• EPROM is Erasable Programmable Read-Only Memory.
• Traditional EPROM devices use ultraviolet light for erasure before reprogramming.
• EEPROM, by contrast, is electrically erasable.
• Traditional EPROM devices use ultraviolet light for erasure before reprogramming.
• EEPROM, by contrast, is electrically erasable.
వివరణ:
Question 169
ప్రశ్న 169
What does =ROUND(17.46,1) return?
Explanation:
• ROUND to one decimal place examines the hundredths digit.
• The hundredths digit is 6, so the tenths digit 4 is rounded up to 5.
• The result is 17.5.
• The hundredths digit is 6, so the tenths digit 4 is rounded up to 5.
• The result is 17.5.
వివరణ:
Question 170
ప్రశ్న 170
Which printer is an impact printer that forms characters using pins striking an inked ribbon?
Explanation:
• Dot-matrix printers are impact devices that strike a ribbon with a print head containing pins.
• They can produce multipart forms because physical impact is involved.
• Laser and inkjet printers are non-impact technologies.
• They can produce multipart forms because physical impact is involved.
• Laser and inkjet printers are non-impact technologies.
వివరణ:
Question 171
ప్రశ్న 171
Two transactions read the same value and later one overwrites the other's change using the old value. Which anomaly is illustrated?
Explanation:
• A lost update occurs when a later write overwrites a concurrent transaction's modification.
• The overwritten update effectively disappears from the final database state.
• Concurrency-control mechanisms such as locking can prevent this.
• The overwritten update effectively disappears from the final database state.
• Concurrency-control mechanisms such as locking can prevent this.
వివరణ:
Question 172
ప్రశ్న 172
What is an application-proxy gateway?
Explanation:
• An application proxy terminates or mediates application connections.
• It can enforce controls using application-level understanding.
• This deeper processing distinguishes it from simple header-only packet filtering.
• It can enforce controls using application-level understanding.
• This deeper processing distinguishes it from simple header-only packet filtering.
వివరణ:
Question 173
ప్రశ్న 173
Which statement most accurately distinguishes a DBMS from an RDBMS?
Explanation:
• DBMS is the broad category of software for managing databases.
• An RDBMS implements the relational model using relations, keys and constraints.
• Therefore every RDBMS is a DBMS, but not every DBMS must be relational.
• An RDBMS implements the relational model using relations, keys and constraints.
• Therefore every RDBMS is a DBMS, but not every DBMS must be relational.
వివరణ:
Question 174
ప్రశ్న 174
Which Word option is intended to limit what other users can edit in a document?
Explanation:
• Restrict Editing can limit permitted changes to a document.
• It can allow specific editing types or exceptions depending on configuration.
• It is an access/control feature rather than a formatting utility.
• It can allow specific editing types or exceptions depending on configuration.
• It is an access/control feature rather than a formatting utility.
వివరణ:
Question 175
ప్రశ్న 175
Cells B2:B5 contain {2,4,3,5} and C2:C5 contain {10,6,8,4}. What is =SUMPRODUCT(B2:B5,C2:C5)?
Explanation:
• SUMPRODUCT multiplies corresponding elements and sums the products.
• 2×10 + 4×6 + 3×8 + 5×4 = 20+24+24+20.
• The total is 88.
• 2×10 + 4×6 + 3×8 + 5×4 = 20+24+24+20.
• The total is 88.
వివరణ:
Question 176
ప్రశ్న 176
A newly attached disk appears in Device Manager but not in File Explorer. Which tool should be checked next to initialize, partition or assign a drive letter if needed?
Explanation:
• A disk can be detected as hardware without yet having a usable mounted volume.
• Disk Management shows disk initialization, partition and drive-letter status.
• File Explorer normally displays accessible mounted volumes rather than raw uninitialized disks.
• Disk Management shows disk initialization, partition and drive-letter status.
• File Explorer normally displays accessible mounted volumes rather than raw uninitialized disks.
వివరణ:
Question 177
ప్రశ్న 177
A system restarts randomly only when the CPU is under heavy load. Temperatures are normal, but voltage-monitoring logs show unstable power rails. Which component should be suspected first?
Explanation:
• Load-dependent restarts with unstable supply voltages point to a power-delivery problem.
• The PSU must maintain regulated power as component demand rises.
• Input peripherals do not normally cause system-wide voltage instability.
• The PSU must maintain regulated power as component demand rises.
• Input peripherals do not normally cause system-wide voltage instability.
వివరణ:
Question 178
ప్రశ్న 178
Which Access object is most appropriate for providing a user-friendly interface for entering and editing records?
Explanation:
• Forms provide an interactive interface for viewing and editing records.
• Controls can be bound to fields in underlying tables or queries.
• Reports are primarily intended for formatted output rather than routine data entry.
• Controls can be bound to fields in underlying tables or queries.
• Reports are primarily intended for formatted output rather than routine data entry.
వివరణ:
Question 179
ప్రశ్న 179
Match List I with List II:
(a) Styles
(b) Mail Merge
(c) Track Changes
(d) Section Break
1. Personalized documents
2. Reusable formatting
3. Revision recording
4. Independent section formatting
Choose the correct code.
(a) Styles
(b) Mail Merge
(c) Track Changes
(d) Section Break
1. Personalized documents
2. Reusable formatting
3. Revision recording
4. Independent section formatting
Choose the correct code.
Explanation:
• Styles map to reusable formatting and Mail Merge to personalized documents.
• Track Changes records revisions.
• Section breaks allow independent document-section formatting, giving 2-1-3-4.
• Track Changes records revisions.
• Section breaks allow independent document-section formatting, giving 2-1-3-4.
వివరణ:
Question 180
ప్రశ్న 180
Which statement best describes a traditional dial-up modem?
Explanation:
• Modem is derived from modulator-demodulator.
• Traditional dial-up modems convert between computer data and signals suitable for analog telephone lines.
• This communications function differs from storage and peripheral-image capture.
• Traditional dial-up modems convert between computer data and signals suitable for analog telephone lines.
• This communications function differs from storage and peripheral-image capture.
వివరణ:
Question 181
ప్రశ్న 181
Which statement correctly compares Internet and intranet technologies?
Explanation:
• Internet and intranet environments can both use TCP/IP, browsers and web servers.
• The principal distinction is scope and access rather than a mandatory difference in protocol technology.
• An intranet can be protected by authentication, authorization and firewalls.
• The principal distinction is scope and access rather than a mandatory difference in protocol technology.
• An intranet can be protected by authentication, authorization and firewalls.
వివరణ:
Question 182
ప్రశ్న 182
During PC assembly, why should a technician use electrostatic-discharge precautions when handling RAM and expansion cards?
Explanation:
• Semiconductor components can be damaged by electrostatic discharge.
• Grounding and appropriate handling reduce the voltage difference between the technician and hardware.
• ESD precautions are preventive hardware-safety measures, not performance enhancements.
• Grounding and appropriate handling reduce the voltage difference between the technician and hardware.
• ESD precautions are preventive hardware-safety measures, not performance enhancements.
వివరణ:
Question 183
ప్రశ్న 183
What is the main purpose of a cryptographic hash function?
Explanation:
• A cryptographic hash maps arbitrary input to a fixed-length digest for the algorithm.
• It is designed as a one-way transformation rather than reversible encryption.
• Comparing digests can help detect changes to data.
• It is designed as a one-way transformation rather than reversible encryption.
• Comparing digests can help detect changes to data.
వివరణ:
Question 184
ప్రశ్న 184
What is the defining erase characteristic of EEPROM?
Explanation:
• EEPROM is electrically erasable and reprogrammable non-volatile memory.
• Unlike EPROM, it does not require ultraviolet erasure.
• Its contents persist without continuous power.
• Unlike EPROM, it does not require ultraviolet erasure.
• Its contents persist without continuous power.
వివరణ:
Question 185
ప్రశ్న 185
Microsoft troubleshooting guidance commonly recommends which order when both the Windows component store and protected system files may be corrupted?
Explanation:
• DISM /RestoreHealth repairs the Windows image/component store used as a repair source.
• SFC can then verify and repair protected system files.
• Formatting is destructive and not a normal first-line repair sequence.
• SFC can then verify and repair protected system files.
• Formatting is destructive and not a normal first-line repair sequence.
వివరణ:
Question 186
ప్రశ్న 186
Which condition occurs when T1 waits for a lock held by T2 while T2 waits for a lock held by T1?
Explanation:
• This circular wait prevents either transaction from progressing.
• The DBMS typically detects the deadlock and selects a victim transaction to abort.
• Deadlock is a concurrency-control problem.
• The DBMS typically detects the deadlock and selects a victim transaction to abort.
• Deadlock is a concurrency-control problem.
వివరణ:
Question 187
ప్రశ్న 187
Which statement correctly compares SRAM and DRAM?
Explanation:
• SRAM uses bistable storage cells and does not require DRAM-style refresh.
• DRAM stores charge in capacitor-based cells and must be refreshed periodically.
• SRAM is commonly used for cache, while DRAM is widely used for main memory.
• DRAM stores charge in capacitor-based cells and must be refreshed periodically.
• SRAM is commonly used for cache, while DRAM is widely used for main memory.
వివరణ:
Question 188
ప్రశ్న 188
Which DOS command creates a new directory named CASES?
Explanation:
• MD, also available as MKDIR, creates a directory.
• CD changes the current directory and RD removes a directory.
• DIR displays directory contents.
• CD changes the current directory and RD removes a directory.
• DIR displays directory contents.
వివరణ:
Question 189
ప్రశ్న 189
Which Excel feature is used to restrict cell entries to a predefined list such as Open, Pending and Closed?
Explanation:
• Data Validation can restrict permitted values in selected cells.
• A List validation rule can provide a drop-down of predefined choices.
• This helps maintain consistent data entry.
• A List validation rule can provide a drop-down of predefined choices.
• This helps maintain consistent data entry.
వివరణ:
Question 190
ప్రశ్న 190
In a public-key digital-signature system, which key is normally used by the signer to create the signature?
Explanation:
• The signer creates a digital signature using the private key.
• The corresponding public key is used to verify the signature.
• Signatures support integrity and signer authentication rather than confidentiality by themselves.
• The corresponding public key is used to verify the signature.
• Signatures support integrity and signer authentication rather than confidentiality by themselves.
వివరణ:
Question 191
ప్రశ్న 191
A monitor shows 'No Signal' but the computer appears to boot normally. What should be checked first?
Explanation:
• A no-signal message indicates that the display is not receiving a valid video signal.
• Cable seating, selected input source and graphics output are immediate checks.
• Unrelated application or printer settings do not establish the video link.
• Cable seating, selected input source and graphics output are immediate checks.
• Unrelated application or printer settings do not establish the video link.
వివరణ:
Question 192
ప్రశ్న 192
What does the formula =SUM(A1:A5) return?
Explanation:
• SUM adds numeric values in the specified range.
• A1:A5 denotes the contiguous range from A1 through A5.
• AVERAGE, COUNTA and MAX perform different operations.
• A1:A5 denotes the contiguous range from A1 through A5.
• AVERAGE, COUNTA and MAX perform different operations.
వివరణ:
Question 193
ప్రశ్న 193
Which statement correctly describes a computer virus?
Explanation:
• A computer virus is malicious code that infects host files or executable content.
• Replication typically occurs when infected content is executed or activated.
• Viruses are software threats, not hardware defects or storage layouts.
• Replication typically occurs when infected content is executed or activated.
• Viruses are software threats, not hardware defects or storage layouts.
వివరణ:
Question 194
ప్రశ్న 194
What is the primary security goal of encryption?
Explanation:
• Encryption transforms plaintext into ciphertext using cryptographic keys.
• Its primary purpose is to prevent unauthorized disclosure of protected data.
• Integrity and authentication may require additional mechanisms.
• Its primary purpose is to prevent unauthorized disclosure of protected data.
• Integrity and authentication may require additional mechanisms.
వివరణ:
Question 195
ప్రశ్న 195
How many point-to-point links are required for a full mesh of 7 nodes?
Explanation:
• A full mesh requires n(n−1)/2 unique links.
• For 7 nodes, 7×6÷2 = 21.
• Division by two avoids counting each pair twice.
• For 7 nodes, 7×6÷2 = 21.
• Division by two avoids counting each pair twice.
వివరణ:
Question 196
ప్రశ్న 196
In a star topology, what is the effect of failure of one workstation's individual cable?
Explanation:
• Each endpoint in a star has its own link to the central device.
• Failure of one endpoint cable normally isolates only that endpoint.
• Failure of the central switch is the larger common point of failure.
• Failure of one endpoint cable normally isolates only that endpoint.
• Failure of the central switch is the larger common point of failure.
వివరణ:
Question 197
ప్రశ్న 197
Which statement about VPN security is correct?
Explanation:
• VPNs protect network communication between defined endpoints.
• Malware already running on an endpoint can remain active after the tunnel is established.
• Endpoint protection, patching and authorization are therefore still necessary.
• Malware already running on an endpoint can remain active after the tunnel is established.
• Endpoint protection, patching and authorization are therefore still necessary.
వివరణ:
Question 198
ప్రశ్న 198
Which DOS/Windows command changes FILE1.TXT to FILE2.TXT in the same directory?
Explanation:
• REN changes the name of an existing file or directory.
• The first argument identifies the current name and the second gives the new name.
• COPY creates another file instead of simply renaming the original.
• The first argument identifies the current name and the second gives the new name.
• COPY creates another file instead of simply renaming the original.
వివరణ:
Question 199
ప్రశ్న 199
Which feature keeps selected rows and/or columns visible while the rest of a worksheet scrolls?
Explanation:
• Freeze Panes locks selected rows or columns in view.
• It is useful for keeping headers visible in large worksheets.
• It does not change the underlying data or formulas.
• It is useful for keeping headers visible in large worksheets.
• It does not change the underlying data or formulas.
వివరణ:
Question 200
ప్రశ్న 200
Which statement correctly describes preemptive multitasking?
Explanation:
• Preemptive scheduling allows the OS to regain control of the processor.
• A time slice or higher-priority event can cause the current task to be preempted.
• This supports responsive multitasking among multiple runnable tasks.
• A time slice or higher-priority event can cause the current task to be preempted.
• This supports responsive multitasking among multiple runnable tasks.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: C. Shut down and verify cooler seating, fan connection and thermal interface material సమాధానం: C.
-
Question 2 ప్రశ్న 2Answer: B. To isolate a suspicious or malicious item from normal execution while it is reviewed or removed సమాధానం: B.
-
Question 3 ప్రశ్న 3Answer: C. To require consent or suitable administrator credentials for operations needing elevated privileges సమాధానం: C.
-
Question 4 ప్రశ్న 4Answer: A. Compare సమాధానం: A.
-
Question 5 ప్రశ్న 5Answer: B. Control Unit సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: D. Table of Contents సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: B. Authentication verifies identity; authorization determines permitted actions or resources సమాధానం: B.
-
Question 8 ప్రశ్న 8Answer: D. Navigation Pane సమాధానం: D.
-
Question 9 ప్రశ్న 9Answer: D. 9 TB సమాధానం: D.
-
Question 10 ప్రశ్న 10Answer: B. Ordinary system RAM is volatile and normally loses its contents when power is removed సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: B. 800 సమాధానం: B.
-
Question 12 ప్రశ్న 12Answer: C. =$A5*D$1 సమాధానం: C.
-
Question 13 ప్రశ్న 13Answer: C. SMPS సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: A. Deadlock సమాధానం: A.
-
Question 15 ప్రశ్న 15Answer: A. Automatic సమాధానం: A.
-
Question 16 ప్రశ్న 16Answer: B. A bus is a communication pathway used to transfer data, addresses or control signals among components సమాధానం: B.
-
Question 17 ప్రశ్న 17Answer: B. Disk Management సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: D. Saving the state of one running task and restoring the state of another so the CPU can switch execution సమాధానం: D.
-
Question 19 ప్రశ్న 19Answer: A. A private organizational network or information environment intended primarily for authorized users సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: D. Transitive dependency of non-key attributes on a key through another non-key attribute సమాధానం: D.
-
Question 21 ప్రశ్న 21Answer: A. Compress Media సమాధానం: A.
-
Question 22 ప్రశ్న 22Answer: B. HTTPS సమాధానం: B.
-
Question 23 ప్రశ్న 23Answer: D. Boot order and the presence of valid boot files or a bootable operating system on the SSD సమాధానం: D.
-
Question 24 ప్రశ్న 24Answer: D. LAN → MAN → WAN సమాధానం: D.
-
Question 25 ప్రశ్న 25Answer: D. A program is passive code, while a process is an executing instance with state and resources సమాధానం: D.
-
Question 26 ప్రశ్న 26Answer: D. 25 సమాధానం: D.
-
Question 27 ప్రశ్న 27Answer: A. HDMI సమాధానం: A.
-
Question 28 ప్రశ్న 28Answer: B. Program Counter సమాధానం: B.
-
Question 29 ప్రశ్న 29Answer: D. 8 TB సమాధానం: D.
-
Question 30 ప్రశ్న 30Answer: D. Transition సమాధానం: D.
-
Question 31 ప్రశ్న 31Answer: B. A system that controls network traffic between interfaces or zones according to security policy సమాధానం: B.
-
Question 32 ప్రశ్న 32Answer: D. A subform linked to the main form by CaseID సమాధానం: D.
-
Question 33 ప్రశ్న 33Answer: B. Software that allows the operating system to communicate with and control a hardware device సమాధానం: B.
-
Question 34 ప్రశ్న 34Answer: A. 1, 2 and 3 only సమాధానం: A.
-
Question 35 ప్రశ్న 35Answer: C. Laser printer సమాధానం: C.
-
Question 36 ప్రశ్న 36Answer: C. PivotTable సమాధానం: C.
-
Question 37 ప్రశ్న 37Answer: A. A record or tuple సమాధానం: A.
-
Question 38 ప్రశ్న 38Answer: D. Styles సమాధానం: D.
-
Question 39 ప్రశ్న 39Answer: A. CPU registers → cache → RAM → secondary storage సమాధానం: A.
-
Question 40 ప్రశ్న 40Answer: D. Symmetric cryptography uses shared secret-key material, while asymmetric cryptography uses a related public/private key pair సమాధానం: D.
-
Question 41 ప్రశ్న 41Answer: D. Power down, reseat the card, verify slot compatibility and required auxiliary power, then retest సమాధానం: D.
-
Question 42 ప్రశ్న 42Answer: C. 12.35 సమాధానం: C.
-
Question 43 ప్రశ్న 43Answer: A. Arithmetic Logic Unit (ALU) సమాధానం: A.
-
Question 44 ప్రశ్న 44Answer: B. Different First Page సమాధానం: B.
-
Question 45 ప్రశ్న 45Answer: B. Action or hyperlink సమాధానం: B.
-
Question 46 ప్రశ్న 46Answer: A. Find and Replace సమాధానం: A.
-
Question 47 ప్రశ్న 47Answer: B. Section Break (Next Page) సమాధానం: B.
-
Question 48 ప్రశ్న 48Answer: C. 6144 MiB సమాధానం: C.
-
Question 49 ప్రశ్న 49Answer: C. Router సమాధానం: C.
-
Question 50 ప్రశ్న 50Answer: B. Power-on → firmware/POST → boot manager or loader → operating-system initialization సమాధానం: B.
-
Question 51 ప్రశ్న 51Answer: B. A transaction's operations are treated as an all-or-nothing unit సమాధానం: B.
-
Question 52 ప్రశ్న 52Answer: D. 6 ns సమాధానం: D.
-
Question 53 ప్రశ్న 53Answer: C. 16 MiB సమాధానం: C.
-
Question 54 ప్రశ్న 54Answer: B. (a)-3, (b)-4, (c)-2, (d)-1 సమాధానం: B.
-
Question 55 ప్రశ్న 55Answer: C. Vacuum tubes సమాధానం: C.
-
Question 56 ప్రశ్న 56Answer: C. Scanner సమాధానం: C.
-
Question 57 ప్రశ్న 57Answer: A. Third generation సమాధానం: A.
-
Question 58 ప్రశ్న 58Answer: B. Set cell సమాధానం: B.
-
Question 59 ప్రశ్న 59Answer: C. Keep with next సమాధానం: C.
-
Question 60 ప్రశ్న 60Answer: C. Good response time సమాధానం: C.
-
Question 61 ప్రశ్న 61Answer: D. Slide Master సమాధానం: D.
-
Question 62 ప్రశ్న 62Answer: B. DNS సమాధానం: B.
-
Question 63 ప్రశ్న 63Answer: D. To detect filled or marked positions on specially designed forms సమాధానం: D.
-
Question 64 ప్రశ్న 64Answer: D. Parameter query సమాధానం: D.
-
Question 65 ప్రశ్న 65Answer: C. DNS name resolution సమాధానం: C.
-
Question 66 ప్రశ్న 66Answer: C. Input Mask సమాధానం: C.
-
Question 67 ప్రశ్న 67Answer: C. 1, 2 and 3 only సమాధానం: C.
-
Question 68 ప్రశ్న 68Answer: C. Characters printed with magnetically detectable ink or toner సమాధానం: C.
-
Question 69 ప్రశ్న 69Answer: D. Running → Waiting/Blocked సమాధానం: D.
-
Question 70 ప్రశ్న 70Answer: D. sfc /scannow సమాధానం: D.
-
Question 71 ప్రశ్న 71Answer: A. It allows the operating system to give processes virtual address spaces that can exceed the currently available physical RAM సమాధానం: A.
-
Question 72 ప్రశ్న 72Answer: B. ipconfig /flushdns సమాధానం: B.
-
Question 73 ప్రశ్న 73Answer: D. DHCP సమాధానం: D.
-
Question 74 ప్రశ్న 74Answer: B. The keyboard itself is probably functional, so the second computer's USB ports/controller or configuration should be investigated సమాధానం: B.
-
Question 75 ప్రశ్న 75Answer: D. tracert సమాధానం: D.
-
Question 76 ప్రశ్న 76Answer: A. Second Normal Form (2NF) సమాధానం: A.
-
Question 77 ప్రశ్న 77Answer: A. Registers సమాధానం: A.
-
Question 78 ప్రశ్న 78Answer: A. A global system of interconnected networks using common networking protocols సమాధానం: A.
-
Question 79 ప్రశ్న 79Answer: A. Presenter View సమాధానం: A.
-
Question 80 ప్రశ్న 80Answer: A. AutoNumber సమాధానం: A.
-
Question 81 ప్రశ్న 81Answer: A. An SSD has no mechanical seek or rotational delay and generally provides lower random-access latency సమాధానం: A.
-
Question 82 ప్రశ్న 82Answer: D. PROM సమాధానం: D.
-
Question 83 ప్రశ్న 83Answer: C. A child foreign-key value that has no matching parent key సమాధానం: C.
-
Question 84 ప్రశ్న 84Answer: C. Update query సమాధానం: C.
-
Question 85 ప్రశ్న 85Answer: B. FAIL సమాధానం: B.
-
Question 86 ప్రశ్న 86Answer: C. (a)-1, (b)-2, (c)-3, (d)-4 సమాధానం: C.
-
Question 87 ప్రశ్న 87Answer: A. Instruction Register సమాధానం: A.
-
Question 88 ప్రశ్న 88Answer: D. It can roll back selected system files, drivers, registry settings and configuration to an earlier restore point సమాధానం: D.
-
Question 89 ప్రశ్న 89Answer: B. Slide Sorter view సమాధానం: B.
-
Question 90 ప్రశ్న 90Answer: A. False positive సమాధానం: A.
-
Question 91 ప్రశ్న 91Answer: A. Placing jobs in a queue or disk buffer so a slower peripheral can process them sequentially సమాధానం: A.
-
Question 92 ప్రశ్న 92Answer: C. =SUBTOTAL(9,D2:D100) సమాధానం: C.
-
Question 93 ప్రశ్న 93Answer: C. Append query సమాధానం: C.
-
Question 94 ప్రశ్న 94Answer: C. To handle audio input/output conversion and processing for the computer సమాధానం: C.
-
Question 95 ప్రశ్న 95Answer: A. To initialize and check essential hardware before booting the operating system సమాధానం: A.
-
Question 96 ప్రశ్న 96Answer: C. Password plus independently verified hardware token సమాధానం: C.
-
Question 97 ప్రశ్న 97Answer: B. (a)-2, (b)-3, (c)-1, (d)-4 సమాధానం: B.
-
Question 98 ప్రశ్న 98Answer: A. Plotter సమాధానం: A.
-
Question 99 ప్రశ్న 99Answer: D. Standard user account సమాధానం: D.
-
Question 100 ప్రశ్న 100Answer: D. It maintains information about active connections and can use that state in later decisions సమాధానం: D.
-
Question 101 ప్రశ్న 101Answer: C. Use a junction table containing StudentID and CourseID as foreign keys సమాధానం: C.
-
Question 102 ప్రశ్న 102Answer: C. Animations సమాధానం: C.
-
Question 103 ప్రశ్న 103Answer: C. ipconfig /all సమాధానం: C.
-
Question 104 ప్రశ్న 104Answer: A. Startup Repair సమాధానం: A.
-
Question 105 ప్రశ్న 105Answer: B. Custom Slide Show సమాధానం: B.
-
Question 106 ప్రశ్న 106Answer: B. Format Painter సమాధానం: B.
-
Question 107 ప్రశ్న 107Answer: C. Primary key సమాధానం: C.
-
Question 108 ప్రశ్న 108Answer: C. Ethernet switch సమాధానం: C.
-
Question 109 ప్రశ్న 109Answer: B. To represent a relationship by referencing a key in another or the same table సమాధానం: B.
-
Question 110 ప్రశ్న 110Answer: B. Validation Rule సమాధానం: B.
-
Question 111 ప్రశ్న 111Answer: D. A virtual table defined by a query over underlying data సమాధానం: D.
-
Question 112 ప్రశ్న 112Answer: B. Site-to-site VPN సమాధానం: B.
-
Question 113 ప్రశ్న 113Answer: A. RAID 0 సమాధానం: A.
-
Question 114 ప్రశ్న 114Answer: A. Number with Field Size Long Integer సమాధానం: A.
-
Question 115 ప్రశ్న 115Answer: A. Device Manager సమాధానం: A.
-
Question 116 ప్రశ్న 116Answer: C. Crosstab query సమాధానం: C.
-
Question 117 ప్రశ్న 117Answer: B. (a)-2, (b)-1, (c)-3, (d)-4 సమాధానం: B.
-
Question 118 ప్రశ్న 118Answer: B. Durability సమాధానం: B.
-
Question 119 ప్రశ్న 119Answer: B. Use updated security software, restrict autorun behavior and scan untrusted media before opening files సమాధానం: B.
-
Question 120 ప్రశ్న 120Answer: B. Event Viewer సమాధానం: B.
-
Question 121 ప్రశ్న 121Answer: A. Optical mouse సమాధానం: A.
-
Question 122 ప్రశ్న 122Answer: D. Dirty read సమాధానం: D.
-
Question 123 ప్రశ్న 123Answer: A. The requested data or instruction is found in the cache being checked సమాధానం: A.
-
Question 124 ప్రశ్న 124Answer: D. To record edits so insertions, deletions and formatting changes can be reviewed సమాధానం: D.
-
Question 125 ప్రశ్న 125Answer: C. Starting Windows with a limited set of drivers and services for troubleshooting సమాధానం: C.
-
Question 126 ప్రశ్న 126Answer: B. CD .. సమాధానం: B.
-
Question 127 ప్రశ్న 127Answer: C. Motherboard సమాధానం: C.
-
Question 128 ప్రశ్న 128Answer: B. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion సమాధానం: B.
-
Question 129 ప్రశ్న 129Answer: A. Delete query సమాధానం: A.
-
Question 130 ప్రశ్న 130Answer: D. A reference such as A1 can change its row and column when the formula is copied సమాధానం: D.
-
Question 131 ప్రశ్న 131Answer: C. A method for organizing, naming, storing and retrieving files and directories on storage media సమాధానం: C.
-
Question 132 ప్రశ్న 132Answer: A. KVM switch సమాధానం: A.
-
Question 133 ప్రశ్న 133Answer: D. Hard disk drive సమాధానం: D.
-
Question 134 ప్రశ్న 134Answer: D. 3 సమాధానం: D.
-
Question 135 ప్రశ్న 135Answer: A. It uses mirroring so two equal drives provide approximately the capacity of one drive సమాధానం: A.
-
Question 136 ప్రశ్న 136Answer: A. Error సమాధానం: A.
-
Question 137 ప్రశ్న 137Answer: C. Processing సమాధానం: C.
-
Question 138 ప్రశ్న 138Answer: B. To signal the CPU that an event requires attention so normal execution can be temporarily redirected సమాధానం: B.
-
Question 139 ప్రశ్న 139Answer: B. RAID 10 సమాధానం: B.
-
Question 140 ప్రశ్న 140Answer: B. Firmware initializes hardware and starts the boot process; the operating system manages system resources after loading సమాధానం: B.
-
Question 141 ప్రశ్న 141Answer: A. 1, 2 and 3 only సమాధానం: A.
-
Question 142 ప్రశ్న 142Answer: D. Verify wall power, PSU switch, main ATX power and CPU power connections సమాధానం: D.
-
Question 143 ప్రశ్న 143Answer: D. 1, 2 and 3 only సమాధానం: D.
-
Question 144 ప్రశ్న 144Answer: D. To provide a router for destinations outside the local subnet when no more specific route exists సమాధానం: D.
-
Question 145 ప్రశ్న 145Answer: C. COMMIT సమాధానం: C.
-
Question 146 ప్రశ్న 146Answer: A. Table సమాధానం: A.
-
Question 147 ప్రశ్న 147Answer: C. They are on the same IP subnet and can communicate locally without routing through the default gateway సమాధానం: C.
-
Question 148 ప్రశ్న 148Answer: D. Mail Merge సమాధానం: D.
-
Question 149 ప్రశ్న 149Answer: B. Query సమాధానం: B.
-
Question 150 ప్రశ్న 150Answer: D. Task Scheduler సమాధానం: D.
-
Question 151 ప్రశ్న 151Answer: A. Prepare main document → select recipients → insert merge fields → preview → Finish & Merge సమాధానం: A.
-
Question 152 ప్రశ్న 152Answer: C. Self-contained propagation across networks without needing to attach to a host executable సమాధానం: C.
-
Question 153 ప్రశ్న 153Answer: A. (a)-2, (b)-1, (c)-3, (d)-4 సమాధానం: A.
-
Question 154 ప్రశ్న 154Answer: B. Cardinality = 900; Degree = 12 సమాధానం: B.
-
Question 155 ప్రశ్న 155Answer: B. Report సమాధానం: B.
-
Question 156 ప్రశ్న 156Answer: C. CPU scheduling సమాధానం: C.
-
Question 157 ప్రశ్న 157Answer: B. Source/destination addresses, protocol and port information సమాధానం: B.
-
Question 158 ప్రశ్న 158Answer: A. COPY *.TXT D:BACKUP సమాధానం: A.
-
Question 159 ప్రశ్న 159Answer: A. It uses liquid-crystal elements to control light and is a flat-panel display technology సమాధానం: A.
-
Question 160 ప్రశ్న 160Answer: C. $C$5 సమాధానం: C.
-
Question 161 ప్రశ్న 161Answer: A. 3 సమాధానం: A.
-
Question 162 ప్రశ్న 162Answer: D. Referential integrity సమాధానం: D.
-
Question 163 ప్రశ్న 163Answer: D. Queries may become faster, but inserts, updates and deletes can incur extra maintenance overhead సమాధానం: D.
-
Question 164 ప్రశ్న 164Answer: C. Line chart సమాధానం: C.
-
Question 165 ప్రశ్న 165Answer: C. Microphone సమాధానం: C.
-
Question 166 ప్రశ్న 166Answer: D. PCI Express x16 slot సమాధానం: D.
-
Question 167 ప్రశ్న 167Answer: D. Notes Pages సమాధానం: D.
-
Question 168 ప్రశ్న 168Answer: B. EPROM సమాధానం: B.
-
Question 169 ప్రశ్న 169Answer: B. 17.5 సమాధానం: B.
-
Question 170 ప్రశ్న 170Answer: A. Dot-matrix printer సమాధానం: A.
-
Question 171 ప్రశ్న 171Answer: D. Lost update సమాధానం: D.
-
Question 172 ప్రశ్న 172Answer: A. An application-aware intermediary that can create separate client-to-proxy and proxy-to-server connections సమాధానం: A.
-
Question 173 ప్రశ్న 173Answer: B. An RDBMS is a DBMS based on the relational model, while DBMS is a broader category సమాధానం: B.
-
Question 174 ప్రశ్న 174Answer: A. Restrict Editing సమాధానం: A.
-
Question 175 ప్రశ్న 175Answer: B. 88 సమాధానం: B.
-
Question 176 ప్రశ్న 176Answer: D. Disk Management సమాధానం: D.
-
Question 177 ప్రశ్న 177Answer: C. Power supply unit సమాధానం: C.
-
Question 178 ప్రశ్న 178Answer: B. Form సమాధానం: B.
-
Question 179 ప్రశ్న 179Answer: C. (a)-2, (b)-1, (c)-3, (d)-4 సమాధానం: C.
-
Question 180 ప్రశ్న 180Answer: C. It modulates digital data for transmission over an analog telephone channel and demodulates received signals సమాధానం: C.
-
Question 181 ప్రశ్న 181Answer: A. An intranet can use the same web and TCP/IP technologies as the Internet while restricting access to authorized organizational users సమాధానం: A.
-
Question 182 ప్రశ్న 182Answer: A. Static electricity can damage sensitive electronic components సమాధానం: A.
-
Question 183 ప్రశ్న 183Answer: C. To produce a one-way digest useful for integrity-related checks సమాధానం: C.
-
Question 184 ప్రశ్న 184Answer: D. It can be electrically erased and reprogrammed సమాధానం: D.
-
Question 185 ప్రశ్న 185Answer: D. Run DISM /Online /Cleanup-Image /RestoreHealth, then run sfc /scannow సమాధానం: D.
-
Question 186 ప్రశ్న 186Answer: A. Deadlock సమాధానం: A.
-
Question 187 ప్రశ్న 187Answer: C. SRAM is generally faster and does not require periodic refresh, while DRAM is denser and requires refresh సమాధానం: C.
-
Question 188 ప్రశ్న 188Answer: D. MD CASES సమాధానం: D.
-
Question 189 ప్రశ్న 189Answer: A. Data Validation సమాధానం: A.
-
Question 190 ప్రశ్న 190Answer: B. The signer's private key సమాధానం: B.
-
Question 191 ప్రశ్న 191Answer: B. Display cable, selected monitor input and graphics-output connection సమాధానం: B.
-
Question 192 ప్రశ్న 192Answer: D. The sum of the numeric values in cells A1 through A5 సమాధానం: D.
-
Question 193 ప్రశ్న 193Answer: C. Malicious code that replicates by infecting or attaching itself to other executable content సమాధానం: C.
-
Question 194 ప్రశ్న 194Answer: D. Confidentiality సమాధానం: D.
-
Question 195 ప్రశ్న 195Answer: A. 21 సమాధానం: A.
-
Question 196 ప్రశ్న 196Answer: D. Usually only that workstation loses connectivity సమాధానం: D.
-
Question 197 ప్రశ్న 197Answer: C. A VPN can protect communications but does not automatically remove malware from a compromised endpoint సమాధానం: C.
-
Question 198 ప్రశ్న 198Answer: C. REN FILE1.TXT FILE2.TXT సమాధానం: C.
-
Question 199 ప్రశ్న 199Answer: B. Freeze Panes సమాధానం: B.
-
Question 200 ప్రశ్న 200Answer: A. The operating system can interrupt a running task and give the CPU to another task సమాధానం: A.
