Search Previous Year Questions

The correct answer is : option 4

Key Points 

Step 1: Understand the Base

Since the number system uses digits 0, 1, and 2, it is a base-3 (ternary) number system.

Step 2: Convert 222₃ to Decimal

222₃ = 2×3² + 2×3¹ + 2×3⁰ = 2×9 + 2×3 + 2×1 = 18 + 6 + 2 = 26₁₀

Step 3: Convert 26₁₀ to Binary

To convert 26 to binary, divide by 2 repeatedly:

26 ÷ 2 = 13, remainder = 0 13 ÷ 2 = 6, remainder = 1 6 ÷ 2 = 3, remainder = 0 3 ÷ 2 = 1, remainder = 1 1 ÷ 2 = 0, remainder = 1

→ Binary = read remainders bottom to top = 11010

✅ Final Answer: 11010

✔ Correct Option: Option 4) 11010

The correct answer is Adds up cell values based on a condition

Key Points

• SUMIF Function: ✅ The SUMIF function in Microsoft Excel adds the values in a range that meet a specified condition (criteria). It combines the summing and conditional logic in one function.
• Adds All Numbers: ❌ The function to add all the numbers in a range of cells without conditions is called SUM, not SUMIF.
• Returns a Subtotal: ❌ The function that returns a subtotal in a list or database is called SUBTOTAL, not SUMIF.

Additional Information

• Syntax: The syntax for SUMIF is =SUMIF(range, criteria, [sum_range]), where:
• Range: The range of cells to evaluate for the condition.
• Criteria: The condition to be applied (e.g., ">=10").
• Sum_range (optional): The range of cells to sum if the condition is met. If omitted, Excel sums the cells in the range.
• Example: =SUMIF(A1:A10,">10",B1:B10) adds the values in B1:B10 where the corresponding cells in A1:A10 are greater than 10.
• Common Applications: The SUMIF function is widely used for financial analysis, sales reports, inventory management, and other scenarios where conditional summation is needed.

Hence, the correct answer is: option 1) Adds up cell values based on a condition

The correct answer is Option 1

Key Points

• Instruction Fetch Cycle: During the instruction fetch cycle, the CPU retrieves an instruction from memory to execute it. The sequence of operations is crucial to ensure that the correct instruction is fetched and loaded into the Instruction Register (IR).
• Correct Sequence: The correct sequence is as follows:

1. Program Counter (PC) → Memory Address Register (MAR): The address of the next instruction, stored in the Program Counter (PC), is loaded into the Memory Address Register (MAR).
2. MAR → Memory: The memory address in the MAR is used to access the corresponding memory location.
3. Memory → Memory Data Register (MDR): The instruction at the specified memory location is read and loaded into the Memory Data Register (MDR).
4. MDR → Instruction Register (IR): The instruction in the MDR is transferred to the Instruction Register (IR) for decoding and execution.

• Option 1: This option correctly specifies the sequence: PC → MAR → Memory → MDR → IR.

Additional Information

• Other options are incorrect because:
• Option 2: It skips the MAR (Memory Address Register), which is essential for addressing memory locations.
• Option 3: It directly transfers data from Memory to the IR, skipping MDR, which is not valid in modern CPU architectures.
• Option 4: It skips the MDR, which is required to temporarily hold the instruction before loading it into the IR.

Hence, the correct answer is: Option 1

The correct answer is option 2

Key Points

• The command #find /root -name test* is used in Linux to search for files and directories within the /root directory that begin with the name "test".
• The find command searches recursively through the specified directory and its subdirectories.
• The -name flag specifies the name pattern to match. In this case, test* matches all files or directories starting with "test".
• The escape character \ ensures that the wildcard * is treated as part of the pattern rather than being expanded by the shell.

Additional Information

• Command Breakdown:
• #find: The main command used to locate files or directories.
• /root: Specifies the directory to search within.
• -name: Indicates that the search will filter based on file or directory names.
• test*: Matches all names starting with "test" followed by any additional characters.
• Use Case: This command is useful for locating specific files or directories in a given directory structure.

Correct Answer: option 2) To find all files and directory names that begins with test in root directory

The correct answer is Section diagram

Key Points

• Use Case Diagram: ✅ A valid UML diagram used to describe interactions between users and the system.
• Section Diagram: ❌ This is not a valid UML diagram. "Section diagram" is not recognized in UML standards.
• Object Diagram: ✅ A valid UML diagram that represents instances of classes at a specific point in time.
• Class Diagram: ✅ A valid UML diagram used to represent the structure of a system by showing its classes, attributes, methods, and relationships.

