Programming and Database Technologies Quiz

The Business Delegate pattern reduces coupling between presentation-tier clients and business services by acting as an intermediary. It hides the complexity of business service lookup and exception handling. MVC is for separation of concerns, Value Objects for data transfer, and DAO for data access.

GET is commonly used to request resources from the server, with parameters often passed in the query string. POST is typically used for submitting user input or data to be processed by the server. While POST can also retrieve resources, GET is primarily associated with resource requests.

The code checks if check4Biz(storeNum) is not null, meaning the method must return a reference type (an object, not a primitive). String is a reference type and can be null. boolean, int, and char are primitive types and cannot be null.

In Java, char is an unsigned 16-bit type with range 0 to 65535. Assigning -1 requires an explicit cast because -1 is outside this range. Without casting, the compiler will reject the assignment.

All wrapper classes in Java are immutable, meaning their values cannot be changed after creation. While all are public and serializable, and most extend Number, the statement about immutability is the correct answer to what IS true (despite the question asking what 'aren't' true).

EXECUTE IMMEDIATE is the statement used to execute dynamic SQL statements that are constructed and executed at runtime. Option A uses static SQL with a host variable. Option C declares a cursor for a prepared statement. Option D has incorrect syntax.

TextArea components support multiple lines of text input, while TextField is designed for single-line input only. Option A correctly identifies this key distinction. Option B is not the primary difference. Option C is false as TextArea is a class. Option D is incorrect as TextAreas display text.

The PROC SQL step contains two statements: the PROC SQL statement and the SELECT statement. The SELECT clause, FROM clause, and ORDER BY clause are all part of the SELECT statement. The question asks for the number of statements, not clauses.

ORDER BY is an optional clause when creating tables and views, used only to sort the result set. Omitting it can improve performance by avoiding unnecessary sorting. WHERE clauses are recommended to limit result sizes. Using joins instead of subqueries is a performance best practice.

The RESET statement in PROC SQL is used to reset specific options or settings, not to add, drop, or change options dynamically. It can reset certain parameters but does not provide the comprehensive option management described in the question.

In PROC SQL, macro variables are created using the INTO clause with a colon prefix. Option C shows the correct syntax: select ... into :daily_fee. Option A uses SYMPUT which is a DATA step function. Option B uses %LET which is not SQL. Option D is missing the colon prefix.

FMTLIB is the PROC FORMAT option used to document formats in a format catalog. It creates a catalog entry that lists all formats and their definitions. FMTSEARCH is for search order, FMTERR controls error handling, and CATALOG is not a valid PROC FORMAT option.

The MODIFY statement cannot modify descriptor information like variable names, labels, or attributes - only data values. Options A and C are false. Option D is incorrect as SAS does not automatically save copies during abnormal termination. Descriptor changes require other statements like RENAME.

The WHERE clause uses 'ge' which is a SAS operator, not a SQL operator. In PROC SQL, the correct operator is '>='. The SELECT and FROM clauses are written correctly with proper syntax for column selection and table reference.

The value 70 falls in the '70-high' range, which uses the '000 Senior' picture format. The 70 replaces the first two zeros, resulting in '70' with 'Senior' label. The format directive specifies 3 digits before the label, so 70 is displayed as '70' (not padded) followed by 'Senior'.

The value 6.1 falls in the '6<-9' range, which means 'greater than 6 and less than 9'. This range maps to 'Good'. The '<-' operator creates an exclusive range (excluding endpoints). Since 6.1 is greater than 6 and less than 9, it returns 'Good'.

In SAS, when PROC TRANSPOSE is executed without a VAR statement, all numeric variables (except those in a BY statement) are transposed. The default output variables generated are _NAME_ and Col1 through ColN corresponding to the transposed observations.

JDBC stands for Java Database Connectivity. It provides a standard API for connecting to relational databases and accessing tabular data from various sources including databases, spreadsheets, and flat files. The other options are incorrect - JDBC is not primarily for bridging object-relational mismatch (that's ORM), nor does it directly handle object or XML data sources as its core purpose.

JDBC classes are distributed across java.sql (core JDBC API) and javax.sql (extensions for DataSource, connection pooling, and rowsets). Options A and B use incorrect package names (java.jdbc doesn't exist). Option D is fabricated - java.rdb and javax.rdb are not standard Java packages.