programming languages Online Quiz - 199

The Program Global Area (PGA) is a memory region that contains data and control information for a single server process. It is non-shared memory specific to each process, unlike the SGA which is shared across all processes. The PGA contains session-specific variables, sort areas, and other process-private data.

A materialized view is a database object that stores the results of a query physically, unlike a regular view which is just a stored query. Materialized views can improve query performance by pre-computing expensive joins and aggregations, and can be refreshed on schedule or on demand.

GACUTIL (Global Assembly Cache Tool) is the command-line utility used to install and uninstall assemblies from the Global Assembly Cache (GAC). The GAC is a shared repository for .NET assemblies that need to be accessed by multiple applications on the same machine.

The .NET Compact Framework is a version of the .NET Framework designed specifically for mobile and resource-constrained devices. Smartclient and Small Framework are not standard Microsoft frameworks for this purpose.

The Controls property of the Control class is a ControlCollection object that holds all child controls added to a parent control. ViewState is for persisting control state across postbacks, StateBag is the internal storage for ViewState, and Collection is a generic .NET class not specific to control hierarchies.

RegularExpressionValidator is designed for pattern-based validation like telephone numbers that follow specific formats. CompareValidator compares one value to another, RangeValidator checks if a value falls within a numeric range, and CustomValidator requires you to write your own validation logic.

SET ROLE is a session control statement that changes the current user's role for the session. SAVEPOINT is a transaction control statement for creating rollback points, ALTER SYSTEM is a DDL command for system-level changes, and EXECUTE runs procedures or PL/SQL blocks.

PASSWORD_VERIFY_FUNCTION is a valid profile parameter that specifies a PL/SQL function to validate password complexity. The other options are either misspelled (LOGIN_FAILED_ATTEMPTS should be FAILED_LOGIN_ATTEMPTS) or not valid profile parameters (CPU_PER_USER is not a standard Oracle profile parameter).

SPFILE (Server Parameter File) is a binary file stored on the server that enables persistent parameter changes. PFILE (Parameter File) is a text-based initialization file. The binary nature of SPFILE allows Oracle to read it more efficiently and make changes that survive restarts.

The WEB-INF directory contains the deployment descriptor (web.xml) and other protected files that should not be directly accessed by clients. The WEB-INF/classes directory holds compiled Java classes, WEB-INF/lib contains JAR libraries, and public_html is not a standard WEB-INF subdirectory.

sendError() and sendStatus() are methods of HttpServletResponse that send HTTP error responses and status codes to the client. HttpServletRequest handles request data, while ServletRequest and ServletResponse are generic interfaces that HttpServlet extends.

The -x option enables execution tracing (xtrace) for debugging, showing commands as they are executed. The -n option reads commands but does not execute them, allowing checking for syntax errors.

vmstat displays summary information about CPU activity, memory, and processes, including CPU utilization. pstat is not standard for CPU utilization, cpustat monitors CPU performance counters, and prstat monitors active processes.

vmstat (virtual memory statistics) is a standard Linux command that reports memory usage, paging, swaps, and CPU activity. vmstats is not a valid command, sar reports system activity data, and prstat is a Solaris-specific command.

The standard fsck command flag to automatically repair the file system without prompting the user is -y (or sometimes -y / -Y depending on the OS flavor). Distractors like p (preen) serve different interactive purposes.

In vi editor, S substitutes the entire line - it deletes the line and enters insert mode. C substitutes from cursor to end of line, A appends text after the cursor, and O opens a new line above the current one.

In vi, ) moves the cursor to the beginning of the next sentence, and ( moves to the beginning of the previous sentence. The { and } keys move by paragraphs, not sentences, so they are incorrect for sentence navigation.

The command to set or report shell resource limits in Unix-like systems is ulimit. However, the option text has a typo ('ulimt'). Since it is the intended choice and the others are completely fictitious, the question is marked as okay, but option 552106 is the correct match.

mailq displays the contents of the mail queue, showing messages waiting to be delivered. mail and mailx are email user agents for reading/sending mail, and mailstats reports mail statistics rather than queue contents.