Programming Languages: Java, VBA, and SQL

In EJB Container-Managed Persistence (CMP), the ejbCreate() method must return null (or the primary key type, but per the EJB specification, the container manages primary key generation/mapping and CMP bean's ejbCreate() returns null so the container can initialize the primary key). The Home Object and Remote Object are client-side references, not returned by bean lifecycle methods.

An abstract method in Java is declared with the abstract keyword and has no method body (just a semicolon). Option C shows correct syntax. Option A has a body (not abstract), B is incomplete, D has invalid syntax.

When a new window is opened via JavaScript from a JSP page, session cookies are passed to the new window if it's within the same domain. This means the existing HTTP session remains valid and accessible in the new window. Option A is incorrect because sessions do persist across window opens. Option C is incorrect because a new session is not automatically created.

In Java, to make a class runnable as a thread, you implement the Runnable interface which contains the run() method. This is the preferred way over extending the Thread class because it allows your class to extend another class if needed. Option A is incorrect because Thread is a class, not an interface you implement.

Alt+F11 is the universal shortcut to open the Visual Basic Editor across Microsoft Office applications including Word. Option A correctly describes this shortcut (Function 11 = F11). The other options use incorrect key combinations.

The View Macro command (or Macros > View Macros) displays the list of available macros in the application, allowing users to see, run, edit, or organize them. This is standard functionality across Office applications.

F5 is the standard shortcut key to run a macro in Microsoft Office applications when the macro is selected or in the VBA editor. This shortcut executes the currently selected macro or the macro code where the cursor is positioned.

In Microsoft Excel or VBA development environments, the standard shortcut key to interrupt or stop execution of a running macro is Ctrl + Break. The other combinations do not trigger the macro execution halt.

Macro development tools including the Visual Basic Editor, Macros dialog, and recording features are located in the Developer tab in Microsoft Office applications. This tab must be enabled through Office Options as it's hidden by default.

The Developer tab in Microsoft Office is hidden by default. To enable it, you navigate through Office Button > Excel Options > Popular > Show Developer tab in the Ribbon (or File > Options > Customize Ribbon in newer versions). This path correctly describes how to access the setting.

Macro security settings are accessed through Office Button > Excel Options > Trust Center > Macro Settings. This is where users configure how macros are handled - enable all, disable with notifications, or disable completely. Option D shows the correct navigation path.

VBA project protection is configured through VBAProject > Project Properties > Protection tab. Here you can set a password that prevents unauthorized viewing or editing of the VBA code. Option C correctly identifies the Protection tab as the location for password protection.

The Workbook_Open() event is automatically triggered when you open an Excel workbook, making the statement true. This is a built-in VBA event handler that runs code whenever the workbook is opened.

Workbook_Open() defaults to Private scope in the ThisWorkbook module, meaning it can only be called from within that module, not from outside. Private is the default access modifier for procedures in class modules like ThisWorkbook.

Hash tables index and store objects using key-value pairs where keys are hashed to determine storage location, enabling O(1) average lookup, insert, and delete operations. Vectors use sequential indexing, linked lists use node references, and enumerations provide sequential access without direct indexing. Only hash tables provide dictionary-style key-based object storage.

JDBC supports both two-tier and three-tier models. Two-tier has the application directly connected to the database, while three-tier introduces middleware between application and database for better management.

A stored procedure is a precompiled collection of SQL statements stored in the database that performs a specific task. It can accept parameters and return results, improving performance by reducing network traffic.

A linked list is highly efficient for inserting or removing elements in the middle of a collection because it only requires updating node pointers. Arrays and Vectors require shifting subsequent elements, and hashtables map key-value pairs rather than ordered positions.

A Set is a collection that cannot contain duplicate elements and does not maintain any specific order (like HashSet). Unlike Lists which allow duplicates and preserve order, Sets enforce uniqueness.

The servlet lifecycle follows init() for initialization, service() for processing requests, and destroy() for cleanup. The service() method is called repeatedly for each request until the servlet is destroyed.