Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Using binary memory units, where 1 GiB = 1024 MiB, how many GiB are equal to 8192 MiB?
Explanation:
• To convert MiB to GiB, divide the MiB value by 1024.
• 8192 ÷ 1024 = 8.
• Therefore 8192 MiB is exactly 8 GiB.
• 8192 ÷ 1024 = 8.
• Therefore 8192 MiB is exactly 8 GiB.
వివరణ:
Question 2
ప్రశ్న 2
Using binary memory units, where 1 GiB = 1024 MiB, how many MiB are equal to 3.5 GiB?
Explanation:
• Convert GiB to MiB by multiplying by 1024.
• 3.5 × 1024 = 3584.
• Therefore 3.5 GiB corresponds to 3584 MiB.
• 3.5 × 1024 = 3584.
• Therefore 3.5 GiB corresponds to 3584 MiB.
వివరణ:
Question 3
ప్రశ్న 3
Using binary storage units, where 1 TiB = 1024 GiB, how many GiB are equal to 1.5 TiB?
Explanation:
• One TiB contains 1024 GiB.
• Therefore 1.5 × 1024 = 1536 GiB.
• The calculation uses the binary-unit relationship explicitly stated in the question.
• Therefore 1.5 × 1024 = 1536 GiB.
• The calculation uses the binary-unit relationship explicitly stated in the question.
వివరణ:
Question 4
ప్రశ్న 4
A computer has 7680 MiB of usable memory. Using 1 GiB = 1024 MiB, what is this capacity in GiB?
Explanation:
• Convert MiB to GiB by dividing by 1024.
• 7680 ÷ 1024 = 7.5.
• Therefore the usable memory capacity is 7.5 GiB.
• 7680 ÷ 1024 = 7.5.
• Therefore the usable memory capacity is 7.5 GiB.
వివరణ:
Question 5
ప్రశ్న 5
Five identical 4 TB drives are configured as a conventional RAID 5 array. Ignoring formatting and metadata overhead, what is the approximate usable capacity?
Explanation:
• Conventional RAID 5 usable capacity is approximately (N − 1) × capacity of the smallest member drive.
• With five 4 TB drives, usable capacity is (5 − 1) × 4 TB = 16 TB.
• The equivalent capacity of one drive is consumed by distributed parity.
• With five 4 TB drives, usable capacity is (5 − 1) × 4 TB = 16 TB.
• The equivalent capacity of one drive is consumed by distributed parity.
వివరణ:
Question 6
ప్రశ్న 6
Eight identical 3 TB drives are configured as a conventional RAID 6 array. Ignoring formatting and metadata overhead, what is the approximate usable capacity?
Explanation:
• RAID 6 usable capacity is approximately (N − 2) × capacity of the smallest drive.
• (8 − 2) × 3 TB = 6 × 3 TB = 18 TB.
• The equivalent capacity of two drives is used for dual-parity protection.
• (8 − 2) × 3 TB = 6 × 3 TB = 18 TB.
• The equivalent capacity of two drives is used for dual-parity protection.
వివరణ:
Question 7
ప్రశ్న 7
Eight identical 2 TB drives are configured as a conventional RAID 10 array consisting of mirrored pairs with striping across the pairs. Ignoring overhead, what is the approximate usable capacity?
Explanation:
• RAID 10 combines mirroring with striping and therefore provides approximately half of the total raw drive capacity as usable space.
• Eight 2 TB drives provide 16 TB of raw capacity.
• 16 TB ÷ 2 = 8 TB usable capacity.
• Eight 2 TB drives provide 16 TB of raw capacity.
• 16 TB ÷ 2 = 8 TB usable capacity.
వివరణ:
Question 8
ప్రశ్న 8
Which RAID level among RAID 0, RAID 1 with two drives, RAID 5 and RAID 6 can tolerate any two simultaneous member-drive failures without data loss under its normal fault-tolerance model?
Explanation:
• RAID 6 uses dual parity and is designed to tolerate failure of any two member drives.
• RAID 5 normally tolerates only one drive failure, while RAID 0 provides no redundancy.
• A two-drive RAID 1 cannot survive failure of both of its member drives.
• RAID 5 normally tolerates only one drive failure, while RAID 0 provides no redundancy.
• A two-drive RAID 1 cannot survive failure of both of its member drives.
వివరణ:
Question 9
ప్రశ్న 9
Two identical 6 TB drives are configured as RAID 1. Ignoring formatting and metadata overhead, what is the approximate usable capacity?
Explanation:
• RAID 1 stores mirrored copies of the same data on both drives.
• With two 6 TB drives, one drive's capacity represents the unique usable data and the other provides the mirrored copy.
• Therefore the approximate usable capacity is 6 TB.
• With two 6 TB drives, one drive's capacity represents the unique usable data and the other provides the mirrored copy.
• Therefore the approximate usable capacity is 6 TB.
వివరణ:
Question 10
ప్రశ్న 10
In Excel, cells A1:A5 contain 12, 18, 25, 30 and 15. What value is returned by =SUM(A1:A5)/COUNT(A1:A5)?
Explanation:
• SUM(A1:A5) = 12 + 18 + 25 + 30 + 15 = 100.
• COUNT(A1:A5) returns 5 because all five cells contain numbers.
• 100 ÷ 5 = 20.
• COUNT(A1:A5) returns 5 because all five cells contain numbers.
• 100 ÷ 5 = 20.
వివరణ:
Question 11
ప్రశ్న 11
In Excel, B2 contains 8 and C2 contains 5. What value is returned by =B2^2+C2*3?
Explanation:
• Exponentiation is evaluated before multiplication and addition: 8^2 = 64.
• C2*3 = 5 × 3 = 15.
• Therefore 64 + 15 = 79.
• C2*3 = 5 × 3 = 15.
• Therefore 64 + 15 = 79.
వివరణ:
Question 12
ప్రశ్న 12
In Excel, A2 contains 240 and B2 contains 15%. What value is returned by =A2*(1-B2)?
Explanation:
• B2 = 15% = 0.15, so 1 − B2 = 0.85.
• 240 × 0.85 = 204.
• The formula therefore returns 204.
• 240 × 0.85 = 204.
• The formula therefore returns 204.
వివరణ:
Question 13
ప్రశ్న 13
In Excel, B2 contains 72 and C2 contains 58. What does =IF(AND(B2>=60,C2>=60),"PASS","FAIL") return?
Explanation:
• B2>=60 is TRUE because 72 is at least 60.
• C2>=60 is FALSE because 58 is below 60, so AND returns FALSE.
• The IF function therefore returns "FAIL".
• C2>=60 is FALSE because 58 is below 60, so AND returns FALSE.
• The IF function therefore returns "FAIL".
వివరణ:
Question 14
ప్రశ్న 14
In Excel, A1:A5 contain 40, 55, 50, 70 and 35. What value is returned by =COUNTIF(A1:A5,">50")?
Explanation:
• COUNTIF counts cells satisfying the stated criterion.
• Only 55 and 70 are strictly greater than 50; the value 50 itself does not satisfy >50.
• Therefore the function returns 2.
• Only 55 and 70 are strictly greater than 50; the value 50 itself does not satisfy >50.
• Therefore the function returns 2.
వివరణ:
Question 15
ప్రశ్న 15
In Excel, B2:B6 contain {East, West, East, East, West}, C2:C6 contain {X, X, Y, X, Y}, and D2:D6 contain {100, 200, 300, 400, 500}. What is returned by =SUMIFS(D2:D6,B2:B6,"East",C2:C6,"X")?
Explanation:
• SUMIFS adds values only from rows satisfying all specified criteria.
• East and X occur together for amounts 100 and 400.
• Therefore 100 + 400 = 500.
• East and X occur together for amounts 100 and 400.
• Therefore 100 + 400 = 500.
వివరణ:
Question 16
ప్రశ్న 16
Which Excel cell reference keeps both column D and row 5 fixed when a formula is copied to another location?
Explanation:
• A dollar sign before the column fixes the column, while a dollar sign before the row fixes the row.
• $D$5 therefore fixes both column D and row 5.
• D$5 and $D5 are mixed references, while D5 is fully relative.
• $D$5 therefore fixes both column D and row 5.
• D$5 and $D5 are mixed references, while D5 is fully relative.
వివరణ:
Question 17
ప్రశ్న 17
Cell E3 contains the Excel formula =$B3+C$2. The formula is copied to G6. What formula will appear in G6?
Explanation:
• Copying from E3 to G6 moves the formula two columns right and three rows down.
• $B3 keeps column B fixed while row 3 becomes row 6, producing $B6.
• C$2 keeps row 2 fixed while column C moves two columns to E, producing E$2.
• $B3 keeps column B fixed while row 3 becomes row 6, producing $B6.
• C$2 keeps row 2 fixed while column C moves two columns to E, producing E$2.
వివరణ:
Question 18
ప్రశ్న 18
What value is returned by the Excel formula =ROUNDUP(-12.341,2)?
Explanation:
• ROUNDUP rounds a number away from zero to the requested number of digits.
• At two decimal places, -12.341 is rounded away from zero to -12.35.
• Therefore the function returns -12.35, not -12.34.
• At two decimal places, -12.341 is rounded away from zero to -12.35.
• Therefore the function returns -12.35, not -12.34.
వివరణ:
Question 19
ప్రశ్న 19
What value is returned by the Excel formula =MOD(29,6)?
Explanation:
• MOD returns the remainder after division.
• 29 = (6 × 4) + 5.
• Therefore the remainder, and hence the result of MOD(29,6), is 5.
• 29 = (6 × 4) + 5.
• Therefore the remainder, and hence the result of MOD(29,6), is 5.
వివరణ:
Question 20
ప్రశ్న 20
A byte-addressable computer has 20 address lines and can generate every possible address represented by those 20 bits. What is the directly addressable memory space?
Explanation:
• Twenty address bits provide 2^20 distinct addresses.
• With byte addressing, each address identifies one byte, giving 2^20 bytes.
• 2^20 bytes equals 1 MiB.
• With byte addressing, each address identifies one byte, giving 2^20 bytes.
• 2^20 bytes equals 1 MiB.
వివరణ:
Question 21
ప్రశ్న 21
A relational table contains 1,200 rows and 8 columns. Which statement correctly gives its cardinality and degree?
Explanation:
• In relational terminology, cardinality is the number of tuples or rows in a relation.
• Degree is the number of attributes or columns.
• Therefore the table has cardinality 1,200 and degree 8.
• Degree is the number of attributes or columns.
• Therefore the table has cardinality 1,200 and degree 8.
వివరణ:
Question 22
ప్రశ్న 22
Ignoring protocol overhead and assuming 1 byte = 8 bits, how long would an ideal 80 Mbit/s link take to transfer a 100 MB file when MB and Mbit use the same decimal multiplier?
Explanation:
• A 100 MB file contains 100 × 8 = 800 Mbit under the assumptions stated.
• Transfer time = data size ÷ data rate = 800 Mbit ÷ 80 Mbit/s.
• The ideal transfer time is therefore 10 seconds.
• Transfer time = data size ÷ data rate = 800 Mbit ÷ 80 Mbit/s.
• The ideal transfer time is therefore 10 seconds.
వివరణ:
Question 23
ప్రశ్న 23
Which statement about RAID and backup is technically correct?
Explanation:
• Redundant RAID levels can keep a system operating after certain member-drive failures.
• RAID does not inherently protect against accidental deletion, corruption, ransomware, theft or loss of the entire array.
• Independent backup copies are therefore still required for proper data protection.
• RAID does not inherently protect against accidental deletion, corruption, ransomware, theft or loss of the entire array.
• Independent backup copies are therefore still required for proper data protection.
వివరణ:
Question 24
ప్రశ్న 24
Which statement correctly distinguishes encryption from authentication?
Explanation:
• Encryption transforms data cryptographically to protect confidentiality from unauthorized disclosure.
• Authentication provides assurance about the identity of a user, device or other entity.
• Authorization is a separate concept that determines what an authenticated entity is permitted to do.
• Authentication provides assurance about the identity of a user, device or other entity.
• Authorization is a separate concept that determines what an authenticated entity is permitted to do.
వివరణ:
Question 25
ప్రశ్న 25
Eight 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 8 nodes: 8 × 7 ÷ 2 = 28.
• Division by 2 prevents each pair from being counted twice.
• For 8 nodes: 8 × 7 ÷ 2 = 28.
• Division by 2 prevents each pair from being counted twice.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: C. 8 GiB సమాధానం: C.
-
Question 2 ప్రశ్న 2Answer: A. 3584 MiB సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: D. 1536 GiB సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. 7.5 GiB సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. 16 TB సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: C. 18 TB సమాధానం: C.
-
Question 7 ప్రశ్న 7Answer: A. 8 TB సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: D. RAID 6 సమాధానం: D.
-
Question 9 ప్రశ్న 9Answer: C. 6 TB సమాధానం: C.
-
Question 10 ప్రశ్న 10Answer: B. 20 సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: A. 79 సమాధానం: A.
-
Question 12 ప్రశ్న 12Answer: D. 204 సమాధానం: D.
-
Question 13 ప్రశ్న 13Answer: B. FAIL సమాధానం: B.
-
Question 14 ప్రశ్న 14Answer: C. 2 సమాధానం: C.
-
Question 15 ప్రశ్న 15Answer: D. 500 సమాధానం: D.
-
Question 16 ప్రశ్న 16Answer: A. $D$5 సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: C. =$B6+E$2 సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: B. -12.35 సమాధానం: B.
-
Question 19 ప్రశ్న 19Answer: D. 5 సమాధానం: D.
-
Question 20 ప్రశ్న 20Answer: A. 1 MiB సమాధానం: A.
-
Question 21 ప్రశ్న 21Answer: B. Cardinality = 1,200; Degree = 8 సమాధానం: B.
-
Question 22 ప్రశ్న 22Answer: D. 10 seconds సమాధానం: D.
-
Question 23 ప్రశ్న 23Answer: C. RAID redundancy can improve availability after certain drive failures, but it does not replace independent backups. సమాధానం: C.
-
Question 24 ప్రశ్న 24Answer: A. Encryption primarily protects data confidentiality, while authentication establishes confidence in a claimed identity. సమాధానం: A.
-
Question 25 ప్రశ్న 25Answer: B. 28 సమాధానం: B.
