Computer Software Operations

Alt + Print Screen captures only the active window (the window currently in focus) to the clipboard, not the entire screen. The regular Print Screen key captures the entire desktop. Shift + Print Screen has no standard function in Windows.

Ctrl + Esc is the keyboard shortcut that opens the Windows Start menu. This is equivalent to clicking the Start button or pressing the Windows key. Alt + Esc cycles through windows in reverse order, and Ctrl + Tab switches between applications within some interfaces.

Pressing the Ctrl key along with the numeric keypad's + key in Windows Explorer's Details view automatically resizes all columns to fit their longest content. Other combinations like Ctrl + F2 or Alt + + do not perform this action, making them incorrect distractors.

Cursor variables (REF CURSOR types) in Oracle PL/SQL have 4 attributes: %ISOPEN, %FOUND, %NOTFOUND, and %ROWCOUNT. These attributes provide information about the cursor's state. The statement claims there are 4 attributes, which is correct for cursor variables (though note: implicit cursors have additional attributes like %BULK_ROWCOUNT and %BULK_EXCEPTIONS, but for cursor variables specifically, there are 4 main attributes).

Win+Tab opens Task View in Windows 10/11, showing all open windows in a visual interface. You can cycle through them with arrow keys or Tab, but pressing Enter is required to switch to the selected window, unlike Alt+Tab which switches immediately on each press. Option A is incorrect because Alt+Tab switches directly without a confirm step.

Pressing Win + D first minimizes all open windows, showing the desktop; pressing it again restores the windows to their previous state. Thus both “Minimises all windows” and “Unminimises all windows” describe its behavior, while the other options do not.

Win+M minimizes all open application windows to the taskbar while leaving dialog boxes (modal windows) open and visible. This is distinct from Win+D which shows the desktop by minimizing everything including dialogs. Option A incorrectly states it minimizes dialogs too. Option B incorrectly says it only minimizes dialogs.

In relational databases like DB2, when a parent view is dropped, any views that depend on it are not automatically deleted but are instead marked as "inoperative" (or invalid), meaning they cannot be used until they are recreated or regenerated.

X locks (exclusive locks) provide the most restrictive locking mode in DB2. An X lock allows only the lock owner to access the table - all other applications are blocked from any access. The UR (Uncommitted Read) isolation level allows dirty reads, but even UR applications cannot read a table locked exclusively by another transaction. The question specifically identifies X lock as preventing concurrent access while making a narrow exception for UR-level readers.

DB2 AVI Extenders is the IBM product specifically designed for storing and managing image data within DB2 databases. It provides specialized data types and functions for image storage, retrieval, and manipulation. Net.Data is a web development environment, Net Search is not a DB2 storage product, and XML Extenders and Text Extenders handle their respective data types rather than image data.

CTRL+F6 switches to the next workbook window when multiple Excel workbooks are open. This is the standard keyboard shortcut in Excel for cycling through open workbook windows.

CTRL+SHIFT+F6 switches to the previous workbook window when multiple Excel workbooks are open. The SHIFT modifier reverses the direction, going to the previous window instead of the next.