Computer — All MCQs
4795 questions available
Q4681.What type of code is written by programmers in human-readable programming languages before being compiled?
Correct Answer: A
Source code consists of statements written by programmers in high-level languages. It is translated by compilers into executable machine/object code.
Q4682.Which of the following is widely recognized as the industry-standard software for professional raster graphics editing and photo manipulation?
Correct Answer: A
Adobe Photoshop is the most widely used software for professional photo editing, image manipulation, and digital painting.
Q4683.Which technology is utilized by optical disk drives (such as CD and DVD players) to read and write digital data?
Correct Answer: A
Compact Discs (CDs) use low-power laser beams in optical drives to detect microscopic pits and lands on the reflective disc surface.
Q4684.In the Ruby programming language, what is the correct syntax used to define a new method?
Correct Answer: A
In Ruby, methods are defined using the 'def' keyword, followed by the method name, and ended with the 'end' keyword.
Q4685.What is a fundamental difference in characteristics between JavaScript and Java?
Correct Answer: D
JavaScript is a prototype-based scripting language where functions are first-class citizens (values), whereas Java is a strictly class-based, statically typed language.
Q4686.Which loop structure is most commonly used in C programming to iterate through an array with a known size?
Correct Answer: C
The 'for' loop is ideal for array iteration because it packs initialization, condition checking, and index incrementing into a single line.
Q4687.In rapid software prototyping, which programming tools are most commonly used to quickly build mockups?
Correct Answer: C
4GLs (Fourth-Generation Languages) are highly visual, database-oriented, and high-level, making them perfect for generating rapid prototypes.
Q4688.Which of the following magnetic materials exhibits the lowest relative magnetic permeability?
Correct Answer: A
Diamagnetic materials create an opposing magnetic field in response to an external field, resulting in a relative permeability slightly less than 1.
Q4689.What is the maximum positive value that can be stored in a standard 32-bit signed 'int' data type in C++?
Correct Answer: B
A signed 32-bit integer ranges from -2,147,483,648 to 2,147,483,647 (which is 2^31 - 1).
Q4690.In an intrinsic (pure) semiconductor at thermal equilibrium, how does the number of free electrons compare to the number of holes?
Correct Answer: A
In pure (intrinsic) semiconductors, free electrons are generated only by thermal excitation of valence electrons, leaving behind an equal number of holes.
Q4691.When installing PCI Network Interface Cards (NICs), how can you check or configure the IRQ availability?
Correct Answer: C
For PCI and modern Plug-and-Play devices, IRQ assignments and hardware resources are managed dynamically by the system BIOS/UEFI.
Q4692.In computer database systems, how is client-side software communication standardly established with a MySQL server?
Correct Answer: C
MySQL operates on a client-server architecture. Clients establish communication with the server by making network calls (TCP/IP socket connections).
Q4693.Which SQL command statement is used to permanently delete one or more columns from an existing table?
Correct Answer: C
The correct SQL syntax is ALTER TABLE followed by the table name, and then the DROP COLUMN clause with the column name.
Q4694.What is the primary focus of structural design methodology in software engineering?
Correct Answer: C
The incorrect statement is Option C. Data flow representation is the primary advantage of Data Flow Diagrams (DFDs) used in Structured Analysis, whereas Structural Design focuses on module hierarchies.
Q4695.Which SQL operator is used to test a column for the absence of data (representing an empty field)?
Correct Answer: B
The IS NULL operator is used to identify fields that do not contain any data or are empty in a relational database table.
Q4696.What is the primary purpose of utilizing a Scatter Plot in Exploratory Data Analysis (EDA)?
Correct Answer: B
Scatter plots display data points on a coordinate grid, helping researchers identify patterns, correlations, clusters, or outliers between two continuous variables.
Q4697.Which Artificial Intelligence concept allows computer systems to handle vague, imprecise, or non-binary information in a way that mimics human intuition?
Correct Answer: C
Fuzzy logic allows computers to evaluate partial truths (values between 0 and 1) rather than strictly binary true/false values, modeling human-like decision-making.
Q4698.Which fixed database role in Microsoft SQL Server has the authority to add or remove user IDs and manage database access?
Correct Answer: B
The db_accessadmin fixed database role is responsible for managing user access and security permissions within SQL Server.
Q4699.Why is the following SQL statement erroneous? 'SELECT dept_name, ID, avg(salary) FROM instructor GROUP BY dept_name;'
Correct Answer: A
When using aggregate functions (such as avg), all non-aggregated columns listed in the SELECT clause (like ID) must be explicitly specified in the GROUP BY clause.
Q4700.What core components must a standard microcontroller integrate on a single semiconductor chip at a minimum?
Correct Answer: D
A microcontroller is a compact integrated circuit containing a CPU, volatile RAM, non-volatile ROM/Flash, input/output ports, and timers on a single chip.