Multiple Programming Languages Quiz

In PL/SQL, user-defined exceptions are raised using the RAISE statement. The EXCEPTION keyword is used in the exception declaration section (EXCEPTION_INIT pragma links error codes to exceptions) and in the exception handling block (BEGIN...EXCEPTION...END). To actually raise a user-defined exception, you must declare it, then use RAISE exception_name.

The for loop runs from 1 to 4. continue skips remaining code in the current iteration, but since it's at the end of the loop body, it has no effect. Each iteration prints its number: 1, 2, 3, 4 → output: 1234.

Float 0.7 is stored as 0.699999... due to binary representation. Literal 0.7 in the if condition becomes double (more precise). Comparison: 0.699999 < 0.700000 → true, so c++ prints. This demonstrates floating-point precision issues.

char * const ptr means ptr is const (can't change what it points to). Trying to reassign ptr = xyz is illegal - compile error. The pointer itself is locked even though the data it points to isn't.

const char *ptr means the data is const (can't change what ptr points to), but ptr itself can be reassigned. ptr = xyz works because we're changing where ptr points, not modifying abc. Output: xyz.

In C, local variables (including those declared with the register storage class) are not automatically initialized. Reading an uninitialized local variable results in undefined behavior, which typically prints whatever garbage value happens to be in that register or memory location.

In SAS, double trailing @@ in an INPUT statement holds the current data line in the input buffer, allowing multiple INPUT statements to read data from the same line. This enables reading multiple observations from a single data line, which is the practical use case.

The PUT function always returns a character value. The format specified is ddmmyy10., which has a width of 10 characters. Therefore, the resulting variable DATE is created as a character variable with a length of 10 bytes.

In SAS, a sum statement (variable + expression) automatically retains the variable and handles missing values. Option B 'totquantity + quantity;' is the correct sum statement syntax. Options A and D use incorrect syntax or unnecessary retain statements, while C has invalid syntax.

In SAS, when you merge datasets and write to a dataset with the same name and library as an input dataset, SAS creates a NEW temporary version in the WORK library first. Since temp.sales is being created in the temp library, it becomes a permanent dataset in that library. The program executes successfully.

The IF-ELSE structure executes sequentially. Since amount is initialized to 7, the condition 'amount = 5' is false, but 'amount = 7' is true, so word becomes 'DOG'. The later assignment 'amount = 5' only changes the amount variable, not word. The final values are amount=5 and word='DOG'.

In SAS, an array is a temporary grouping of variables defined only for the duration of the current DATA step. The array name itself does not exist as a variable, is not saved in the output dataset, and cannot be referenced in subsequent procedures.

The ARRAY statement defines an array named 'agent' containing 4 character variables of length 7, which are SALES1 through SALES4 (indicated by sales1-sales4). The output dataset contains the original variables SALES1-SALES4, not variables named AGENT.

The PRINT procedure displays only the actual data values stored in the data portion of a SAS data set. The descriptor portion contains metadata like variable names, types, and labels, which PROC PRINT uses to format output but does not report as content.

The INPUT statement expects name, age, and height to be separated by spaces, but the raw data has 'John McCloskey' (two words for name) causing misalignment. SAS reads 'McCloskey' as age=35 and 'June' as height=71, then rejects the first observation because age 35 is not LE 10. The remaining data is misaligned causing read errors, so no valid dataset is created.

The FIRSTOBS=75 option starts reading at observation 75, and OBS=499 reads through observation 499. Since SAS counts inclusively, observations 75 through 499 give 499-75+1 = 425 observations. The SET statement reads from an existing dataset, so the dataset size of 1000 is irrelevant.

The DATE9. informat reads dates in the format DDMMMYY (like 07JAN2002). DDMMMYY9. and DDMMYYYYYYY9. are not valid SAS informats. The standard SAS date informat for two-digit day, three-letter month abbreviation, and two or four-digit year is DATE9.

In PowerBuilder, the Modify() method is used to dynamically alter the properties of a DataWindow object at runtime, including modifying its SQL query. There are no standard PowerBuilder functions named ModifyQuery(), Change(), or ChangeQuery() for this purpose.

PowerBuilder Datawindow buffers are Primary!, Delete!, and Filter! buffers. The Original! buffer contains the originally retrieved data. Sort! is not a standard Datawindow buffer type - sorting is handled through the Datawindow's sort properties, not a dedicated buffer.

SetTrans() pools database connections by sharing a single connection among multiple Datawindows, releasing it after each transaction. This is efficient when connections are limited. SetTransObject() maintains a dedicated connection per Datawindow, which is more efficient for frequent database access but uses more connections.