Additional Information

• UML Diagrams: Unified Modeling Language (UML) is a standardized modeling language used to visualize the design of a system. Common UML diagrams include Use Case Diagram, Class Diagram, Object Diagram, Sequence Diagram, Activity Diagram, etc.
• Invalid Diagram: "Section diagram" is not part of the UML specification and does not exist as a recognized diagram type.

Hence, the correct answer is: option 2) Section diagram

The correct answer is Option 2

Key Points

• A view can be created as read-only: ✅ This statement is correct. Views can be created as read-only to restrict users from making changes to the underlying data.
• A view cannot have an ORDER BY clause in the SELECT statement: ❌ This statement is incorrect. Views can include an ORDER BY clause if used with a TOP or OFFSET-FETCH clause. However, in standard SQL, the ORDER BY in a view is not guaranteed to affect the ordering of the rows when the view is queried.
• A view can be created as a join on two or more tables: ✅ This statement is correct. Views can be created by joining multiple tables to combine their data into a single virtual table.
• None of the above: ❌ This is not the correct answer because one of the options (Option 2) is incorrect.

Additional Information

• View: A view is a virtual table derived from a SQL query. It does not store data physically but presents the result of a query.
• ORDER BY Clause: While the ORDER BY clause is commonly used in SQL queries, its behavior in views depends on the context in which the view is used. It may not always guarantee row order unless explicitly specified in the query that references the view.
• Read-Only Views: Views can be created with restrictions (e.g., no INSERT, UPDATE, or DELETE operations) to enforce read-only access.

Hence, the correct answer is: Option 2: A view cannot have an ORDER BY clause in the SELECT statement.

The correct answer is option 2) 64K

Key Points

• FFFF is a hexadecimal number.
• Hex FFFF = Binary 1111 1111 1111 1111
• This is a 16-bit address → Total number of memory locations = 2¹⁶ = 65536
• 65536 bytes = 64K bytes (where 1K = 1024)
• So if the last address is FFFF, the memory size is 64K

Additional Information

• Hexadecimal FFFF = 65535 (in decimal)
• Addressing starts from 0000 to FFFF → total = 65536 addresses = 64 KB
• Common in systems with 16-bit addressing like Intel 8085

Hence, the correct answer is: option 2) 64K

The correct answer is option 1) * and ?

Key Points

• *** (asterisk):** Represents any number of characters.

Example: ma* will match "map", "man", "market", etc.

• ? (question mark): Represents any single character.

Example: m?n will match "man", "men", "min", etc.

• These wildcards are commonly used in functions like COUNTIF, SEARCH, FILTER, and VLOOKUP in Excel.

Additional Information

• Incorrect options:
• < and >: These are comparison operators, not wildcards.
• ^ and /: These are used in formulas but not as wildcards.
• + and -: These are arithmetic operators.
• Wildcard characters are especially helpful when filtering or performing partial matches in large datasets.

Hence, the correct answer is: option 1) * and ?

The correct answer is option 1) 1023

Key Points

• Given: We need to construct a 2¹⁰ = 1024-input multiplexer using only 2-input multiplexers.
• Concept: A 2-input multiplexer selects 1 out of 2 inputs.
• To select from 1024 inputs, we need a complete binary tree structure where each 2-input multiplexer combines 2 inputs at each level.
• The total number of 2-input multiplexers required to build a multiplexer for n inputs is:

n − 1 (This is a standard result from tree structures.)

Here, n = 1024 ⇒ Total 2-input MUXes required = 1024 − 1 = 1023

Additional Information

• A 2ⁿ-input MUX selects one of 2ⁿ inputs based on n selection lines.
• Using 2-input MUXes, you build a binary tree of selection stages to reduce all inputs down to one output.
• So for 1024 inputs, we combine pairs step-by-step until we reach 1 final output.

Hence, the correct answer is: option 1) 1023

The correct answer is option 1) = A1 + A2

Key Points

• In Excel, all formulas start with an = sign.
• To add the values of two cells (like A1 and A2), we use:

= A1 + A2

• This will compute the sum of the contents of cells A1 and A2 and display the result in the cell where you entered the formula.

Additional Information

• Incorrect options:
• = Add(A1 + A2): ❌ Invalid syntax in Excel.
• = together(A1 : A2): ❌ No such function in Excel.
• A1 plus A2: ❌ Not recognized as a formula.
• You can also use =SUM(A1:A2) to add a range of cells, but for two cells, = A1 + A2 is direct and correct.

Hence, the correct answer is: option 1) = A1 + A2