Class 9 Cyber Olympiad - Sample question paper 03
Posted by Olympiad Tester on
Q) Select the CORRECT match of built-in functions and their results with respect to Visual Basic.
A. Print Int (– 4.6) = –5
B. Print Round (5.7856, 2) = 5.78
C. Print InStr ("Information Technology", "tio") = 3
D. All of these
Answer: A. Print Int (– 4.6) = –5
Explanation: In Visual Basic, the Int function is used to round a number down to the nearest integer. In this case, Int(–4.6) would result in –5, as it rounds the negative decimal value down to the nearest integer, which is –5.
Q) Identify the correct statement with respect to GUI system?
A. It uses computer’s graphics capabilities to make the program easier to use.
B. You need to type a command to perform any task.
C. You cannot run programs by means of mouse clicking.
D. It does not enable the user to toggle through multiple programs and folders at the same time.
Correct Answer: A. It uses computer’s graphics capabilities to make the program easier to use.
Explanation: GUI (Graphical User Interface) systems use graphics, icons, and visual indicators to facilitate user interaction with software. This makes the programs more user-friendly and accessible.
Q) What is the keyboard shortcut to move to the beginning of a document in MS-Word?
A. Alt + Home
B. Ctrl + Home
C. Alt + Ctrl + Home
D. Ctrl + Shift + Home
Answer: C. Alt + Ctrl + Home
Explanation: The keyboard shortcut Alt + Ctrl + Home is used to move to the beginning of a document in MS-Word.
Q) Which of the following devices has been used in this situation? - Imagine that a MicroChip is tagged under the skin of a pet, so that when the tag is activated it sends data to a central database, thus allowing the identification of the lost pet.
A. Radio Frequency Identification Reader
B. Near Field Communication
C. Optical Character Recognition
D. Speech Synthesizer
Answer: A. Radio Frequency Identification Reader
Explanation: Radio Frequency Identification (RFID) Readers are commonly used for tracking and identifying objects, including pets with microchip implants.
Q) What term is used to describe the assembly of hardware devices within vehicles to deliver entertainment and information content?
A. Transport in Embedded Device
B. Planar Entertainment
C. Embedded Entertainment
D. In-Vehicle Infotainment
Correct Answer: D. In-Vehicle Infotainment
Explanation: In-Vehicle Infotainment (IVI) systems refer to the integration of hardware devices in vehicles to provide entertainment and information services.
Q) Arjun has selected a cell range and performed an operation on it. After the successful execution of the applied operation, a dialog box got displayed - "2 duplicate values found and removed. 5 Unique values remain." Which of the following types of operation has been performed by him in MS-Excel 2010?
A. Sort
B. Filter
C. Deduplicate
D. Concatenate
Correct Answer: C. Deduplicate
Explanation: The displayed dialog box indicates the removal of duplicate values, so Arjun performed a deduplication operation.
Q) Which of the following attributes of <hr> tag specifies a horizontal line that should be rendered in one solid color in an HTML document?
A. Shade
B. Solid
C. Noshade
D. Color
Correct Answer: C. Noshade
Explanation: The "noshade" attribute of the <hr> tag in HTML specifies that the horizontal line should be rendered without a shadow, appearing in one solid color.
Q) Which of the following options of MS-PowerPoint 2010 allows you to include a Microsoft Word document as an object into your presentation, and allows you to edit the inserted document by providing Word commands?
A. Object Insert
B. Word Embed
C. Insert Object
D. Document Link
Answer: C. Insert Object
Q) In computer programming, what is the significance of the "volatile" keyword?
Statement 1: The "volatile" keyword is used to declare variables that cannot be changed after initialization.
Statement 2: It indicates to the compiler that the variable's value may change at any time outside the current scope, helping prevent optimization issues.
A. Only Statement 1
B. Only Statement 2
C. Both Statement 1 and Statement 2
D. Neither Statement 1 nor Statement 2
Answer: B. Only Statement 2
Explanation: The "volatile" keyword is used to indicate to the compiler that a variable's value may change at any time outside the current scope, preventing certain optimizations.
Q) Discuss the concept of multi-threading in the context of computer programming.
Statement 1: Multi-threading allows a program to execute multiple tasks simultaneously by breaking them into smaller threads.
Statement 2: It is a technique that ensures each thread in a program runs exclusively on a separate processor core for optimal performance.
A. Only Statement 1
B. Only Statement 2
C. Both Statement 1 and Statement 2
D. Neither Statement 1 nor Statement 2
Answer: A. Only Statement 1
Explanation: Multi-threading involves the execution of multiple threads concurrently, but it doesn't necessarily require separate processor cores for each thread.
Q) Rahul wants to quickly see the total revenue generated in each quarter from a large dataset in MS-Excel 2010. Which tool would be most helpful for summarizing this information?
A. PivotTable
B. Data Validation
C. Goal Seek
D. Subtotal
Correct Answer: A. PivotTable
Explanation: A PivotTable allows Rahul to quickly summarize and analyze large datasets, making it an effective tool for understanding revenue trends across quarters.
Q) What is the purpose of a "try-catch" block in exception handling?
Statement 1: The "try-catch" block is used to suppress runtime errors and allow the program to continue execution without interruption.
Statement 2: It provides a mechanism to handle exceptions gracefully by catching and handling specific types of errors that may occur during program execution.
A. Only Statement 1
B. Only Statement 2
C. Both Statement 1 and Statement 2
D. Neither Statement 1 nor Statement 2
Answer: B. Only Statement 2
Explanation: The "try-catch" block is used for handling exceptions by catching and handling specific types of errors, promoting robust and fault-tolerant code.
Q) Aman wants to organize his budget in MS-Excel 2010 and keep track of expenses. Which tool would be most useful for creating a visual representation of his spending categories and their proportions?
A. Pie Chart
B. Scatter Plot
C. Bar Graph
D. Line Chart
Correct Answer: A. Pie Chart
Explanation: A Pie Chart is ideal for representing proportions and percentages, making it suitable for displaying different spending categories in a budget.
Q) Which of the following statements holds true about twisted-pair cables?
Statement 1: It is a thin flexible cable in which two conductors of a single circuit are twisted together.
Statement 2: It is less expensive than the other commonly used guided media such as coaxial cable and optical fiber.
A. Only Statement 1
B. Only Statement 2
C. Both Statement 1 and Statement 2
D. Neither Statement 1 nor Statement 2
Answer: C. Both Statement 1 and Statement 2
Explanation: Twisted-pair cables consist of two conductors twisted together and are generally less expensive compared to coaxial cables and optical fibers.
Q) Riya has a large dataset containing information about sales in her store. She wants to quickly identify and analyze the top 10% of sales figures. Which feature in MS-Excel 2010 can help her achieve this?
A. PivotTable
B. VLOOKUP
C. Conditional Formatting
D. AutoFilter
Correct Answer: C. Conditional Formatting
Explanation: Conditional Formatting allows Riya to highlight or visually emphasize the top 10% of sales figures based on specified criteria.