Programming Languages and Concepts: SAS, SQL, and Object-Oriented Design

In SAS, informats specify instructions for reading raw data from external files or input streams and converting them into internal numeric or character variables. Formats, conversely, are used for writing or displaying values. Options indicating dropping variables or writing values are incorrect tasks for informats.

SAS stores dates and times as numeric variables, specifically as the number of days since January 1, 1960 for dates, and seconds since midnight for times. This allows date and time arithmetic to be performed as numeric calculations. They are stored as numbers but displayed using formats.

In Object-Oriented Programming, the binding between data and the operations that can be performed on it is described as 'syntactic' because it follows the syntax rules of the language. This close binding is a fundamental characteristic of OOP languages.

When programmers work with classes and objects, they create code that 'manipulates' objects: changing their state, calling their methods, and using their properties. The sentence describes the active control programmers exercise over object instances.

Early literature on OOP often 'touted' (promoted or praised as a major advantage) that objects map naturally to real-world objects. 'Touted' means highlighted or recommended enthusiastically, which fits the context of promoting OOP benefits.

The sentence states that object mapping encourages thinking in the problem domain rather than 'abstract' computer science terms. This means focusing on concrete, domain-specific concepts instead of theoretical computing abstractions.

The sentence describes 'surrogate' objects, objects that stand in for or represent real-world objects in the system. A surrogate acts as a substitute or placeholder, representing real-world entities at just the surface level of the design.

The sentence warns that if you only use objects to reflect the real world, you 'leave' yourself with a lot of work. The complexity lies underneath the surface in code handling business rules, algorithms, and other computer science concerns that real-world modeling doesn't address.

Changes in tightly coupled systems 'ripple' throughout, like waves spreading outward. Loose coupling prevents this by restricting interfaces between subsystems. The ripple metaphor describes how one change causes cascading effects across the system.

Cohesion refers to how elements within a subsystem form a unified concept. Strong cohesion means all elements work together toward a single purpose, improving comprehension and code reliability. It's a key principle in software design alongside coupling.

Object-Oriented languages support quality 'attributes' (characteristics like cohesion and loose coupling) if programmers take the time to pursue them in their design. Attributes are the qualities or characteristics that make code maintainable and reliable.

The sentence states that OO language authors 'feel' the need to distinguish their language by creating new terminology. This suggests they experience a compulsion or sense of necessity to differentiate their work through vocabulary rather than technical innovation.

The SQL concatenation operator || joins multiple column values into a single result column. This query combines name, age, and address with comma separators, creating exactly one output column named 'emp_details'. The number of source columns concatenated doesn't affect the result column count.

Accessing a row by its physical address (ROWID) is the fastest access path in Oracle. It allows Oracle to locate the row directly on disk in a single read. Other methods like index lookups or primary key access require searching the index structure first to find the ROWID.

The TRUNCATE command is a DDL statement that removes all rows from a table immediately. Because it is DDL, it commits automatically and does not write individual row deletes to the rollback segment, making it faster than DELETE. DROP deletes the table structure entirely.

SUBSTR extracts a portion of a string by specifying start position and length. INSTR returns the position of a substring within a string. While SUBSTRING exists in some SQL dialects (SQL Server), SUBSTR is the standard function in Oracle, MySQL, and PostgreSQL. POS is not a standard SQL character function.

The MAX function can operate on any standard datatype (numeric, character, or date/time). Functions like TO_CHAR require specific input types (typically numeric or date), LOWER operates only on character data, and CEIL works exclusively with numeric values.

In SAS, when using the WEIGHT option in PROC MEANS, any observation with a missing weight value is automatically excluded from the statistical calculations. The statement is therefore true.

In PROC MEANS, the analysis variable (VAR) contains the numeric values to aggregate (Salary here), while the CLASS variable defines groups (Gender here). Statistics specified apply to the analysis variable within each classification group. Option A correctly places Salary as VAR and Gender as CLASS.

PROC MEANS default statistics are N (count), MEAN, STD (standard deviation), MIN, and MAX. SUM is NOT calculated by default - you must explicitly specify it in the PROC MEANS statement. Therefore D (SUM) is the correct answer as the 'NOT default' option.