Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
During the fetch phase of the instruction cycle, which register supplies the address of the next instruction to memory?
Explanation:
• The Program Counter holds the address of the next instruction to be fetched.
• After a normal fetch, the PC is typically advanced to the following instruction address.
• The Instruction Register holds the fetched instruction itself rather than its next address.
• After a normal fetch, the PC is typically advanced to the following instruction address.
• The Instruction Register holds the fetched instruction itself rather than its next address.
వివరణ:
Question 2
ప్రశ్న 2
In Excel, A1:A5 contain 10, 20, 30, 40 and 50. What is returned by =AVERAGE(A1:A5)?
Explanation:
• The sum of the five values is 150.
• AVERAGE divides the total by the number of numeric values: 150÷5.
• The result is 30.
• AVERAGE divides the total by the number of numeric values: 150÷5.
• The result is 30.
వివరణ:
Question 3
ప్రశ్న 3
Consider the following relational-key statements:
1. A primary key uniquely identifies each row.
2. A primary-key value cannot be Null.
3. A foreign key may reference a key in another related table.
4. Every foreign-key value must be unique within its table.
Which statements are correct?
1. A primary key uniquely identifies each row.
2. A primary-key value cannot be Null.
3. A foreign key may reference a key in another related table.
4. Every foreign-key value must be unique within its table.
Which statements are correct?
Explanation:
• Primary keys provide unique, non-Null row identifiers, so statements 1 and 2 are correct.
• Foreign keys represent relationships by referencing a key in another table, so statement 3 is correct.
• Foreign-key values may legitimately repeat in a one-to-many relationship, making statement 4 false.
• Foreign keys represent relationships by referencing a key in another table, so statement 3 is correct.
• Foreign-key values may legitimately repeat in a one-to-many relationship, making statement 4 false.
వివరణ:
Question 4
ప్రశ్న 4
Which ordering is generally correct from fastest/smallest to slower/larger in a typical computer memory hierarchy?
Explanation:
• CPU registers are directly used by the processor and are normally the fastest storage locations.
• Caches reduce average access time between the CPU and main memory.
• RAM is slower but much larger than cache, while secondary storage is persistent and generally slower still.
• Caches reduce average access time between the CPU and main memory.
• RAM is slower but much larger than cache, while secondary storage is persistent and generally slower still.
వివరణ:
Question 5
ప్రశ్న 5
A technician is at C:CASEFILES and needs to display all files named REPORT.TXT in that directory and every subdirectory below it. Which command is most appropriate?
Explanation:
• DIR lists directory entries matching the supplied file specification.
• The /S switch extends the search through matching subdirectories.
• /W changes listing format but does not by itself recurse through subdirectories.
• The /S switch extends the search through matching subdirectories.
• /W changes listing format but does not by itself recurse through subdirectories.
వివరణ:
Question 6
ప్రశ్న 6
Which Word feature is most appropriate for applying consistent formatting to all Heading 2 paragraphs and updating them centrally later?
Explanation:
• Styles store reusable sets of formatting and structural information.
• Modifying a style can update text that uses that style throughout the document.
• This is more consistent and maintainable than manually formatting each heading.
• Modifying a style can update text that uses that style throughout the document.
• This is more consistent and maintainable than manually formatting each heading.
వివరణ:
Question 7
ప్రశ్న 7
Which statement best describes a computer virus?
Explanation:
• A traditional virus depends on host content that it infects or modifies.
• When that infected content executes, the virus code can run and spread further.
• A worm differs because it can operate as a self-contained propagating program.
• When that infected content executes, the virus code can run and spread further.
• A worm differs because it can operate as a self-contained propagating program.
వివరణ:
Question 8
ప్రశ్న 8
Which input device is designed to capture a paper photograph or document as a digital image?
Explanation:
• A scanner converts reflected optical information from paper into digital image data.
• It is commonly used for photographs, printed forms and documents.
• Plotters, projectors and speakers are primarily output devices.
• It is commonly used for photographs, printed forms and documents.
• Plotters, projectors and speakers are primarily output devices.
వివరణ:
Question 9
ప్రశ్న 9
In Microsoft Access, which object should be created to hold the actual persistent employee records before forms and reports are built?
Explanation:
• Tables are the primary storage objects for structured Access data.
• Fields define the columns and records occupy rows.
• Queries, forms and reports operate on or present stored data.
• Fields define the columns and records occupy rows.
• Queries, forms and reports operate on or present stored data.
వివరణ:
Question 10
ప్రశ్న 10
Which operating-system function decides which ready process or thread receives CPU time next?
Explanation:
• The scheduler selects among runnable processes or threads according to a scheduling policy.
• This lets the operating system share processor time among competing workloads.
• Scheduling is distinct from file and storage maintenance operations.
• This lets the operating system share processor time among competing workloads.
• Scheduling is distinct from file and storage maintenance operations.
వివరణ:
Question 11
ప్రశ్న 11
Match List I with List II:
List I
(a) LAN
(b) MAN
(c) WAN
(d) Star topology
List II
1. Wide geographical interconnection
2. Local building/campus-scale network
3. Endpoints connect through a central device
4. Metropolitan/city-scale network
Choose the correct matching code.
List I
(a) LAN
(b) MAN
(c) WAN
(d) Star topology
List II
1. Wide geographical interconnection
2. Local building/campus-scale network
3. Endpoints connect through a central device
4. Metropolitan/city-scale network
Choose the correct matching code.
Explanation:
• LAN corresponds to local coverage and MAN to metropolitan coverage, giving (a)-2 and (b)-4.
• WAN describes wide geographical interconnection, giving (c)-1.
• A star topology connects endpoints through a central device, giving (d)-3.
• WAN describes wide geographical interconnection, giving (c)-1.
• A star topology connects endpoints through a central device, giving (d)-3.
వివరణ:
Question 12
ప్రశ్న 12
Match each Office feature with its application:
(a) Mail Merge
(b) PivotTable
(c) Slide Master
(d) Crosstab Query
1. Microsoft Access
2. Microsoft PowerPoint
3. Microsoft Word
4. Microsoft Excel
Choose the correct matching code.
(a) Mail Merge
(b) PivotTable
(c) Slide Master
(d) Crosstab Query
1. Microsoft Access
2. Microsoft PowerPoint
3. Microsoft Word
4. Microsoft Excel
Choose the correct matching code.
Explanation:
• Mail Merge is a Word feature, giving (a)-3.
• PivotTable belongs to Excel and Slide Master belongs to PowerPoint, giving (b)-4 and (c)-2.
• A Crosstab Query is an Access database query type, giving (d)-1.
• PivotTable belongs to Excel and Slide Master belongs to PowerPoint, giving (b)-4 and (c)-2.
• A Crosstab Query is an Access database query type, giving (d)-1.
వివరణ:
Question 13
ప్రశ్న 13
Consider the following statements:
1. The Internet is a global system of interconnected networks.
2. An intranet is intended primarily for an authorized organizational community.
3. An intranet may use TCP/IP, HTTPS and web browsers.
4. Any service using HTTPS must automatically be a public Internet service.
Which statements are correct?
1. The Internet is a global system of interconnected networks.
2. An intranet is intended primarily for an authorized organizational community.
3. An intranet may use TCP/IP, HTTPS and web browsers.
4. Any service using HTTPS must automatically be a public Internet service.
Which statements are correct?
Explanation:
• The Internet is global and an intranet is private organizational infrastructure, so statements 1 and 2 are correct.
• Intranets can use standard Internet technologies such as TCP/IP and HTTPS, making statement 3 correct.
• HTTPS describes a protected web protocol and does not determine whether a service is public, so statement 4 is false.
• Intranets can use standard Internet technologies such as TCP/IP and HTTPS, making statement 3 correct.
• HTTPS describes a protected web protocol and does not determine whether a service is public, so statement 4 is false.
వివరణ:
Question 14
ప్రశ్న 14
Which CPU component performs arithmetic operations such as addition and logical operations such as AND and comparison?
Explanation:
• The ALU performs arithmetic and logical operations required by machine instructions.
• The Control Unit coordinates instruction execution but is not the primary arithmetic unit.
• Comparisons and bitwise Boolean operations are also typical ALU functions.
• The Control Unit coordinates instruction execution but is not the primary arithmetic unit.
• Comparisons and bitwise Boolean operations are also typical ALU functions.
వివరణ:
Question 15
ప్రశ్న 15
In Excel, A1:A6 contain 12, 18, 25, 31, 40 and 45. What is returned by =COUNTIF(A1:A6,">30")?
Explanation:
• COUNTIF counts cells that satisfy the criterion.
• Values greater than 30 are 31, 40 and 45.
• Therefore exactly 3 cells satisfy the condition.
• Values greater than 30 are 31, 40 and 45.
• Therefore exactly 3 cells satisfy the condition.
వివరణ:
Question 16
ప్రశ్న 16
What is the primary purpose of a foreign key?
Explanation:
• A foreign key stores values that correspond to a referenced key in another relation.
• It is the standard relational mechanism for representing one-to-many relationships.
• Referential-integrity rules can restrict invalid foreign-key values.
• It is the standard relational mechanism for representing one-to-many relationships.
• Referential-integrity rules can restrict invalid foreign-key values.
వివరణ:
Question 17
ప్రశ్న 17
A processor designer chooses SRAM for on-chip cache and DRAM for large-capacity main memory. Which comparison best explains this choice?
Explanation:
• SRAM uses bistable circuits and does not require DRAM-style refresh while powered.
• DRAM uses charge-based cells that must be refreshed periodically.
• SRAM is therefore common in cache, while DRAM is common in main memory because of density and cost.
• DRAM uses charge-based cells that must be refreshed periodically.
• SRAM is therefore common in cache, while DRAM is common in main memory because of density and cost.
వివరణ:
Question 18
ప్రశ్న 18
A file named EVIDENCE.TXT should be marked Read-only from the command prompt without changing its filename. Which command is appropriate?
Explanation:
• ATTRIB changes or displays file attributes.
• +R sets the Read-only attribute, while -R removes it.
• REN changes names and TYPE displays text contents rather than setting attributes.
• +R sets the Read-only attribute, while -R removes it.
• REN changes names and TYPE displays text contents rather than setting attributes.
వివరణ:
Question 19
ప్రశ్న 19
A document uses proper heading styles. Which feature can automatically generate a list of headings with page numbers?
Explanation:
• An automatic Table of Contents can be built from document heading levels.
• When pagination changes, the TOC can be updated to refresh page numbers and headings.
• Mail Merge serves personalized-document generation rather than document navigation.
• When pagination changes, the TOC can be updated to refresh page numbers and headings.
• Mail Merge serves personalized-document generation rather than document navigation.
వివరణ:
Question 20
ప్రశ్న 20
Which statement correctly distinguishes a worm from a traditional virus?
Explanation:
• Worms are self-contained malicious programs capable of autonomous propagation.
• Viruses traditionally replicate by infecting other executable content.
• Both are forms of malware and may cause serious damage.
• Viruses traditionally replicate by infecting other executable content.
• Both are forms of malware and may cause serious damage.
వివరణ:
Question 21
ప్రశ్న 21
Match List I with List II:
List I
(a) OCR
(b) OMR
(c) MICR
(d) Plotter
List II
1. Reads specially printed magnetic-ink characters
2. Detects marked response positions on structured forms
3. Converts printed character images into machine-readable text
4. Produces large technical drawings
Choose the correct matching code.
List I
(a) OCR
(b) OMR
(c) MICR
(d) Plotter
List II
1. Reads specially printed magnetic-ink characters
2. Detects marked response positions on structured forms
3. Converts printed character images into machine-readable text
4. Produces large technical drawings
Choose the correct matching code.
Explanation:
• OCR recognizes characters from document images, giving (a)-3.
• OMR detects predefined marked positions and MICR reads magnetic-ink characters, giving (b)-2 and (c)-1.
• Plotters are used for large-format technical output, giving (d)-4.
• OMR detects predefined marked positions and MICR reads magnetic-ink characters, giving (b)-2 and (c)-1.
• Plotters are used for large-format technical output, giving (d)-4.
వివరణ:
Question 22
ప్రశ్న 22
Which Access data type is designed to generate a unique sequential or random identifier automatically for new records?
Explanation:
• AutoNumber automatically generates values for new records.
• It is commonly used as a surrogate primary key.
• When another table references an AutoNumber key, the foreign-key field is normally a compatible Number type such as Long Integer.
• It is commonly used as a surrogate primary key.
• When another table references an AutoNumber key, the foreign-key field is normally a compatible Number type such as Long Integer.
వివరణ:
Question 23
ప్రశ్న 23
A process currently executing requests disk input and cannot continue until the operation completes. Which transition normally occurs?
Explanation:
• The process cannot make progress until the requested I/O event finishes.
• The operating system therefore blocks or waits the process and can schedule other ready work.
• After I/O completion, the process normally becomes ready again before executing.
• The operating system therefore blocks or waits the process and can schedule other ready work.
• After I/O completion, the process normally becomes ready again before executing.
వివరణ:
Question 24
ప్రశ్న 24
Several office LANs distributed throughout one city are interconnected. Which classification best fits the overall network?
Explanation:
• MAN stands for Metropolitan Area Network.
• It commonly spans a city or metropolitan region and may interconnect multiple LANs.
• Its typical scope lies between a local LAN and a much broader WAN.
• It commonly spans a city or metropolitan region and may interconnect multiple LANs.
• Its typical scope lies between a local LAN and a much broader WAN.
వివరణ:
Question 25
ప్రశ్న 25
What is the main difference between a transition and an animation in PowerPoint?
Explanation:
• Transitions control how one slide changes to the next during a slide show.
• Animations control the entrance, emphasis, exit or motion of slide objects.
• Using the terms correctly is important when designing presentation effects.
• Animations control the entrance, emphasis, exit or motion of slide objects.
• Using the terms correctly is important when designing presentation effects.
వివరణ:
Question 26
ప్రశ్న 26
Which protocol is primarily used to resolve human-readable domain names to information such as IP addresses?
Explanation:
• DNS is the Domain Name System.
• It provides distributed name-resolution information linking domain names with resource records such as addresses.
• SMTP transfers email and DHCP supplies host configuration.
• It provides distributed name-resolution information linking domain names with resource records such as addresses.
• SMTP transfers email and DHCP supplies host configuration.
వివరణ:
Question 27
ప్రశ్న 27
Which statement best describes the purpose of the CPU Control Unit?
Explanation:
• The Control Unit interprets instruction-related control requirements and coordinates data movement and execution steps.
• It works with registers, the ALU, memory and I/O interfaces during instruction execution.
• Permanent file storage and signal conversion are separate system functions.
• It works with registers, the ALU, memory and I/O interfaces during instruction execution.
• Permanent file storage and signal conversion are separate system functions.
వివరణ:
Question 28
ప్రశ్న 28
In Excel, B2:B7 contain {East,West,East,South,East,West} and C2:C7 contain {65,75,55,80,90,45}. What is returned by =COUNTIFS(B2:B7,"East",C2:C7,">=60")?
Explanation:
• COUNTIFS counts rows that satisfy all specified criteria at the same time.
• The East rows have values 65, 55 and 90; only 65 and 90 are at least 60.
• Therefore exactly 2 rows satisfy both conditions.
• The East rows have values 65, 55 and 90; only 65 and 90 are at least 60.
• Therefore exactly 2 rows satisfy both conditions.
వివరణ:
Question 29
ప్రశ్న 29
Which statement best describes referential integrity?
Explanation:
• Referential integrity keeps relationships between parent and child rows valid.
• A foreign-key value must normally match a referenced key or be Null when the relationship permits it.
• This reduces orphaned or inconsistent relational data.
• A foreign-key value must normally match a referenced key or be Null when the relationship permits it.
• This reduces orphaned or inconsistent relational data.
వివరణ:
Question 30
ప్రశ్న 30
Which memory type is normally programmable once by the user and not intended to be erased and rewritten afterward?
Explanation:
• PROM stands for Programmable Read-Only Memory and is normally programmed once.
• EPROM can be erased using ultraviolet light and reprogrammed.
• EEPROM can be erased electrically, while DRAM is volatile working memory.
• EPROM can be erased using ultraviolet light and reprogrammed.
• EEPROM can be erased electrically, while DRAM is volatile working memory.
వివరణ:
Question 31
ప్రశ్న 31
Which Windows tool is most appropriate for initializing a new disk, creating partitions or volumes and assigning drive letters?
Explanation:
• Disk Management provides graphical administration of disks, partitions and volumes.
• A new disk may need initialization and a formatted volume before it appears as usable storage.
• Task Manager focuses on processes and performance rather than disk partitioning.
• A new disk may need initialization and a formatted volume before it appears as usable storage.
• Task Manager focuses on processes and performance rather than disk partitioning.
వివరణ:
Question 32
ప్రశ్న 32
Which sequence correctly represents a typical Mail Merge workflow?
Explanation:
• The main document contains the common letter or document content.
• A recipient data source supplies variable fields such as names and addresses.
• Previewing before Finish & Merge helps verify personalized output before final generation.
• A recipient data source supplies variable fields such as names and addresses.
• Previewing before Finish & Merge helps verify personalized output before final generation.
వివరణ:
Question 33
ప్రశ్న 33
An antivirus product flags a harmless utility as malware. What is this called?
Explanation:
• A false positive occurs when benign content is incorrectly classified as malicious.
• A false negative is the opposite: malicious content is missed or classified as benign.
• Security tools aim to reduce both types of classification error.
• A false negative is the opposite: malicious content is missed or classified as benign.
• Security tools aim to reduce both types of classification error.
వివరణ:
Question 34
ప్రశ్న 34
Which technology converts printed or scanned text into machine-readable character data?
Explanation:
• OCR analyzes image patterns to identify characters and convert them into editable or searchable text.
• OMR detects marked locations rather than arbitrary text.
• MICR is specialized for magnetically encoded characters.
• OMR detects marked locations rather than arbitrary text.
• MICR is specialized for magnetically encoded characters.
వివరణ:
Question 35
ప్రశ్న 35
Which Access query type retrieves records that meet criteria without changing the stored data?
Explanation:
• Select queries retrieve and display data.
• They can filter, sort, calculate and join data without inherently altering the underlying records.
• Action queries such as Update, Delete and Append modify data.
• They can filter, sort, calculate and join data without inherently altering the underlying records.
• Action queries such as Update, Delete and Append modify data.
వివరణ:
Question 36
ప్రశ్న 36
The scheduler stops process P1, saves its CPU execution state and restores the saved CPU execution state of process P2. What operating-system event has occurred?
Explanation:
• A context switch saves the execution context of one process or thread and restores that of another.
• This allows the processor to stop executing P1 and continue execution of P2.
• Context switching is fundamental to multitasking and scheduling but introduces some processing overhead.
• This allows the processor to stop executing P1 and continue execution of P2.
• Context switching is fundamental to multitasking and scheduling but introduces some processing overhead.
వివరణ:
Question 37
ప్రశ్న 37
An organization interconnects offices in Hyderabad, Delhi and Kolkata. Which network type best describes the overall interconnection?
Explanation:
• WAN stands for Wide Area Network.
• A WAN links networks across large geographic distances such as multiple cities or regions.
• Individual branch offices may each contain their own LAN.
• A WAN links networks across large geographic distances such as multiple cities or regions.
• Individual branch offices may each contain their own LAN.
వివరణ:
Question 38
ప్రశ్న 38
Which view is designed to show the presenter speaker notes, current slide and upcoming-slide information while the audience sees only the slide show?
Explanation:
• Presenter View gives the presenter private delivery information.
• The audience display can remain focused on the full-screen slide show.
• It is useful when speaker notes and timing information are needed during delivery.
• The audience display can remain focused on the full-screen slide show.
• It is useful when speaker notes and timing information are needed during delivery.
వివరణ:
Question 39
ప్రశ్న 39
Which protocol is primarily used for transferring web pages securely between a browser and web server using TLS?
Explanation:
• HTTPS is HTTP carried over a TLS-protected connection.
• TLS provides cryptographic protection such as confidentiality and server authentication when properly configured.
• FTP, SMTP and Telnet serve different application purposes.
• TLS provides cryptographic protection such as confidentiality and server authentication when properly configured.
• FTP, SMTP and Telnet serve different application purposes.
వివరణ:
Question 40
ప్రశ్న 40
A CPU executes 1.8 billion instructions in 3 seconds. What is its average instruction throughput for this workload?
Explanation:
• Average throughput equals completed instructions divided by elapsed time.
• 1.8 billion ÷ 3 = 0.6 billion instructions per second.
• 0.6 billion equals 600 million instructions per second.
• 1.8 billion ÷ 3 = 0.6 billion instructions per second.
• 0.6 billion equals 600 million instructions per second.
వివరణ:
Question 41
ప్రశ్న 41
In Excel, B2:B6 contain {East,West,East,East,West}, C2:C6 contain {Open,Open,Closed,Open,Closed}, and D2:D6 contain {100,200,300,400,500}. What is returned by =SUMIFS(D2:D6,B2:B6,"East",C2:C6,"Open")?
Explanation:
• SUMIFS requires every criterion to be satisfied on the same row.
• East and Open occur for amounts 100 and 400.
• 100+400 = 500.
• East and Open occur for amounts 100 and 400.
• 100+400 = 500.
వివరణ:
Question 42
ప్రశ్న 42
Which relational term refers to one row of a table?
Explanation:
• A tuple is a row in a relation.
• Each tuple contains values corresponding to the relation attributes.
• A domain describes allowed values for an attribute, while degree is the number of attributes.
• Each tuple contains values corresponding to the relation attributes.
• A domain describes allowed values for an attribute, while degree is the number of attributes.
వివరణ:
Question 43
ప్రశ్న 43
Which ROM-family device is traditionally erased using ultraviolet light before being reprogrammed?
Explanation:
• EPROM stands for Erasable Programmable Read-Only Memory.
• Traditional EPROM devices are erased by ultraviolet exposure through an appropriate window/package design.
• EEPROM is electrically erasable rather than UV-erasable.
• Traditional EPROM devices are erased by ultraviolet exposure through an appropriate window/package design.
• EEPROM is electrically erasable rather than UV-erasable.
వివరణ:
Question 44
ప్రశ్న 44
Which Windows tool can create tasks that run automatically at specified times or in response to triggers?
Explanation:
• Task Scheduler runs programs or scripts based on time, event and other triggers.
• It is commonly used for recurring maintenance and automation.
• It is different from Windows Services, which manage long-running service processes.
• It is commonly used for recurring maintenance and automation.
• It is different from Windows Services, which manage long-running service processes.
వివరణ:
Question 45
ప్రశ్న 45
One page in the middle of a Word document must be landscape while surrounding pages remain portrait. What is the best approach?
Explanation:
• Section breaks allow different page-layout settings in different parts of one document.
• The target page can be isolated in its own section and assigned landscape orientation.
• A normal page break changes pagination but does not create independently formatted sections.
• The target page can be isolated in its own section and assigned landscape orientation.
• A normal page break changes pagination but does not create independently formatted sections.
వివరణ:
Question 46
ప్రశ్న 46
Which firewall-policy principle means traffic is blocked unless it is explicitly permitted?
Explanation:
• Default deny starts from a blocked state and adds narrowly defined permissions.
• Traffic without an applicable allow rule remains prohibited.
• This supports least-privilege exposure of network services.
• Traffic without an applicable allow rule remains prohibited.
• This supports least-privilege exposure of network services.
వివరణ:
Question 47
ప్రశ్న 47
Which device is traditionally associated with reading characters printed using magnetic ink on bank cheques?
Explanation:
• MICR stands for Magnetic Ink Character Recognition.
• It is designed for specially shaped characters printed using magnetically detectable ink or toner.
• It has traditionally been used in banking documents such as cheques.
• It is designed for specially shaped characters printed using magnetically detectable ink or toner.
• It has traditionally been used in banking documents such as cheques.
వివరణ:
Question 48
ప్రశ్న 48
Which Access query type asks the user to provide a value each time the query runs and uses that value as a criterion?
Explanation:
• A parameter query obtains a value at run time.
• The supplied value can be used in query criteria or expressions.
• This lets one saved query serve many different user-specified searches.
• The supplied value can be used in query criteria or expressions.
• This lets one saved query serve many different user-specified searches.
వివరణ:
Question 49
ప్రశ్న 49
A running task is interrupted when its time slice expires so that another ready task can execute. Which scheduling model does this illustrate?
Explanation:
• In preemptive scheduling, the operating system can take the CPU away from a running task according to its scheduling policy.
• Expiration of a time slice is a common reason for preemption in time-sharing systems.
• Non-preemptive scheduling does not normally remove the CPU from a running task merely because a time quantum expires.
• Expiration of a time slice is a common reason for preemption in time-sharing systems.
• Non-preemptive scheduling does not normally remove the CPU from a running task merely because a time quantum expires.
వివరణ:
Question 50
ప్రశ్న 50
In a star topology using a central Ethernet switch, what is a key characteristic?
Explanation:
• Star topologies use individual links from endpoints to a central device.
• This isolates most single-cable failures to one endpoint.
• The central switch is a shared dependency for the entire star segment.
• This isolates most single-cable failures to one endpoint.
• The central switch is a shared dependency for the entire star segment.
వివరణ:
Question 51
ప్రశ్న 51
Which print layout places one slide together with its associated speaker notes on a page?
Explanation:
• Notes Pages are designed to print a slide and its notes together.
• This format is useful as a presenter reference or annotated handout.
• Handout layouts instead focus on arranging multiple slide thumbnails on a page.
• This format is useful as a presenter reference or annotated handout.
• Handout layouts instead focus on arranging multiple slide thumbnails on a page.
వివరణ:
Question 52
ప్రశ్న 52
Which protocol is primarily associated with sending email between mail servers?
Explanation:
• SMTP stands for Simple Mail Transfer Protocol.
• It is used for email submission and server-to-server message transfer in typical mail systems.
• DNS resolves names and HTTP transfers web content.
• It is used for email submission and server-to-server message transfer in typical mail systems.
• DNS resolves names and HTTP transfers web content.
వివరణ:
Question 53
ప్రశ్న 53
Which bus primarily carries the address that identifies the memory location or I/O location involved in a transfer?
Explanation:
• The address bus carries location-identifying information from the processor or bus master.
• The data bus carries the actual data values being transferred.
• The control bus carries signals such as read, write and interrupt-related control information.
• The data bus carries the actual data values being transferred.
• The control bus carries signals such as read, write and interrupt-related control information.
వివరణ:
Question 54
ప్రశ్న 54
In Excel, B2 contains 70 and C2 contains 65. What is returned by =IF(AND(B2>=60,C2>=60),"PASS","FAIL")?
Explanation:
• Both comparisons B2>=60 and C2>=60 are TRUE.
• AND therefore evaluates to TRUE.
• The IF function returns the first text result, PASS.
• AND therefore evaluates to TRUE.
• The IF function returns the first text result, PASS.
వివరణ:
Question 55
ప్రశ్న 55
A relation contains 850 rows and 12 columns. What are its cardinality and degree?
Explanation:
• Cardinality is the number of tuples or rows in a relation.
• Degree is the number of attributes or columns.
• Therefore this relation has cardinality 850 and degree 12.
• Degree is the number of attributes or columns.
• Therefore this relation has cardinality 850 and degree 12.
వివరణ:
Question 56
ప్రశ్న 56
Which memory technology can be electrically erased and reprogrammed without ultraviolet light?
Explanation:
• EEPROM is Electrically Erasable Programmable Read-Only Memory.
• Its contents can be erased and rewritten electrically.
• PROM is normally one-time programmable, while traditional EPROM uses ultraviolet erasure.
• Its contents can be erased and rewritten electrically.
• PROM is normally one-time programmable, while traditional EPROM uses ultraviolet erasure.
వివరణ:
Question 57
ప్రశ్న 57
Which console opened by services.msc is used to inspect, start, stop and configure Windows services?
Explanation:
• services.msc opens the Services management console.
• It exposes service status and startup configuration and can show service dependencies.
• This is useful when a background service fails to start or must be restarted.
• It exposes service status and startup configuration and can show service dependencies.
• This is useful when a background service fails to start or must be restarted.
వివరణ:
Question 58
ప్రశ్న 58
What is the main difference between a page break and a section break in Word?
Explanation:
• A page break primarily controls where the next page starts.
• A section break divides the document into independently configurable sections.
• Section-level settings can include orientation, margins, columns, headers, footers and page numbering.
• A section break divides the document into independently configurable sections.
• Section-level settings can include orientation, margins, columns, headers, footers and page numbering.
వివరణ:
Question 59
ప్రశ్న 59
Match the security mechanism with its main characteristic:
(a) Stateless packet filter
(b) Stateful firewall
(c) Application-proxy gateway
(d) VPN
1. Maintains active-connection state
2. Creates a protected virtual communication path
3. Applies header-based rules without equivalent per-connection state
4. Acts as an application-aware intermediary
Choose the correct matching code.
(a) Stateless packet filter
(b) Stateful firewall
(c) Application-proxy gateway
(d) VPN
1. Maintains active-connection state
2. Creates a protected virtual communication path
3. Applies header-based rules without equivalent per-connection state
4. Acts as an application-aware intermediary
Choose the correct matching code.
Explanation:
• A stateless filter evaluates packets without maintaining equivalent connection state, giving (a)-3.
• A stateful firewall tracks connections and an application proxy mediates application communication, giving (b)-1 and (c)-4.
• A VPN creates the protected virtual path, giving (d)-2.
• A stateful firewall tracks connections and an application proxy mediates application communication, giving (b)-1 and (c)-4.
• A VPN creates the protected virtual path, giving (d)-2.
వివరణ:
Question 60
ప్రశ్న 60
In a laser printer, which component permanently bonds toner to paper using heat and pressure?
Explanation:
• The fuser applies heat and pressure after toner has been transferred to paper.
• This melts and bonds toner particles to the paper fibers.
• Inkjet nozzles belong to a different printing technology.
• This melts and bonds toner particles to the paper fibers.
• Inkjet nozzles belong to a different printing technology.
వివరణ:
Question 61
ప్రశ్న 61
Which Access query type summarizes aggregate values using row headings and column headings?
Explanation:
• Crosstab queries present aggregate data in a matrix.
• One set of fields provides row headings and another provides column headings.
• The intersections display aggregate values such as Sum or Count.
• One set of fields provides row headings and another provides column headings.
• The intersections display aggregate values such as Sum or Count.
వివరణ:
Question 62
ప్రశ్న 62
Which statement best describes virtual memory?
Explanation:
• Virtual memory separates a process address space from the exact placement of data in physical RAM.
• Paging allows portions of address spaces to be moved between RAM and backing storage as necessary.
• This provides protection and flexibility but excessive paging can reduce performance.
• Paging allows portions of address spaces to be moved between RAM and backing storage as necessary.
• This provides protection and flexibility but excessive paging can reduce performance.
వివరణ:
Question 63
ప్రశ్న 63
Nine network nodes are connected in a full mesh, with one direct point-to-point link between every pair of nodes. How many links are required?
Explanation:
• A full mesh of n nodes requires n(n−1)/2 unique point-to-point links.
• For 9 nodes, 9×8÷2 = 36.
• The division by 2 prevents each pair of nodes from being counted twice.
• For 9 nodes, 9×8÷2 = 36.
• The division by 2 prevents each pair of nodes from being counted twice.
వివరణ:
Question 64
ప్రశ్న 64
A presentation has 80 slides but one audience should see only five selected slides in a special order. Which feature should be used?
Explanation:
• A Custom Slide Show defines a subset and sequence of slides without deleting the others.
• Different custom shows can be created for different audiences.
• The original full presentation remains intact.
• Different custom shows can be created for different audiences.
• The original full presentation remains intact.
వివరణ:
Question 65
ప్రశ్న 65
An internal employee portal uses HTTPS but is accessible only to authorized staff. How should it best be classified?
Explanation:
• An intranet service is intended for a restricted organizational community.
• Using HTTPS and web browsers does not make a service public.
• The classification depends on access scope and organizational purpose rather than the web technology used.
• Using HTTPS and web browsers does not make a service public.
• The classification depends on access scope and organizational purpose rather than the web technology used.
వివరణ:
Question 66
ప్రశ్న 66
Which statement correctly compares the data bus and address bus?
Explanation:
• The data bus transports the actual binary data being exchanged.
• The address bus identifies which memory or I/O location is being referenced.
• Their widths influence different system capabilities, such as transfer width and addressable space.
• The address bus identifies which memory or I/O location is being referenced.
• Their widths influence different system capabilities, such as transfer width and addressable space.
వివరణ:
Question 67
ప్రశ్న 67
In Excel, A1 contains 40 and B1 contains the text "Yes". What is returned by =IF(OR(A1>50,B1="Yes"),"CHECK","OK")?
Explanation:
• A1>50 is FALSE because 40 is not greater than 50.
• B1="Yes" is TRUE, so OR(FALSE,TRUE) evaluates to TRUE.
• IF therefore returns the TRUE-result text "CHECK".
• B1="Yes" is TRUE, so OR(FALSE,TRUE) evaluates to TRUE.
• IF therefore returns the TRUE-result text "CHECK".
వివరణ:
Question 68
ప్రశ్న 68
Which normalization problem is specifically addressed by Second Normal Form when a table has a composite key?
Explanation:
• Second Normal Form requires First Normal Form and removes partial dependencies on a proper subset of a candidate key.
• This issue arises especially when a key contains more than one attribute.
• Third Normal Form deals with transitive dependency among non-key attributes.
• This issue arises especially when a key contains more than one attribute.
• Third Normal Form deals with transitive dependency among non-key attributes.
వివరణ:
Question 69
ప్రశ్న 69
A cache has a 95% hit rate, a 2 ns hit time and a 60 ns miss penalty beyond the cache lookup. What is the average memory access time under these stated assumptions?
Explanation:
• AMAT = hit time + miss rate × miss penalty under the assumptions stated.
• The miss rate is 1−0.95 = 0.05.
• 2 ns + 0.05×60 ns = 2+3 = 5 ns.
• The miss rate is 1−0.95 = 0.05.
• 2 ns + 0.05×60 ns = 2+3 = 5 ns.
వివరణ:
Question 70
ప్రశ్న 70
What is the purpose of User Account Control (UAC)?
Explanation:
• UAC separates standard user activity from actions requiring elevated administrative rights.
• Elevation requests can require consent or administrator credentials depending on account and policy.
• It supports least-privilege operation but does not itself replace authentication or file permissions.
• Elevation requests can require consent or administrator credentials depending on account and policy.
• It supports least-privilege operation but does not itself replace authentication or file permissions.
వివరణ:
Question 71
ప్రశ్న 71
Which Word feature records insertions, deletions and formatting changes so reviewers can accept or reject them later?
Explanation:
• Track Changes records edits as revisions.
• Reviewers can inspect changes and accept or reject them individually or collectively.
• It is designed for collaborative editing and review rather than personalized document generation.
• Reviewers can inspect changes and accept or reject them individually or collectively.
• It is designed for collaborative editing and review rather than personalized document generation.
వివరణ:
Question 72
ప్రశ్న 72
Which statement correctly describes stateful firewall inspection?
Explanation:
• Stateful inspection records connection context for allowed communications.
• Return traffic can be evaluated as part of an established session rather than as a completely unrelated packet.
• This is a key difference from basic stateless filtering.
• Return traffic can be evaluated as part of an established session rather than as a completely unrelated packet.
• This is a key difference from basic stateless filtering.
వివరణ:
Question 73
ప్రశ్న 73
Which printer type creates output by spraying microscopic droplets of liquid ink through nozzles onto paper?
Explanation:
• Inkjet printers eject tiny droplets of liquid ink through print-head nozzles.
• Laser printers instead use electro-photographic toner processes.
• Dot-matrix printers form characters mechanically using impact pins and ribbons.
• Laser printers instead use electro-photographic toner processes.
• Dot-matrix printers form characters mechanically using impact pins and ribbons.
వివరణ:
Question 74
ప్రశ్న 74
Which Access query type modifies field values in existing records that satisfy specified criteria?
Explanation:
• An Update query changes values in qualifying existing records.
• Because many rows can be modified at once, criteria should be verified before execution.
• A backup is prudent before large action queries.
• Because many rows can be modified at once, criteria should be verified before execution.
• A backup is prudent before large action queries.
వివరణ:
Question 75
ప్రశ్న 75
What is a page fault?
Explanation:
• A page fault causes control to transfer to the operating system memory manager.
• The OS may load a nonresident page, establish a mapping or terminate the process if the access is invalid.
• Page faults are part of normal virtual-memory operation, though excessive faults can hurt performance.
• The OS may load a nonresident page, establish a mapping or terminate the process if the access is invalid.
• Page faults are part of normal virtual-memory operation, though excessive faults can hurt performance.
వివరణ:
Question 76
ప్రశ్న 76
Twenty PCs in one office are connected to a central Ethernet device that learns source MAC addresses and selectively forwards frames. Which device is this?
Explanation:
• Ethernet switches learn source MAC addresses and build forwarding tables.
• They use those tables to send frames toward the appropriate port when possible.
• Routers forward packets between IP networks rather than performing the same Layer-2 function.
• They use those tables to send frames toward the appropriate port when possible.
• Routers forward packets between IP networks rather than performing the same Layer-2 function.
వివరణ:
Question 77
ప్రశ్న 77
Which feature can record narration and slide timings for a self-running presentation?
Explanation:
• Record Slide Show captures narration and timing information associated with presenting the slides.
• The recording can support unattended or rehearsed playback.
• Reuse Slides is used to import slides from another presentation.
• The recording can support unattended or rehearsed playback.
• Reuse Slides is used to import slides from another presentation.
వివరణ:
Question 78
ప్రశ్న 78
A workstation can access a web server by numerical IP address but not by its domain name. Which service should be investigated first?
Explanation:
• Successful access by IP indicates that basic IP connectivity to the server exists.
• Failure specifically when a name is used points to name resolution.
• DNS configuration, cache and server availability should therefore be checked before unrelated hardware.
• Failure specifically when a name is used points to name resolution.
• DNS configuration, cache and server availability should therefore be checked before unrelated hardware.
వివరణ:
Question 79
ప్రశ్న 79
A processor has a 24-bit address bus and uses byte-addressable memory. What is the maximum directly addressable byte space?
Explanation:
• A 24-bit address bus can represent 2^24 distinct addresses.
• With byte addressing, 2^24 addresses correspond to 2^24 bytes.
• 2^24 bytes equals 16 MiB.
• With byte addressing, 2^24 addresses correspond to 2^24 bytes.
• 2^24 bytes equals 16 MiB.
వివరణ:
Question 80
ప్రశ్న 80
Cell E2 contains =$B2*C$1. The formula is copied to G5. What formula appears in G5?
Explanation:
• The move from E2 to G5 is two columns right and three rows down.
• $B2 keeps column B fixed but changes row 2 to row 5.
• C$1 keeps row 1 fixed while relative column C moves to E.
• $B2 keeps column B fixed but changes row 2 to row 5.
• C$1 keeps row 1 fixed while relative column C moves to E.
వివరణ:
Question 81
ప్రశ్న 81
Which problem is primarily removed when a table is brought from Second Normal Form to Third Normal Form?
Explanation:
• Third Normal Form 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 without eliminating legitimate keys or indexes.
• A non-key attribute should depend on the key rather than indirectly through another non-key attribute.
• This reduces redundancy and update anomalies without eliminating legitimate keys or indexes.
వివరణ:
Question 82
ప్రశ్న 82
What is a cache hit?
Explanation:
• A hit means the requested block is already present in the cache level being accessed.
• The processor can use the cached copy without obtaining that item from a slower level for that request.
• A cache miss is the opposite condition.
• The processor can use the cached copy without obtaining that item from a slower level for that request.
• A cache miss is the opposite condition.
వివరణ:
Question 83
ప్రశ్న 83
Which statement about a standard Windows user account is generally correct?
Explanation:
• Standard accounts are intended for everyday operation with limited system-wide administrative rights.
• Administrative tasks can require elevation or administrator credentials.
• This reduces the impact of accidental or malicious changes.
• Administrative tasks can require elevation or administrator credentials.
• This reduces the impact of accidental or malicious changes.
వివరణ:
Question 84
ప్రశ్న 84
A heading in Word should remain on the same page as the paragraph immediately following it whenever possible. Which paragraph-formatting option is designed for this purpose?
Explanation:
• Keep with next keeps the selected paragraph together with the paragraph that follows it when pagination is calculated.
• It is commonly applied to headings so they are not left alone at the bottom of a page.
• Widow/Orphan control manages isolated lines within a paragraph rather than binding a heading to the next paragraph.
• It is commonly applied to headings so they are not left alone at the bottom of a page.
• Widow/Orphan control manages isolated lines within a paragraph rather than binding a heading to the next paragraph.
వివరణ:
Question 85
ప్రశ్న 85
Which statement best describes an application-proxy gateway?
Explanation:
• An application proxy terminates or mediates application communications rather than simply forwarding packets unchanged.
• It can apply application-aware policy based on the protocol it understands.
• This deeper processing can provide more control but may add overhead and require protocol-specific support.
• It can apply application-aware policy based on the protocol it understands.
• This deeper processing can provide more control but may add overhead and require protocol-specific support.
వివరణ:
Question 86
ప్రశ్న 86
Which printer is an impact printer that forms characters and graphics by striking pins against an inked ribbon?
Explanation:
• Dot-matrix printers use a print head containing pins that strike an inked ribbon.
• They are impact printers and can be useful where multipart forms are required.
• Laser and inkjet printers are non-impact technologies.
• They are impact printers and can be useful where multipart forms are required.
• Laser and inkjet printers are non-impact technologies.
వివరణ:
Question 87
ప్రశ్న 87
Which Access query type adds records from one source to the end of an existing table?
Explanation:
• Append queries insert records into an existing destination table.
• They are useful for importing or consolidating data.
• They differ from Update queries, which modify existing rows.
• They are useful for importing or consolidating data.
• They differ from Update queries, which modify existing rows.
వివరణ:
Question 88
ప్రశ్న 88
What does thrashing describe in a virtual-memory system?
Explanation:
• Thrashing occurs when page faults and page replacement dominate useful execution.
• It often results from insufficient physical memory for the active processes working sets.
• Performance can collapse because the system performs far more paging than productive work.
• It often results from insufficient physical memory for the active processes working sets.
• Performance can collapse because the system performs far more paging than productive work.
వివరణ:
Question 89
ప్రశ్న 89
Which device primarily forwards IP packets between different IP networks?
Explanation:
• Routers examine network-layer addressing and routing information.
• They forward packets between separate IP networks according to routing tables.
• Switches mainly forward frames inside a Layer-2 LAN.
• They forward packets between separate IP networks according to routing tables.
• Switches mainly forward frames inside a Layer-2 LAN.
వివరణ:
Question 90
ప్రశ్న 90
Which feature is intended to import selected slides from another presentation into the current one?
Explanation:
• Reuse Slides allows existing slides from another PowerPoint file to be inserted.
• Depending on options, the original source formatting can be retained or adapted.
• Goal Seek and Mail Merge belong to other Office applications.
• Depending on options, the original source formatting can be retained or adapted.
• Goal Seek and Mail Merge belong to other Office applications.
వివరణ:
Question 91
ప్రశ్న 91
Which mechanism allows an I/O controller to transfer blocks of data between an I/O device and main memory with minimal CPU intervention after setup?
Explanation:
• DMA allows a controller to transfer data directly between an I/O device and main memory.
• The CPU normally initializes the transfer and is notified when appropriate rather than moving each data item itself.
• Polling requires repeated CPU checking and is conceptually different from DMA.
• The CPU normally initializes the transfer and is notified when appropriate rather than moving each data item itself.
• Polling requires repeated CPU checking and is conceptually different from DMA.
వివరణ:
Question 92
ప్రశ్న 92
Which Excel reference keeps both column F and row 4 fixed when a formula is copied?
Explanation:
• A dollar sign before the column fixes the column.
• A dollar sign before the row fixes the row.
• $F$4 therefore remains unchanged when copied in either direction.
• A dollar sign before the row fixes the row.
• $F$4 therefore remains unchanged when copied in either direction.
వివరణ:
Question 93
ప్రశ్న 93
Which ACID property requires a transaction to be all-or-nothing?
Explanation:
• Atomicity treats the transaction as one indivisible logical unit.
• If part of the transaction fails, its incomplete changes should not remain committed.
• Consistency, isolation and durability describe different transaction guarantees.
• If part of the transaction fails, its incomplete changes should not remain committed.
• Consistency, isolation and durability describe different transaction guarantees.
వివరణ:
Question 94
ప్రశ్న 94
Which concept explains why recently accessed memory locations are likely to be accessed again soon?
Explanation:
• Temporal locality refers to reuse of the same data or instructions within a relatively short time.
• Caches exploit this behavior by retaining recently used blocks.
• Spatial locality instead concerns access to nearby memory locations.
• Caches exploit this behavior by retaining recently used blocks.
• Spatial locality instead concerns access to nearby memory locations.
వివరణ:
Question 95
ప్రశ్న 95
A Windows computer has corrupted protected system files, and Microsoft repair guidance calls for repairing the component store first. Which command should normally be run before sfc /scannow?
Explanation:
• DISM /RestoreHealth can repair corruption in the Windows component store used as a repair source.
• System File Checker can then scan protected system files and replace damaged versions.
• Formatting the system drive is destructive and not an ordinary first-line repair step.
• System File Checker can then scan protected system files and replace damaged versions.
• Formatting the system drive is destructive and not an ordinary first-line repair step.
వివరణ:
Question 96
ప్రశ్న 96
Which option lets the first page of a section use a header or footer different from later pages?
Explanation:
• Different First Page creates a separate first-page header/footer for the section.
• It is useful for title pages and chapter openings.
• Paragraph pagination controls do not provide this header/footer distinction.
• It is useful for title pages and chapter openings.
• Paragraph pagination controls do not provide this header/footer distinction.
వివరణ:
Question 97
ప్రశ్న 97
A password and a PIN are both used during sign-in. Why does this not necessarily constitute multi-factor authentication?
Explanation:
• Authentication factors are categorized by what the user knows, has or is.
• Passwords and PINs are both examples of knowledge factors.
• True MFA requires independently verified factors from different categories.
• Passwords and PINs are both examples of knowledge factors.
• True MFA requires independently verified factors from different categories.
వివరణ:
Question 98
ప్రశ్న 98
What does monitor refresh rate, expressed in hertz, primarily indicate?
Explanation:
• Refresh rate measures display updates per second and is expressed in hertz.
• A 60 Hz display refreshes up to 60 times per second under the relevant operating conditions.
• It is different from resolution, which describes pixel dimensions.
• A 60 Hz display refreshes up to 60 times per second under the relevant operating conditions.
• It is different from resolution, which describes pixel dimensions.
వివరణ:
Question 99
ప్రశ్న 99
Which Access query type permanently removes qualifying records from a table?
Explanation:
• Delete queries remove records satisfying the query criteria.
• They can affect many rows, so backups and verification are important.
• Ordinary Select queries only retrieve data.
• They can affect many rows, so backups and verification are important.
• Ordinary Select queries only retrieve data.
వివరణ:
Question 100
ప్రశ్న 100
The same executable file is launched twice and each running instance has its own execution state. Which statement best explains this situation?
Explanation:
• Executable program code stored on disk is passive until started.
• When run, it becomes part of a process that has state such as registers, memory mappings and operating-system resources.
• Multiple processes can execute instances of the same program independently.
• When run, it becomes part of a process that has state such as registers, memory mappings and operating-system resources.
• Multiple processes can execute instances of the same program independently.
వివరణ:
Question 101
ప్రశ్న 101
A Windows host automatically receives an IPv4 address in 169.254.0.0/16 when normal address assignment fails. What does this usually indicate?
Explanation:
• Windows can self-assign an IPv4 link-local address in the 169.254.0.0/16 range.
• This commonly occurs when DHCP configuration cannot be obtained.
• The symptom should prompt investigation of DHCP availability and local network connectivity.
• This commonly occurs when DHCP configuration cannot be obtained.
• The symptom should prompt investigation of DHCP availability and local network connectivity.
వివరణ:
Question 102
ప్రశ్న 102
A presentation containing embedded audio and video has become very large. Which PowerPoint operation can reduce supported media size?
Explanation:
• Compress Media reduces the size of supported embedded audio and video content.
• Compression can trade some quality for smaller presentation size.
• It does not change the conceptual slide order or master design.
• Compression can trade some quality for smaller presentation size.
• It does not change the conceptual slide order or master design.
వివరణ:
Question 103
ప్రశ్న 103
A device needs immediate CPU attention and signals the processor so normal execution can be temporarily suspended. Which mechanism is being used?
Explanation:
• An interrupt requests processor attention for an event requiring service.
• The CPU can save its execution context, run an interrupt service routine and later resume the interrupted work.
• This avoids requiring the processor to continuously poll every device for events.
• The CPU can save its execution context, run an interrupt service routine and later resume the interrupted work.
• This avoids requiring the processor to continuously poll every device for events.
వివరణ:
Question 104
ప్రశ్న 104
What is returned by =ROUND(18.746,2)?
Explanation:
• ROUND keeps two digits after the decimal point.
• The third decimal digit is 6, so the second decimal digit is rounded upward.
• 18.746 therefore becomes 18.75.
• The third decimal digit is 6, so the second decimal digit is rounded upward.
• 18.746 therefore becomes 18.75.
వివరణ:
Question 105
ప్రశ్న 105
Which ACID property requires committed transaction changes to survive subsequent system failure and recovery?
Explanation:
• Durability applies after a transaction has committed successfully.
• The DBMS uses recovery mechanisms such as logging and stable storage to preserve committed effects.
• Atomicity concerns all-or-nothing completion rather than persistence after commit.
• The DBMS uses recovery mechanisms such as logging and stable storage to preserve committed effects.
• Atomicity concerns all-or-nothing completion rather than persistence after commit.
వివరణ:
Question 106
ప్రశ్న 106
Which concept describes the tendency of programs to access memory locations near locations accessed recently?
Explanation:
• Spatial locality concerns access to addresses near recently referenced addresses.
• Caches often fetch data in blocks or lines to exploit this tendency.
• Temporal locality refers to repeated access to the same items over time.
• Caches often fetch data in blocks or lines to exploit this tendency.
• Temporal locality refers to repeated access to the same items over time.
వివరణ:
Question 107
ప్రశ్న 107
Which command scans protected Windows system files and attempts to repair corrupted versions?
Explanation:
• System File Checker verifies protected Windows system files.
• The /scannow option requests an immediate full scan of protected system files.
• Network path tracing and directory listing do not perform system-file integrity repair.
• The /scannow option requests an immediate full scan of protected system files.
• Network path tracing and directory listing do not perform system-file integrity repair.
వివరణ:
Question 108
ప్రశ్న 108
Which option allows separate odd-page and even-page headers within a section?
Explanation:
• Different Odd & Even Pages supports book-style and duplex layouts with alternating headers or footers.
• Odd and even pages can contain different content while remaining in the same section.
• Different First Page affects only the first page.
• Odd and even pages can contain different content while remaining in the same section.
• Different First Page affects only the first page.
వివరణ:
Question 109
ప్రశ్న 109
A user signs in with a password and then a fingerprint. Which security concept is demonstrated?
Explanation:
• A password is something the user knows.
• A fingerprint is an inherence/biometric factor representing something the user is.
• Using independently verified factors from different categories constitutes MFA.
• A fingerprint is an inherence/biometric factor representing something the user is.
• Using independently verified factors from different categories constitutes MFA.
వివరణ:
Question 110
ప్రశ్న 110
A monitor is operating at a resolution of 1920 × 1080. What does this notation describe?
Explanation:
• Display resolution states the pixel dimensions of the selected display mode.
• 1920 × 1080 means 1920 addressable pixel positions horizontally and 1080 vertically.
• Refresh rate is measured separately in hertz and is not specified by the resolution figures.
• 1920 × 1080 means 1920 addressable pixel positions horizontally and 1080 vertically.
• Refresh rate is measured separately in hertz and is not specified by the resolution figures.
వివరణ:
Question 111
ప్రశ్న 111
Which Access object is generally best for creating a user-friendly interface for entering and editing one record at a time?
Explanation:
• Forms provide controlled interfaces for viewing and editing database records.
• Controls can be bound to fields from tables or queries.
• Reports are designed mainly for formatted output rather than routine data entry.
• Controls can be bound to fields from tables or queries.
• Reports are designed mainly for formatted output rather than routine data entry.
వివరణ:
Question 112
ప్రశ్న 112
Which statement correctly compares processes and threads?
Explanation:
• Threads are execution units scheduled within a process.
• Threads of the same process commonly share code, data and open resources while having their own stack and register state.
• This sharing makes thread communication cheaper but also requires synchronization for shared data.
• Threads of the same process commonly share code, data and open resources while having their own stack and register state.
• This sharing makes thread communication cheaper but also requires synchronization for shared data.
వివరణ:
Question 113
ప్రశ్న 113
Which protocol normally supplies automatic IPv4 configuration such as an address, subnet mask and default gateway to a client?
Explanation:
• DHCP provides dynamic host configuration information.
• Options can include an IPv4 address, subnet mask, default gateway and DNS-server information.
• DNS resolves names while SMTP and FTP serve different application functions.
• Options can include an IPv4 address, subnet mask, default gateway and DNS-server information.
• DNS resolves names while SMTP and FTP serve different application functions.
వివరణ:
Question 114
ప్రశ్న 114
Which feature helps organize a large presentation into named groups of slides without creating separate files?
Explanation:
• PowerPoint Sections divide a presentation into logical groups.
• Sections can be named, moved, collapsed and managed as units in the presentation.
• They improve organization without changing the individual slide content.
• Sections can be named, moved, collapsed and managed as units in the presentation.
• They improve organization without changing the individual slide content.
వివరణ:
Question 115
ప్రశ్న 115
Which statement correctly distinguishes interrupt-driven I/O from polling?
Explanation:
• Polling consumes processor effort by repeatedly testing status even when no event has occurred.
• Interrupts allow the CPU to perform other work until a device requests attention.
• Actual systems may combine polling, interrupts and DMA depending on device and workload.
• Interrupts allow the CPU to perform other work until a device requests attention.
• Actual systems may combine polling, interrupts and DMA depending on device and workload.
వివరణ:
Question 116
ప్రశ్న 116
What is returned by =MOD(37,8)?
Explanation:
• MOD returns the remainder after division.
• 37 = 8×4 + 5.
• The remainder is therefore 5.
• 37 = 8×4 + 5.
• The remainder is therefore 5.
వివరణ:
Question 117
ప్రశ్న 117
T1 updates a value but does not commit. T2 reads that temporary value. What concurrency anomaly has occurred?
Explanation:
• A dirty read occurs when a transaction observes data written by another transaction that has not committed.
• If the writer rolls back, the reader has used a value that never became committed data.
• Stronger isolation levels can prevent dirty reads.
• If the writer rolls back, the reader has used a value that never became committed data.
• Stronger isolation levels can prevent dirty reads.
వివరణ:
Question 118
ప్రశ్న 118
Using binary units, how many MiB are in 5.5 GiB?
Explanation:
• One GiB equals 1024 MiB under the binary-unit convention.
• 5.5×1024 = 5632.
• Therefore 5.5 GiB equals 5632 MiB.
• 5.5×1024 = 5632.
• Therefore 5.5 GiB equals 5632 MiB.
వివరణ:
Question 119
ప్రశ్న 119
Which Windows Recovery Environment option is intended to diagnose and repair certain problems that prevent Windows from starting?
Explanation:
• Startup Repair is available from Windows Recovery Environment advanced options.
• It targets boot-related problems that can prevent Windows from loading normally.
• It is different from System Restore, which rolls back system state to a restore point.
• It targets boot-related problems that can prevent Windows from loading normally.
• It is different from System Restore, which rolls back system state to a restore point.
వివరణ:
Question 120
ప్రశ్న 120
Which feature is best for replacing every occurrence of a phrase and can also search for specified formatting?
Explanation:
• Find and Replace can locate repeated text and substitute another value.
• Advanced options can include formatting conditions in the search and replacement.
• This is more efficient than editing many repeated occurrences manually.
• Advanced options can include formatting conditions in the search and replacement.
• This is more efficient than editing many repeated occurrences manually.
వివరణ:
Question 121
ప్రశ్న 121
Which statement correctly distinguishes symmetric and asymmetric cryptography?
Explanation:
• Symmetric algorithms use secret key material shared by the communicating parties.
• Asymmetric systems use mathematically related public and private keys for complementary operations.
• Real protocols often combine both techniques for efficiency and key establishment.
• Asymmetric systems use mathematically related public and private keys for complementary operations.
• Real protocols often combine both techniques for efficiency and key establishment.
వివరణ:
Question 122
ప్రశ్న 122
Which peripheral is primarily used to capture live video images for a computer?
Explanation:
• A webcam or digital camera converts optical scenes into digital image/video data.
• It functions as an input device for video conferencing and image capture.
• UPS and printer components do not perform image acquisition.
• It functions as an input device for video conferencing and image capture.
• UPS and printer components do not perform image acquisition.
వివరణ:
Question 123
ప్రశ్న 123
A main form shows one Case and must display all related EvidenceItems. Which design is most appropriate?
Explanation:
• A main form/subform design is ideal for displaying a one-to-many relationship.
• The parent form can show one case while the subform shows matching child records.
• Link Master Fields and Link Child Fields can synchronize the records by CaseID.
• The parent form can show one case while the subform shows matching child records.
• Link Master Fields and Link Child Fields can synchronize the records by CaseID.
వివరణ:
Question 124
ప్రశ్న 124
A user submits several print jobs rapidly, and the operating system queues them in intermediate storage while the printer processes them one at a time. Which technique is illustrated?
Explanation:
• Spooling places jobs for a slower shared peripheral into a queue in intermediate storage.
• The printer can then process queued jobs sequentially while applications continue working.
• Paging concerns virtual memory, while polling repeatedly checks device status rather than maintaining a print-job queue.
• The printer can then process queued jobs sequentially while applications continue working.
• Paging concerns virtual memory, while polling repeatedly checks device status rather than maintaining a print-job queue.
వివరణ:
Question 125
ప్రశ్న 125
Host A is 192.168.25.10/24 and Host B is 192.168.25.200/24. Assuming valid configuration, which statement is correct?
Explanation:
• A /24 prefix fixes the first 24 bits as the network portion.
• Both addresses therefore belong to 192.168.25.0/24.
• Local-subnet traffic is delivered through the LAN rather than routed through the default gateway.
• Both addresses therefore belong to 192.168.25.0/24.
• Local-subnet traffic is delivered through the LAN rather than routed through the default gateway.
వివరణ:
Question 126
ప్రశ్న 126
Which pane provides detailed control over the order and timing of animation effects applied to slide objects?
Explanation:
• The Animation Pane lists animation effects associated with slide objects.
• It supports reordering, timing and effect management.
• The Navigation Pane is a Word feature and the Formula Bar is associated with Excel.
• It supports reordering, timing and effect management.
• The Navigation Pane is a Word feature and the Formula Bar is associated with Excel.
వివరణ:
Question 127
ప్రశ్న 127
Which motherboard connector normally carries the main power from a modern ATX desktop power supply to the motherboard?
Explanation:
• The 24-pin ATX connector supplies the motherboard with its principal regulated power rails.
• A separate CPU power connector is also commonly required near the processor socket.
• RJ45, SATA data and PCIe x16 are used for networking, storage data and expansion respectively.
• A separate CPU power connector is also commonly required near the processor socket.
• RJ45, SATA data and PCIe x16 are used for networking, storage data and expansion respectively.
వివరణ:
Question 128
ప్రశ్న 128
Which Excel feature is most appropriate for restricting a Status cell to a drop-down list containing Open, Pending and Closed?
Explanation:
• Data Validation can limit entries to a predefined list.
• Users can select from the drop-down instead of typing arbitrary status values.
• This improves consistency in structured data-entry worksheets.
• Users can select from the drop-down instead of typing arbitrary status values.
• This improves consistency in structured data-entry worksheets.
వివరణ:
Question 129
ప్రశ్న 129
A transaction reads the same row twice and obtains different committed values because another transaction updated the row between the reads. What is this called?
Explanation:
• A non-repeatable read occurs when a previously read row changes before the transaction reads it again.
• The second read returns a different committed value for the same row.
• A phantom concerns a changing set of rows satisfying a query rather than merely a changed value in the same row.
• The second read returns a different committed value for the same row.
• A phantom concerns a changing set of rows satisfying a query rather than merely a changed value in the same row.
వివరణ:
Question 130
ప్రశ్న 130
Five 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)×drive capacity.
• For five 3 TB drives, (5−1)×3 TB = 12 TB.
• The equivalent capacity of one drive is consumed by distributed parity.
• For five 3 TB drives, (5−1)×3 TB = 12 TB.
• The equivalent capacity of one drive is consumed by distributed parity.
వివరణ:
Question 131
ప్రశ్న 131
Which statement best describes Safe Mode?
Explanation:
• Safe Mode intentionally loads a reduced driver and service set.
• If a problem disappears in Safe Mode, the cause may involve drivers, services or startup software not loaded there.
• It is a diagnostic startup environment rather than a normal operating mode.
• If a problem disappears in Safe Mode, the cause may involve drivers, services or startup software not loaded there.
• It is a diagnostic startup environment rather than a normal operating mode.
వివరణ:
Question 132
ప్రశ్న 132
Which feature limits what types of editing users may perform in a Word document?
Explanation:
• Restrict Editing can limit changes or permit only specified forms of editing.
• It can be combined with exceptions and protection settings depending on the document.
• It is not the same as encryption or operating-system file permissions.
• It can be combined with exceptions and protection settings depending on the document.
• It is not the same as encryption or operating-system file permissions.
వివరణ:
Question 133
ప్రశ్న 133
In a standard public-key digital-signature system, which key is normally used by a recipient or verifier to validate the signer's signature?
Explanation:
• The signer creates the signature with the private key, while verification uses the corresponding public key.
• A verifier does not need the signer’s private key to validate a standard public-key signature.
• Digital signatures primarily support integrity and authentication rather than confidentiality by themselves.
• A verifier does not need the signer’s private key to validate a standard public-key signature.
• Digital signatures primarily support integrity and authentication rather than confidentiality by themselves.
వివరణ:
Question 134
ప్రశ్న 134
Which hardware converts digital audio samples into analog signals suitable for speakers or headphones and can also digitize microphone input?
Explanation:
• Audio interfaces contain digital-to-analog and analog-to-digital conversion circuitry as appropriate.
• They connect computer audio streams to speakers, headphones, microphones and other audio equipment.
• Network and cooling hardware perform unrelated functions.
• They connect computer audio streams to speakers, headphones, microphones and other audio equipment.
• Network and cooling hardware perform unrelated functions.
వివరణ:
Question 135
ప్రశ్న 135
Which Access object is intended primarily for formatted, grouped and printable presentation of database data?
Explanation:
• Reports format database information for viewing, printing or export.
• They support grouping, sorting, headers, footers and calculated controls.
• Tables store the underlying data rather than providing polished output.
• They support grouping, sorting, headers, footers and calculated controls.
• Tables store the underlying data rather than providing polished output.
వివరణ:
Question 136
ప్రశ్న 136
What is the main purpose of a device driver?
Explanation:
• Drivers translate operating-system requests into device-specific operations.
• They provide a defined software interface between the OS and hardware.
• Incorrect or incompatible drivers can cause malfunction even when the physical device is healthy.
• They provide a defined software interface between the OS and hardware.
• Incorrect or incompatible drivers can cause malfunction even when the physical device is healthy.
వివరణ:
Question 137
ప్రశ్న 137
Which motherboard slot is normally used for installing a desktop DDR4 or DDR5 memory module?
Explanation:
• Desktop system memory modules are normally installed in DIMM slots.
• DIMM slots are keyed and electrically designed for a specific memory generation supported by the motherboard.
• CPU and expansion slots have different mechanical and electrical purposes.
• DIMM slots are keyed and electrically designed for a specific memory generation supported by the motherboard.
• CPU and expansion slots have different mechanical and electrical purposes.
వివరణ:
Question 138
ప్రశ్న 138
Which feature keeps selected rows and columns visible while the user scrolls through a large worksheet?
Explanation:
• Freeze Panes locks selected worksheet rows or columns in the visible window.
• It is useful for keeping headers visible while scrolling through many records.
• It does not change the underlying data or formulas.
• It is useful for keeping headers visible while scrolling through many records.
• It does not change the underlying data or formulas.
వివరణ:
Question 139
ప్రశ్న 139
Which concurrency anomaly occurs when a repeated range query returns additional or missing qualifying rows because another transaction inserted or deleted matching records?
Explanation:
• Phantoms involve changes to the set of rows satisfying a query predicate.
• Another transaction can insert or delete matching rows between repeated executions.
• This differs from a non-repeatable read, which concerns changed values of an already read row.
• Another transaction can insert or delete matching rows between repeated executions.
• This differs from a non-repeatable read, which concerns changed values of an already read row.
వివరణ:
Question 140
ప్రశ్న 140
Seven 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.
• (7−2)×2 TB = 10 TB.
• The equivalent capacity of two drives is used for dual parity.
• (7−2)×2 TB = 10 TB.
• The equivalent capacity of two drives is used for dual parity.
వివరణ:
Question 141
ప్రశ్న 141
Which statement about System Restore is correct?
Explanation:
• System Restore focuses on system files, registry state, drivers and related configuration.
• It can help reverse problematic system changes.
• Personal file backup requires separate backup mechanisms.
• It can help reverse problematic system changes.
• Personal file backup requires separate backup mechanisms.
వివరణ:
Question 142
ప్రశ్న 142
Which Word feature displays a hierarchical list of styled headings and supports quick navigation in a long document?
Explanation:
• The Navigation Pane can display headings based on heading styles.
• Selecting a heading moves the document view to that location.
• This is particularly useful in long structured reports.
• Selecting a heading moves the document view to that location.
• This is particularly useful in long structured reports.
వివరణ:
Question 143
ప్రశ్న 143
Which statement best describes a cryptographic hash function?
Explanation:
• Hash functions map input data to fixed-size digests for a given algorithm.
• Small changes in input should produce substantially different digest values for secure hash functions.
• Unlike encryption, hashing is not designed as a reversible confidentiality mechanism.
• Small changes in input should produce substantially different digest values for secure hash functions.
• Unlike encryption, hashing is not designed as a reversible confidentiality mechanism.
వివరణ:
Question 144
ప్రశ్న 144
A keyboard is connected but several keys repeatedly generate incorrect characters. Which troubleshooting step is most appropriate before replacing the motherboard?
Explanation:
• The symptom can result from a defective keyboard, connection issue or incorrect keyboard layout configuration.
• Testing the device independently helps distinguish peripheral failure from system configuration.
• Replacing major system hardware before isolating the keyboard would be premature.
• Testing the device independently helps distinguish peripheral failure from system configuration.
• Replacing major system hardware before isolating the keyboard would be premature.
వివరణ:
Question 145
ప్రశ్న 145
A report is grouped by District and needs one subtotal after each district group. Where should the subtotal control normally be placed?
Explanation:
• A group footer appears once after the records in each group.
• A subtotal expression there can aggregate values for the current District.
• A Report Footer is more appropriate for an overall grand total.
• A subtotal expression there can aggregate values for the current District.
• A Report Footer is more appropriate for an overall grand total.
వివరణ:
Question 146
ప్రశ్న 146
Assertion (A): T1 holding resource A while waiting for B, and T2 holding B while waiting for A, can produce a deadlock.
Reason (R): The two tasks form a circular wait in which each requires a resource currently held by the other.
Choose the correct answer.
Reason (R): The two tasks form a circular wait in which each requires a resource currently held by the other.
Choose the correct answer.
Explanation:
• The described allocation creates a cycle in the wait-for relationship.
• Neither task can obtain its requested resource unless the cycle is broken.
• Both statements are true, and circular wait directly explains the deadlock possibility.
• Neither task can obtain its requested resource unless the cycle is broken.
• Both statements are true, and circular wait directly explains the deadlock possibility.
వివరణ:
Question 147
ప్రశ్న 147
A high-performance NVMe SSD is to be installed in a compatible modern desktop motherboard. Which connection is most directly associated with this type of drive?
Explanation:
• NVMe SSDs commonly communicate over PCI Express rather than the SATA/AHCI storage path.
• Many desktop NVMe drives use an M.2 form factor and a compatible M.2 socket wired for PCIe.
• DIMM and PS/2 connectors serve memory and peripheral functions rather than NVMe storage.
• Many desktop NVMe drives use an M.2 form factor and a compatible M.2 socket wired for PCIe.
• DIMM and PS/2 connectors serve memory and peripheral functions rather than NVMe storage.
వివరణ:
Question 148
ప్రశ్న 148
Which Excel feature summarizes large tabular datasets interactively by placing fields into rows, columns, filters and values areas?
Explanation:
• PivotTables aggregate and reorganize tabular data without requiring the source table to be manually rearranged.
• Fields can be dragged among row, column, filter and values areas.
• They are widely used for grouped summaries and exploratory analysis.
• Fields can be dragged among row, column, filter and values areas.
• They are widely used for grouped summaries and exploratory analysis.
వివరణ:
Question 149
ప్రశ్న 149
T1 holds a lock on row A and waits for row B, while T2 holds row B and waits for row A. What condition is present?
Explanation:
• Each transaction waits for a resource held by the other, creating a circular wait.
• Neither can progress unless the DBMS breaks the cycle.
• DBMSs commonly detect deadlocks and abort one transaction as a victim.
• Neither can progress unless the DBMS breaks the cycle.
• DBMSs commonly detect deadlocks and abort one transaction as a victim.
వివరణ:
Question 150
ప్రశ్న 150
Four identical 4 TB drives are configured as conventional RAID 10. Ignoring overhead, what is the approximate usable capacity?
Explanation:
• RAID 10 combines mirroring and striping.
• With mirrored pairs, approximately half of the total raw capacity is usable.
• 4 drives×4 TB = 16 TB raw, so usable capacity is approximately 8 TB.
• With mirrored pairs, approximately half of the total raw capacity is usable.
• 4 drives×4 TB = 16 TB raw, so usable capacity is approximately 8 TB.
వివరణ:
Question 151
ప్రశ్న 151
A user deletes a normal file from a local Windows drive and it goes to the Recycle Bin. What does Restore normally do?
Explanation:
• Recycle Bin retains eligible deleted files temporarily.
• Restore returns a selected item to the location from which it was deleted.
• Some deletion methods, storage locations or very large files may bypass the Recycle Bin.
• Restore returns a selected item to the location from which it was deleted.
• Some deletion methods, storage locations or very large files may bypass the Recycle Bin.
వివరణ:
Question 152
ప్రశ్న 152
Which reference feature places explanatory notes at the bottom of the page on which the reference mark appears?
Explanation:
• Footnotes appear at the bottom of the relevant page in typical document layouts.
• Endnotes are collected at the end of a document or section instead.
• Both can be managed automatically by Word with numbered reference marks.
• Endnotes are collected at the end of a document or section instead.
• Both can be managed automatically by Word with numbered reference marks.
వివరణ:
Question 153
ప్రశ్న 153
Which VPN type is most suitable for securely connecting two office networks through their respective VPN gateways across the public Internet?
Explanation:
• A site-to-site VPN protects traffic between networks through gateways at the participating sites.
• It creates a virtual protected path over the existing public network.
• Remote-access VPNs instead focus on individual remote users or endpoints.
• It creates a virtual protected path over the existing public network.
• Remote-access VPNs instead focus on individual remote users or endpoints.
వివరణ:
Question 154
ప్రశ్న 154
Which device allows one keyboard, monitor and mouse to control multiple computers by switching the console connection between them?
Explanation:
• KVM stands for Keyboard, Video and Mouse.
• A KVM switch lets one console be shared among multiple computers.
• It is common in server rooms and administrative environments.
• A KVM switch lets one console be shared among multiple computers.
• It is common in server rooms and administrative environments.
వివరణ:
Question 155
ప్రశ్న 155
Which Access field property is most appropriate for restricting Marks to values from 0 through 100?
Explanation:
• A Validation Rule defines a condition that entered data must satisfy.
• A rule such as >=0 And <=100 directly enforces the allowed numeric range.
• Validation Text can provide a user-friendly message when the rule is violated.
• A rule such as >=0 And <=100 directly enforces the allowed numeric range.
• Validation Text can provide a user-friendly message when the rule is violated.
వివరణ:
Question 156
ప్రశ్న 156
Which statement best describes a file system?
Explanation:
• File systems organize persistent data into files and directories and maintain metadata such as names, sizes and allocation information.
• Examples include NTFS and FAT-family file systems.
• They operate above the raw storage-device level.
• Examples include NTFS and FAT-family file systems.
• They operate above the raw storage-device level.
వివరణ:
Question 157
ప్రశ్న 157
A newly assembled desktop shows no fans, lights or other signs of power. Which check should normally come before operating-system troubleshooting?
Explanation:
• A system with no signs of power has not reached the operating-system stage.
• Basic power delivery and front-panel connections should be verified before replacing major components.
• Software troubleshooting cannot correct a missing electrical power path.
• Basic power delivery and front-panel connections should be verified before replacing major components.
• Software troubleshooting cannot correct a missing electrical power path.
వివరణ:
Question 158
ప్రశ్న 158
A formula cell must become exactly 1000 by changing one input cell. Which Excel feature is designed for this one-variable reverse calculation?
Explanation:
• Goal Seek works backward from a target formula result.
• The user specifies the formula cell, desired value and one changing input cell.
• It is a simple what-if tool for single-variable targets.
• The user specifies the formula cell, desired value and one changing input cell.
• It is a simple what-if tool for single-variable targets.
వివరణ:
Question 159
ప్రశ్న 159
Which transaction-isolation level is intended to make the result of concurrent transactions equivalent to some valid serial, one-at-a-time execution order?
Explanation:
• Serializable is the strongest standard SQL isolation level in the usual hierarchy.
• Its goal is for concurrent execution to produce an outcome equivalent to some serial ordering of the transactions.
• Lower isolation levels can permit additional concurrency phenomena that serializable execution is designed to prevent.
• Its goal is for concurrent execution to produce an outcome equivalent to some serial ordering of the transactions.
• Lower isolation levels can permit additional concurrency phenomena that serializable execution is designed to prevent.
వివరణ:
Question 160
ప్రశ్న 160
Which RAID level among RAID 0, RAID 1, RAID 5 and RAID 6 provides no RAID-level redundancy?
Explanation:
• RAID 0 stripes data for performance and capacity but stores no redundant copy or parity.
• Failure of a participating drive can therefore destroy the array data set.
• RAID 1 mirrors data, while RAID 5 and RAID 6 use parity-based redundancy.
• Failure of a participating drive can therefore destroy the array data set.
• RAID 1 mirrors data, while RAID 5 and RAID 6 use parity-based redundancy.
వివరణ:
Question 161
ప్రశ్న 161
Which Windows tool is most appropriate for reviewing CPU, memory, disk and network usage by running processes?
Explanation:
• Task Manager provides process and performance information for key system resources.
• It is useful for identifying applications consuming excessive CPU, memory, disk or network resources.
• It can also terminate unresponsive tasks when appropriate.
• It is useful for identifying applications consuming excessive CPU, memory, disk or network resources.
• It can also terminate unresponsive tasks when appropriate.
వివరణ:
Question 162
ప్రశ్న 162
A report must display newspaper-style text in two vertical columns for only one section. Which Word feature should be used?
Explanation:
• Word can apply multi-column text layout to a selected section.
• Section breaks can isolate the portion requiring two-column formatting.
• This allows other parts of the document to remain single-column.
• Section breaks can isolate the portion requiring two-column formatting.
• This allows other parts of the document to remain single-column.
వివరణ:
Question 163
ప్రశ్న 163
A laptop is already infected with malware before connecting to a properly encrypted VPN. Which statement is correct?
Explanation:
• VPN encryption protects communications between defined endpoints.
• It does not automatically repair or clean an already compromised device.
• Endpoint protection, patching, authorization and monitoring remain necessary.
• It does not automatically repair or clean an already compromised device.
• Endpoint protection, patching, authorization and monitoring remain necessary.
వివరణ:
Question 164
ప్రశ్న 164
Which statement correctly distinguishes an input device from an output device?
Explanation:
• Scanners acquire information from physical documents and send it into the computer.
• Projectors display visual information generated by the computer.
• The distinction is based on the primary direction of information flow.
• Projectors display visual information generated by the computer.
• The distinction is based on the primary direction of information flow.
వివరణ:
Question 165
ప్రశ్న 165
Which Access property is intended to control the pattern in which data is entered, such as a structured telephone-number format?
Explanation:
• Input Masks guide data entry through predefined character positions.
• They are useful for consistent formatting of structured values.
• Validation Rules instead test whether a completed value satisfies a condition.
• They are useful for consistent formatting of structured values.
• Validation Rules instead test whether a completed value satisfies a condition.
వివరణ:
Question 166
ప్రశ్న 166
From the command prompt, a user wants to copy every .LOG file in C:LOGS to D:ARCHIVE without changing the source files. Which command is correct?
Explanation:
• COPY duplicates files while leaving the originals at the source location.
• The *.LOG wildcard selects files whose extension is LOG.
• MOVE would relocate the files rather than merely copying them.
• The *.LOG wildcard selects files whose extension is LOG.
• MOVE would relocate the files rather than merely copying them.
వివరణ:
Question 167
ప్రశ్న 167
A PC powers on and firmware displays a memory-related POST error immediately after a RAM upgrade. What is the most appropriate first action?
Explanation:
• The failure began directly after a memory change and occurs during POST.
• Reseating and testing modules individually can isolate poor contact, incompatibility, a bad module or a bad slot.
• The operating system has not yet started, so formatting the drive is unrelated.
• Reseating and testing modules individually can isolate poor contact, incompatibility, a bad module or a bad slot.
• The operating system has not yet started, so formatting the drive is unrelated.
వివరణ:
Question 168
ప్రశ్న 168
A filtered Excel table should sum only rows remaining visible after the filter. Which function is specifically suitable?
Explanation:
• SUBTOTAL performs aggregate calculations designed to work with filtered lists.
• Function-number choices determine whether hidden rows are treated in particular ways.
• It is commonly used for sums, averages and counts in filtered tables.
• Function-number choices determine whether hidden rows are treated in particular ways.
• It is commonly used for sums, averages and counts in filtered tables.
వివరణ:
Question 169
ప్రశ్న 169
What is the principal trade-off of creating an index on a frequently searched column?
Explanation:
• Indexes provide auxiliary structures that can reduce the work needed for suitable searches and ordering.
• The DBMS must maintain those structures when indexed data changes.
• Therefore indexes can improve read performance at the cost of space and write overhead.
• The DBMS must maintain those structures when indexed data changes.
• Therefore indexes can improve read performance at the cost of space and write overhead.
వివరణ:
Question 170
ప్రశ్న 170
Which statement about SSDs and HDDs is correct?
Explanation:
• Traditional HDDs use rotating magnetic platters and movable heads.
• SSDs use semiconductor storage without mechanical seek movement.
• This gives SSDs much lower random-access latency in typical workloads.
• SSDs use semiconductor storage without mechanical seek movement.
• This gives SSDs much lower random-access latency in typical workloads.
వివరణ:
Question 171
ప్రశ్న 171
Which statement about NTFS permissions is correct?
Explanation:
• NTFS permissions form part of Windows file-system access control.
• Permissions can be assigned to users and groups and inherited through folder structures.
• They are separate from network protocols and display configuration.
• Permissions can be assigned to users and groups and inherited through folder structures.
• They are separate from network protocols and display configuration.
వివరణ:
Question 172
ప్రశ్న 172
A printer produces faint pages and the toner cartridge is nearly empty. Which troubleshooting action is most directly relevant?
Explanation:
• Low toner can directly cause light or incomplete laser-printer output.
• Consumables and printer status should be checked before unrelated computer-system changes.
• CPU and network configuration do not correct an exhausted toner supply.
• Consumables and printer status should be checked before unrelated computer-system changes.
• CPU and network configuration do not correct an exhausted toner supply.
వివరణ:
Question 173
ప్రశ్న 173
What is the purpose of enforcing referential integrity between related Access tables?
Explanation:
• Referential integrity helps ensure child records reference valid parent records.
• It can also control deletion and update behavior depending on relationship options.
• This improves consistency across related tables.
• It can also control deletion and update behavior depending on relationship options.
• This improves consistency across related tables.
వివరణ:
Question 174
ప్రశ్న 174
Which operating-system technique temporarily stores data to absorb differences in producer and consumer speeds during I/O?
Explanation:
• Buffers hold data temporarily while it moves between components operating at different rates.
• This can smooth short bursts and reduce waiting between producer and consumer.
• Buffering is related to but distinct from spooling, which commonly queues complete jobs for shared devices.
• This can smooth short bursts and reduce waiting between producer and consumer.
• Buffering is related to but distinct from spooling, which commonly queues complete jobs for shared devices.
వివరణ:
Question 175
ప్రశ్న 175
Which statement about POST is correct?
Explanation:
• POST occurs during firmware-controlled startup before normal OS loading.
• It helps identify hardware initialization problems such as certain memory or device failures.
• A successful POST does not guarantee that the operating system itself will boot successfully.
• It helps identify hardware initialization problems such as certain memory or device failures.
• A successful POST does not guarantee that the operating system itself will boot successfully.
వివరణ:
Question 176
ప్రశ్న 176
What does the formula =COUNTBLANK(A1:A10) return?
Explanation:
• COUNTBLANK counts blank cells within the specified range.
• It is useful for identifying missing data in a worksheet.
• It does not sum values or count worksheets.
• It is useful for identifying missing data in a worksheet.
• It does not sum values or count worksheets.
వివరణ:
Question 177
ప్రశ్న 177
Which SQL operation combines related rows from two tables according to matching column values?
Explanation:
• A JOIN combines rows from multiple tables based on a relationship or matching condition.
• It is central to querying normalized relational data stored in separate tables.
• COMMIT and ROLLBACK are transaction-control operations rather than row-combination operators.
• It is central to querying normalized relational data stored in separate tables.
• COMMIT and ROLLBACK are transaction-control operations rather than row-combination operators.
వివరణ:
Question 178
ప్రశ్న 178
What is the primary purpose of S.M.A.R.T. information reported by many storage drives?
Explanation:
• S.M.A.R.T. exposes health-related attributes and status information maintained by supported drives.
• Warnings can help identify a drive that should be backed up and replaced before complete failure.
• It is a monitoring mechanism, not a guarantee that every failure will be predicted.
• Warnings can help identify a drive that should be backed up and replaced before complete failure.
• It is a monitoring mechanism, not a guarantee that every failure will be predicted.
వివరణ:
Question 179
ప్రశ్న 179
A Windows service configured for Automatic startup repeatedly fails during boot. What is the most useful next diagnostic combination?
Explanation:
• Services shows startup type, current state and dependencies.
• Event Viewer can contain Service Control Manager and application/system errors explaining the failure.
• Combining configuration and log evidence is more targeted than unrelated changes.
• Event Viewer can contain Service Control Manager and application/system errors explaining the failure.
• Combining configuration and log evidence is more targeted than unrelated changes.
వివరణ:
Question 180
ప్రశ్న 180
Which device is best suited to producing large engineering drawings, maps or CAD output on wide-format media?
Explanation:
• Plotters and large-format printers are designed for oversized technical graphics and drawings.
• They are common in engineering, architecture and mapping workflows.
• Microphones and keyboard devices are input peripherals.
• They are common in engineering, architecture and mapping workflows.
• Microphones and keyboard devices are input peripherals.
వివరణ:
Question 181
ప్రశ్న 181
Which Access wizard is designed to find records in one table that have no matching related record in another table?
Explanation:
• The Find Unmatched Query Wizard builds a query that identifies rows lacking related matches.
• It is useful for tasks such as finding employees with no training record.
• The other wizards create forms, reports or labels rather than unmatched-record queries.
• It is useful for tasks such as finding employees with no training record.
• The other wizards create forms, reports or labels rather than unmatched-record queries.
వివరణ:
Question 182
ప్రశ్న 182
A file named OLDNAME.TXT in the current directory must be renamed to NEWNAME.TXT without moving it. Which command is appropriate?
Explanation:
• REN changes the name of a file or directory without copying its contents to a second file.
• The first argument identifies the existing name and the second gives the new name.
• COPY creates another file, DEL deletes files and MD creates directories.
• The first argument identifies the existing name and the second gives the new name.
• COPY creates another file, DEL deletes files and MD creates directories.
వివరణ:
Question 183
ప్రశ్న 183
Consider the following statements about UEFI Secure Boot:
1. It participates in the pre-operating-system boot process.
2. It can verify boot components against configured trust information.
3. It is intended to help prevent unauthorized or untrusted boot software from running.
4. It replaces the need for every operating-system security control after startup.
Which statements are correct?
1. It participates in the pre-operating-system boot process.
2. It can verify boot components against configured trust information.
3. It is intended to help prevent unauthorized or untrusted boot software from running.
4. It replaces the need for every operating-system security control after startup.
Which statements are correct?
Explanation:
• Secure Boot operates in the firmware-controlled boot chain before normal operating-system execution.
• It uses configured trust information to decide whether relevant boot components are permitted to execute.
• Statement 4 is false because Secure Boot complements rather than replaces operating-system, application and endpoint security.
• It uses configured trust information to decide whether relevant boot components are permitted to execute.
• Statement 4 is false because Secure Boot complements rather than replaces operating-system, application and endpoint security.
వివరణ:
Question 184
ప్రశ్న 184
Which chart type is generally most suitable for showing a trend in a value across ordered time periods?
Explanation:
• Line charts emphasize change across an ordered sequence such as months or years.
• They make direction and trend easier to see than part-to-whole charts.
• Pie and doughnut charts are intended primarily for composition at one point in time.
• They make direction and trend easier to see than part-to-whole charts.
• Pie and doughnut charts are intended primarily for composition at one point in time.
వివరణ:
Question 185
ప్రశ్న 185
A many-to-many relationship exists between Students and Courses. Which design is most appropriate?
Explanation:
• Many-to-many relationships are normally resolved through an associative or junction table.
• Each junction row represents one Student–Course association.
• Foreign keys preserve the links to the parent tables while a uniqueness rule prevents duplicate associations.
• Each junction row represents one Student–Course association.
• Foreign keys preserve the links to the parent tables while a uniqueness rule prevents duplicate associations.
వివరణ:
Question 186
ప్రశ్న 186
Which storage medium is read and written using laser-based optical technology?
Explanation:
• CDs and DVDs use optical laser technology to read encoded information from the disc surface.
• Recordable optical media also use laser-based processes for writing.
• DRAM and CPU registers are semiconductor memory rather than optical storage.
• Recordable optical media also use laser-based processes for writing.
• DRAM and CPU registers are semiconductor memory rather than optical storage.
వివరణ:
Question 187
ప్రశ్న 187
The firmware detects a system SSD, but the PC always attempts network/PXE boot first. Which setting should be checked?
Explanation:
• Firmware boot order determines which available boot sources are attempted first.
• If network boot has higher priority, the machine may try PXE before the local SSD.
• Application settings cannot control pre-OS firmware boot priority.
• If network boot has higher priority, the machine may try PXE before the local SSD.
• Application settings cannot control pre-OS firmware boot priority.
వివరణ:
Question 188
ప్రశ్న 188
Which chart type is generally suitable for showing each category as a share of one meaningful total when there are only a few categories?
Explanation:
• Pie charts represent slices as proportions of a total.
• They are most useful when categories are few and the total is meaningful.
• For precise ranking among many categories, a bar chart is usually clearer.
• They are most useful when categories are few and the total is meaningful.
• For precise ranking among many categories, a bar chart is usually clearer.
వివరణ:
Question 189
ప్రశ్న 189
Which command permanently completes the current transaction when all required changes are correct?
Explanation:
• COMMIT ends the transaction and makes its successful changes durable according to DBMS rules.
• ROLLBACK cancels applicable uncommitted changes.
• SELECT retrieves data and does not itself complete a transaction as a commit operation.
• ROLLBACK cancels applicable uncommitted changes.
• SELECT retrieves data and does not itself complete a transaction as a commit operation.
వివరణ:
Question 190
ప్రశ్న 190
A two-drive RAID 1 consists of two identical 5 TB drives. Ignoring overhead, what is its usable capacity?
Explanation:
• RAID 1 mirrors the same data across both member drives.
• Only one drive worth of unique data capacity is therefore available.
• Two 5 TB drives provide approximately 5 TB of usable mirrored storage.
• Only one drive worth of unique data capacity is therefore available.
• Two 5 TB drives provide approximately 5 TB of usable mirrored storage.
వివరణ:
Question 191
ప్రశ్న 191
Which high-level sequence correctly represents normal computer startup?
Explanation:
• Firmware begins executing after power is supplied and performs early hardware initialization.
• A boot manager or loader then starts the operating-system loading process.
• Interactive sign-in occurs only after the operating system has initialized sufficiently.
• A boot manager or loader then starts the operating-system loading process.
• Interactive sign-in occurs only after the operating system has initialized sufficiently.
వివరణ:
Question 192
ప్రశ్న 192
Which statement about sorting and filtering in Excel is correct?
Explanation:
• Sorting rearranges records according to one or more sort keys.
• Filtering changes which rows are displayed without inherently deleting the hidden records.
• Both are core tools for working with structured worksheet data.
• Filtering changes which rows are displayed without inherently deleting the hidden records.
• Both are core tools for working with structured worksheet data.
వివరణ:
Question 193
ప్రశ్న 193
Which statement about RAID is technically correct?
Explanation:
• RAID redundancy protects primarily against specified member-drive failures.
• It does not inherently protect against ransomware, accidental deletion, corruption, theft or total-array loss.
• Independent backups remain necessary for recovery from those broader failure scenarios.
• It does not inherently protect against ransomware, accidental deletion, corruption, theft or total-array loss.
• Independent backups remain necessary for recovery from those broader failure scenarios.
వివరణ:
Question 194
ప్రశ్న 194
Which statement correctly distinguishes BIOS and UEFI at a general exam level?
Explanation:
• BIOS and UEFI are firmware environments involved in computer startup and booting.
• UEFI is the modern replacement for the traditional PC BIOS model on contemporary systems.
• Both operate before normal operating-system application execution.
• UEFI is the modern replacement for the traditional PC BIOS model on contemporary systems.
• Both operate before normal operating-system application execution.
వివరణ:
Question 195
ప్రశ్న 195
In Excel, B2:B4 contain {3,5,2} and C2:C4 contain {4,6,7}. What is returned by =SUMPRODUCT(B2:B4,C2:C4)?
Explanation:
• SUMPRODUCT multiplies corresponding values and then adds the products.
• The calculation is (3×4)+(5×6)+(2×7) = 12+30+14.
• The result is 56.
• The calculation is (3×4)+(5×6)+(2×7) = 12+30+14.
• The result is 56.
వివరణ:
Question 196
ప్రశ్న 196
Which statement correctly compares RAM and secondary storage?
Explanation:
• RAM holds active programs and data and normally loses contents when power is removed.
• Secondary storage retains programs and files without continuous power.
• The two technologies differ substantially in speed, capacity, persistence and purpose.
• Secondary storage retains programs and files without continuous power.
• The two technologies differ substantially in speed, capacity, persistence and purpose.
వివరణ:
Question 197
ప్రశ్న 197
A CPU core has a clock rate of 3 GHz. Which statement is technically safest?
Explanation:
• 3 GHz means 3 billion clock cycles per second.
• Instructions can require different numbers of cycles and modern CPUs can also overlap or parallelize work.
• Therefore clock rate alone cannot be equated directly with an exact instruction-per-second value.
• Instructions can require different numbers of cycles and modern CPUs can also overlap or parallelize work.
• Therefore clock rate alone cannot be equated directly with an exact instruction-per-second value.
వివరణ:
Question 198
ప్రశ్న 198
Which description best matches the von Neumann bottleneck?
Explanation:
• In the classic von Neumann organization, instructions and data share memory resources and transfer pathways.
• The processor may be capable of executing faster than information can be supplied from memory.
• This mismatch between processor demand and memory-path bandwidth is commonly called the von Neumann bottleneck.
• The processor may be capable of executing faster than information can be supplied from memory.
• This mismatch between processor demand and memory-path bandwidth is commonly called the von Neumann bottleneck.
వివరణ:
Question 199
ప్రశ్న 199
Which statement about a CPU heat sink and thermal interface material is correct?
Explanation:
• Even apparently smooth metal surfaces contain microscopic irregularities that trap air.
• Thermal interface material reduces the thermal resistance of the contact by filling these gaps.
• It should be applied appropriately between mating thermal surfaces rather than to electrical socket contacts.
• Thermal interface material reduces the thermal resistance of the contact by filling these gaps.
• It should be applied appropriately between mating thermal surfaces rather than to electrical socket contacts.
వివరణ:
Question 200
ప్రశ్న 200
A system powers on but produces no display after a new graphics card is installed. Which first check is most appropriate?
Explanation:
• The failure appeared after a graphics-card installation, so the changed hardware path should be checked first.
• Many discrete GPUs require auxiliary PCIe power in addition to slot power.
• Display cabling and card seating can prevent video output even when the rest of the computer powers on.
• Many discrete GPUs require auxiliary PCIe power in addition to slot power.
• Display cabling and card seating can prevent video output even when the rest of the computer powers on.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. Program Counter (PC) సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: A. 30 సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: A. 1, 2 and 3 only సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: B. CPU registers → cache → main memory (RAM) → secondary storage సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: A. DIR REPORT.TXT /S సమాధానం: A.
-
Question 6 ప్రశ్న 6Answer: A. Styles సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: B. Malicious code that replicates by infecting or attaching itself to other executable content. సమాధానం: B.
-
Question 8 ప్రశ్న 8Answer: C. Scanner సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: A. Table సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: A. CPU scheduling సమాధానం: A.
-
Question 11 ప్రశ్న 11Answer: C. (a)-2, (b)-4, (c)-1, (d)-3 సమాధానం: C.
-
Question 12 ప్రశ్న 12Answer: B. (a)-3, (b)-4, (c)-2, (d)-1 సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: A. 1, 2 and 3 only సమాధానం: A.
-
Question 14 ప్రశ్న 14Answer: A. Arithmetic Logic Unit (ALU) సమాధానం: A.
-
Question 15 ప్రశ్న 15Answer: B. 3 సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: C. To represent a relationship by referencing a candidate/primary key value in another related table. సమాధానం: C.
-
Question 17 ప్రశ్న 17Answer: D. SRAM is generally faster and does not require periodic refresh, while DRAM is denser, cheaper per bit and requires refresh. సమాధానం: D.
-
Question 18 ప్రశ్న 18Answer: B. ATTRIB +R EVIDENCE.TXT సమాధానం: B.
-
Question 19 ప్రశ్న 19Answer: A. Table of Contents సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: A. A worm can propagate as a self-contained program, often over networks, without attaching itself to another executable host program. సమాధానం: A.
-
Question 21 ప్రశ్న 21Answer: B. (a)-3, (b)-2, (c)-1, (d)-4 సమాధానం: B.
-
Question 22 ప్రశ్న 22Answer: C. AutoNumber సమాధానం: C.
-
Question 23 ప్రశ్న 23Answer: D. Running → Waiting/Blocked సమాధానం: D.
-
Question 24 ప్రశ్న 24Answer: D. MAN సమాధానం: D.
-
Question 25 ప్రశ్న 25Answer: C. A transition occurs between slides, while an animation affects objects on a slide. సమాధానం: C.
-
Question 26 ప్రశ్న 26Answer: B. DNS సమాధానం: B.
-
Question 27 ప్రశ్న 27Answer: C. It directs and coordinates instruction execution by generating control signals for processor and system operations. సమాధానం: C.
-
Question 28 ప్రశ్న 28Answer: C. 2 సమాధానం: C.
-
Question 29 ప్రశ్న 29Answer: D. It helps prevent a foreign-key value from referring to a nonexistent related row. సమాధానం: D.
-
Question 30 ప్రశ్న 30Answer: A. PROM సమాధానం: A.
-
Question 31 ప్రశ్న 31Answer: D. Disk Management సమాధానం: D.
-
Question 32 ప్రశ్న 32Answer: B. Prepare main document → connect recipient data source → insert merge fields → preview → Finish & Merge సమాధానం: B.
-
Question 33 ప్రశ్న 33Answer: B. False positive సమాధానం: B.
-
Question 34 ప్రశ్న 34Answer: D. Optical Character Recognition (OCR) సమాధానం: D.
-
Question 35 ప్రశ్న 35Answer: D. Select query సమాధానం: D.
-
Question 36 ప్రశ్న 36Answer: B. Context switch సమాధానం: B.
-
Question 37 ప్రశ్న 37Answer: C. WAN సమాధానం: C.
-
Question 38 ప్రశ్న 38Answer: D. Presenter View సమాధానం: D.
-
Question 39 ప్రశ్న 39Answer: C. HTTPS సమాధానం: C.
-
Question 40 ప్రశ్న 40Answer: A. 600 million instructions per second సమాధానం: A.
-
Question 41 ప్రశ్న 41Answer: B. 500 సమాధానం: B.
-
Question 42 ప్రశ్న 42Answer: C. Tuple సమాధానం: C.
-
Question 43 ప్రశ్న 43Answer: D. EPROM సమాధానం: D.
-
Question 44 ప్రశ్న 44Answer: B. Task Scheduler సమాధానం: B.
-
Question 45 ప్రశ్న 45Answer: C. Place the page in its own section using section breaks and set that section to landscape. సమాధానం: C.
-
Question 46 ప్రశ్న 46Answer: A. Default deny సమాధానం: A.
-
Question 47 ప్రశ్న 47Answer: D. MICR reader సమాధానం: D.
-
Question 48 ప్రశ్న 48Answer: D. Parameter query సమాధానం: D.
-
Question 49 ప్రశ్న 49Answer: A. Preemptive scheduling సమాధానం: A.
-
Question 50 ప్రశ్న 50Answer: C. Failure of one endpoint cable usually affects only that endpoint, but failure of the central switch can affect all connected endpoints. సమాధానం: C.
-
Question 51 ప్రశ్న 51Answer: A. Notes Pages సమాధానం: A.
-
Question 52 ప్రశ్న 52Answer: D. SMTP సమాధానం: D.
-
Question 53 ప్రశ్న 53Answer: B. Address bus సమాధానం: B.
-
Question 54 ప్రశ్న 54Answer: A. PASS సమాధానం: A.
-
Question 55 ప్రశ్న 55Answer: C. Cardinality = 850; Degree = 12 సమాధానం: C.
-
Question 56 ప్రశ్న 56Answer: A. EEPROM సమాధానం: A.
-
Question 57 ప్రశ్న 57Answer: D. Services సమాధానం: D.
-
Question 58 ప్రశ్న 58Answer: A. A page break starts a new page, while a section break can also create a new section with independent formatting settings. సమాధానం: A.
-
Question 59 ప్రశ్న 59Answer: D. (a)-3, (b)-1, (c)-4, (d)-2 సమాధానం: D.
-
Question 60 ప్రశ్న 60Answer: D. Fuser assembly సమాధానం: D.
-
Question 61 ప్రశ్న 61Answer: A. Crosstab query సమాధానం: A.
-
Question 62 ప్రశ్న 62Answer: C. It provides processes with virtual address spaces that the operating system maps to physical memory and, when needed, backing storage. సమాధానం: C.
-
Question 63 ప్రశ్న 63Answer: A. 36 సమాధానం: A.
-
Question 64 ప్రశ్న 64Answer: A. Custom Slide Show సమాధానం: A.
-
Question 65 ప్రశ్న 65Answer: A. Intranet service సమాధానం: A.
-
Question 66 ప్రశ్న 66Answer: A. The data bus carries data values, while the address bus identifies the source or destination location for a transfer. సమాధానం: A.
-
Question 67 ప్రశ్న 67Answer: C. CHECK సమాధానం: C.
-
Question 68 ప్రశ్న 68Answer: D. Partial dependency of a non-key attribute on only part of a candidate key సమాధానం: D.
-
Question 69 ప్రశ్న 69Answer: C. 5 ns సమాధానం: C.
-
Question 70 ప్రశ్న 70Answer: B. To limit silent elevation by prompting for consent or credentials when an operation requires administrative privilege. సమాధానం: B.
-
Question 71 ప్రశ్న 71Answer: A. Track Changes సమాధానం: A.
-
Question 72 ప్రశ్న 72Answer: A. It maintains information about active connections and can use that state when evaluating later packets. సమాధానం: A.
-
Question 73 ప్రశ్న 73Answer: D. Inkjet printer సమాధానం: D.
-
Question 74 ప్రశ్న 74Answer: B. Update query సమాధానం: B.
-
Question 75 ప్రశ్న 75Answer: A. An event raised when a process references a virtual page that requires operating-system handling because the needed mapping/page is not currently usable as requested. సమాధానం: A.
-
Question 76 ప్రశ్న 76Answer: D. Switch సమాధానం: D.
-
Question 77 ప్రశ్న 77Answer: B. Record Slide Show సమాధానం: B.
-
Question 78 ప్రశ్న 78Answer: C. DNS name resolution సమాధానం: C.
-
Question 79 ప్రశ్న 79Answer: C. 16 MiB సమాధానం: C.
-
Question 80 ప్రశ్న 80Answer: D. =$B5*E$1 సమాధానం: D.
-
Question 81 ప్రశ్న 81Answer: B. Transitive dependency of non-key attributes on other non-key attributes సమాధానం: B.
-
Question 82 ప్రశ్న 82Answer: B. The requested instruction or data is found in the cache being checked. సమాధానం: B.
-
Question 83 ప్రశ్న 83Answer: D. It normally has fewer system-wide privileges than an administrator account. సమాధానం: D.
-
Question 84 ప్రశ్న 84Answer: C. Keep with next సమాధానం: C.
-
Question 85 ప్రశ్న 85Answer: B. It acts as an intermediary at the application level, commonly establishing separate client-to-proxy and proxy-to-server connections. సమాధానం: B.
-
Question 86 ప్రశ్న 86Answer: D. Dot-matrix printer సమాధానం: D.
-
Question 87 ప్రశ్న 87Answer: D. Append query సమాధానం: D.
-
Question 88 ప్రశ్న 88Answer: B. The system spends excessive time paging because the active working sets do not fit effectively in available memory. సమాధానం: B.
-
Question 89 ప్రశ్న 89Answer: D. Router సమాధానం: D.
-
Question 90 ప్రశ్న 90Answer: C. Reuse Slides సమాధానం: C.
-
Question 91 ప్రశ్న 91Answer: A. Direct Memory Access (DMA) సమాధానం: A.
-
Question 92 ప్రశ్న 92Answer: D. $F$4 సమాధానం: D.
-
Question 93 ప్రశ్న 93Answer: D. Atomicity సమాధానం: D.
-
Question 94 ప్రశ్న 94Answer: A. Temporal locality సమాధానం: A.
-
Question 95 ప్రశ్న 95Answer: B. DISM /Online /Cleanup-Image /RestoreHealth సమాధానం: B.
-
Question 96 ప్రశ్న 96Answer: A. Different First Page సమాధానం: A.
-
Question 97 ప్రశ్న 97Answer: A. Both are normally knowledge factors, so they may represent two secrets from the same factor category. సమాధానం: A.
-
Question 98 ప్రశ్న 98Answer: A. How many times per second the display can update the image సమాధానం: A.
-
Question 99 ప్రశ్న 99Answer: B. Delete query సమాధానం: B.
-
Question 100 ప్రశ్న 100Answer: A. A program is passive code, while a process is an executing instance with execution state and allocated resources. సమాధానం: A.
-
Question 101 ప్రశ్న 101Answer: B. The host failed to obtain a normal IPv4 lease from DHCP and assigned itself an APIPA/link-local address. సమాధానం: B.
-
Question 102 ప్రశ్న 102Answer: C. Compress Media సమాధానం: C.
-
Question 103 ప్రశ్న 103Answer: C. Interrupt సమాధానం: C.
-
Question 104 ప్రశ్న 104Answer: A. 18.75 సమాధానం: A.
-
Question 105 ప్రశ్న 105Answer: D. Durability సమాధానం: D.
-
Question 106 ప్రశ్న 106Answer: C. Spatial locality సమాధానం: C.
-
Question 107 ప్రశ్న 107Answer: B. sfc /scannow సమాధానం: B.
-
Question 108 ప్రశ్న 108Answer: C. Different Odd & Even Pages సమాధానం: C.
-
Question 109 ప్రశ్న 109Answer: B. Multi-factor authentication using knowledge and biometric factors సమాధానం: B.
-
Question 110 ప్రశ్న 110Answer: C. The number of addressable picture elements horizontally and vertically in that display mode సమాధానం: C.
-
Question 111 ప్రశ్న 111Answer: D. Form సమాధానం: D.
-
Question 112 ప్రశ్న 112Answer: C. Threads within one process typically share the process address space and resources while maintaining separate execution contexts. సమాధానం: C.
-
Question 113 ప్రశ్న 113Answer: B. DHCP సమాధానం: B.
-
Question 114 ప్రశ్న 114Answer: C. Sections సమాధానం: C.
-
Question 115 ప్రశ్న 115Answer: B. Interrupt-driven I/O lets a device notify the CPU when service is needed, whereas polling makes the CPU repeatedly check device status. సమాధానం: B.
-
Question 116 ప్రశ్న 116Answer: D. 5 సమాధానం: D.
-
Question 117 ప్రశ్న 117Answer: B. Dirty read సమాధానం: B.
-
Question 118 ప్రశ్న 118Answer: D. 5632 MiB సమాధానం: D.
-
Question 119 ప్రశ్న 119Answer: A. Startup Repair సమాధానం: A.
-
Question 120 ప్రశ్న 120Answer: D. Find and Replace సమాధానం: D.
-
Question 121 ప్రశ్న 121Answer: C. Symmetric encryption uses shared secret-key material, while asymmetric cryptography uses a related public/private key pair. సమాధానం: C.
-
Question 122 ప్రశ్న 122Answer: A. Webcam or digital camera సమాధానం: A.
-
Question 123 ప్రశ్న 123Answer: C. Use a subform linked to the main form through CaseID. సమాధానం: C.
-
Question 124 ప్రశ్న 124Answer: C. Spooling సమాధానం: C.
-
Question 125 ప్రశ్న 125Answer: B. They are in the same 192.168.25.0/24 subnet and can communicate locally without routing through the default gateway. సమాధానం: B.
-
Question 126 ప్రశ్న 126Answer: C. Animation Pane సమాధానం: C.
-
Question 127 ప్రశ్న 127Answer: C. 24-pin ATX main power connector సమాధానం: C.
-
Question 128 ప్రశ్న 128Answer: D. Data Validation using a List సమాధానం: D.
-
Question 129 ప్రశ్న 129Answer: D. Non-repeatable read సమాధానం: D.
-
Question 130 ప్రశ్న 130Answer: C. 12 TB సమాధానం: C.
-
Question 131 ప్రశ్న 131Answer: A. It starts Windows with a limited set of drivers and services to help diagnose problems. సమాధానం: A.
-
Question 132 ప్రశ్న 132Answer: B. Restrict Editing సమాధానం: B.
-
Question 133 ప్రశ్న 133Answer: A. The signer’s corresponding public key సమాధానం: A.
-
Question 134 ప్రశ్న 134Answer: B. Sound card or audio interface సమాధానం: B.
-
Question 135 ప్రశ్న 135Answer: C. Report సమాధానం: C.
-
Question 136 ప్రశ్న 136Answer: A. To provide the operating system with software support for controlling and communicating with specific hardware. సమాధానం: A.
-
Question 137 ప్రశ్న 137Answer: C. DIMM slot సమాధానం: C.
-
Question 138 ప్రశ్న 138Answer: B. Freeze Panes సమాధానం: B.
-
Question 139 ప్రశ్న 139Answer: B. Phantom read సమాధానం: B.
-
Question 140 ప్రశ్న 140Answer: A. 10 TB సమాధానం: A.
-
Question 141 ప్రశ్న 141Answer: B. It rolls selected system configuration back to a restore point and is not a substitute for independent backup of personal files. సమాధానం: B.
-
Question 142 ప్రశ్న 142Answer: C. Navigation Pane సమాధానం: C.
-
Question 143 ప్రశ్న 143Answer: D. It produces a one-way digest useful for integrity checking and is not designed to be reversed with a decryption key. సమాధానం: D.
-
Question 144 ప్రశ్న 144Answer: B. Test the keyboard on another port or system and verify the input-language/layout setting. సమాధానం: B.
-
Question 145 ప్రశ్న 145Answer: C. District Group Footer సమాధానం: C.
-
Question 146 ప్రశ్న 146Answer: C. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: C.
-
Question 147 ప్రశ్న 147Answer: B. A compatible M.2 socket using PCI Express lanes and the NVMe protocol సమాధానం: B.
-
Question 148 ప్రశ్న 148Answer: A. PivotTable సమాధానం: A.
-
Question 149 ప్రశ్న 149Answer: A. Deadlock సమాధానం: A.
-
Question 150 ప్రశ్న 150Answer: A. 8 TB సమాధానం: A.
-
Question 151 ప్రశ్న 151Answer: C. Returns the file to its original location. సమాధానం: C.
-
Question 152 ప్రశ్న 152Answer: D. Footnote సమాధానం: D.
-
Question 153 ప్రశ్న 153Answer: B. Site-to-site VPN సమాధానం: B.
-
Question 154 ప్రశ్న 154Answer: D. KVM switch సమాధానం: D.
-
Question 155 ప్రశ్న 155Answer: A. Validation Rule సమాధానం: A.
-
Question 156 ప్రశ్న 156Answer: C. It defines how files, directories and related metadata are organized and managed on storage volumes. సమాధానం: C.
-
Question 157 ప్రశ్న 157Answer: D. Verify AC power, the PSU switch, motherboard power connectors and the front-panel power-switch connection. సమాధానం: D.
-
Question 158 ప్రశ్న 158Answer: B. Goal Seek సమాధానం: B.
-
Question 159 ప్రశ్న 159Answer: C. Serializable సమాధానం: C.
-
Question 160 ప్రశ్న 160Answer: A. RAID 0 సమాధానం: A.
-
Question 161 ప్రశ్న 161Answer: D. Task Manager సమాధానం: D.
-
Question 162 ప్రశ్న 162Answer: B. Section-specific Columns setting సమాధానం: B.
-
Question 163 ప్రశ్న 163Answer: B. The VPN can protect the communication path but does not by itself remove malware or make the endpoint trustworthy. సమాధానం: B.
-
Question 164 ప్రశ్న 164Answer: C. A scanner sends captured data into the computer, while a projector presents computer-generated visual output. సమాధానం: C.
-
Question 165 ప్రశ్న 165Answer: D. Input Mask సమాధానం: D.
-
Question 166 ప్రశ్న 166Answer: C. COPY C:LOGS*.LOG D:ARCHIVE సమాధానం: C.
-
Question 167 ప్రశ్న 167Answer: A. Power down, reseat the modules and test compatible modules one at a time. సమాధానం: A.
-
Question 168 ప్రశ్న 168Answer: D. SUBTOTAL సమాధానం: D.
-
Question 169 ప్రశ్న 169Answer: D. It can speed suitable lookups but consumes storage and adds maintenance work to inserts, deletes and updates. సమాధానం: D.
-
Question 170 ప్రశ్న 170Answer: D. SSDs have no mechanical seek or rotational delay, so they generally provide lower random-access latency than HDDs. సమాధానం: D.
-
Question 171 ప్రశ్న 171Answer: C. They can control actions such as reading, writing and modifying files and folders for users and groups. సమాధానం: C.
-
Question 172 ప్రశ్న 172Answer: A. Check or replace the toner cartridge according to printer guidance. సమాధానం: A.
-
Question 173 ప్రశ్న 173Answer: B. To prevent invalid relationships such as a foreign key referring to a nonexistent parent record. సమాధానం: B.
-
Question 174 ప్రశ్న 174Answer: D. Buffering సమాధానం: D.
-
Question 175 ప్రశ్న 175Answer: C. POST is part of the early startup process that initializes and checks hardware before the operating system loads. సమాధానం: C.
-
Question 176 ప్రశ్న 176Answer: B. The number of blank cells in A1:A10 సమాధానం: B.
-
Question 177 ప్రశ్న 177Answer: B. JOIN సమాధానం: B.
-
Question 178 ప్రశ్న 178Answer: A. To provide drive-health and reliability indicators that can warn of certain developing storage problems. సమాధానం: A.
-
Question 179 ప్రశ్న 179Answer: D. Check its status and dependencies in Services and inspect related Event Viewer entries. సమాధానం: D.
-
Question 180 ప్రశ్న 180Answer: B. Plotter or large-format plotter/printer సమాధానం: B.
-
Question 181 ప్రశ్న 181Answer: C. Find Unmatched Query Wizard సమాధానం: C.
-
Question 182 ప్రశ్న 182Answer: C. REN OLDNAME.TXT NEWNAME.TXT సమాధానం: C.
-
Question 183 ప్రశ్న 183Answer: B. 1, 2 and 3 only సమాధానం: B.
-
Question 184 ప్రశ్న 184Answer: D. Line chart సమాధానం: D.
-
Question 185 ప్రశ్న 185Answer: C. Use a junction table containing StudentID and CourseID as foreign keys, with a suitable uniqueness or composite-key rule. సమాధానం: C.
-
Question 186 ప్రశ్న 186Answer: D. Optical disc such as CD/DVD సమాధానం: D.
-
Question 187 ప్రశ్న 187Answer: A. UEFI/BIOS boot order or boot priority సమాధానం: A.
-
Question 188 ప్రశ్న 188Answer: A. Pie chart సమాధానం: A.
-
Question 189 ప్రశ్న 189Answer: D. COMMIT సమాధానం: D.
-
Question 190 ప్రశ్న 190Answer: D. 5 TB సమాధానం: D.
-
Question 191 ప్రశ్న 191Answer: D. Power on → firmware initialization/POST → boot manager or boot loader → operating-system startup → user sign-in సమాధానం: D.
-
Question 192 ప్రశ్న 192Answer: C. Sorting changes the order of rows, while filtering temporarily hides rows that do not meet selected criteria. సమాధానం: C.
-
Question 193 ప్రశ్న 193Answer: B. RAID redundancy can improve availability after certain drive failures, but it does not replace independent backups. సమాధానం: B.
-
Question 194 ప్రశ్న 194Answer: B. UEFI is the newer firmware architecture and provides a modern boot environment, while legacy BIOS is an older firmware interface. సమాధానం: B.
-
Question 195 ప్రశ్న 195Answer: D. 56 సమాధానం: D.
-
Question 196 ప్రశ్న 196Answer: A. RAM is fast volatile working memory, while secondary storage such as an SSD is non-volatile and normally offers much larger persistent capacity. సమాధానం: A.
-
Question 197 ప్రశ్న 197Answer: B. The clock provides 3 billion cycles per second, but this alone does not mean exactly 3 billion instructions are completed per second. సమాధానం: B.
-
Question 198 ప్రశ్న 198Answer: D. Instruction and data transfers sharing a limited memory path can constrain CPU–memory throughput. సమాధానం: D.
-
Question 199 ప్రశ్న 199Answer: B. Thermal interface material improves heat transfer by filling microscopic gaps between the CPU heat spreader and cooler base. సమాధానం: B.
-
Question 200 ప్రశ్న 200Answer: C. Verify that the card is fully seated, any required PCIe power connectors are attached, and the monitor is connected to the intended graphics output. సమాధానం: C.
