Multiple choice technology databases

What is the maximum number of characters that can be passed to a stored procedure through a single char or varchar parameter without being truncated?

  1. 127

  2. 255

  3. 16384

  4. equal to the server page size
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Sybase ASE, while column size limits are bound by the database page size, variables and parameters inside stored procedures can support up to the absolute data type limit of 16,384 bytes/characters. The distractors represent obsolete limits or column-specific restrictions.

Keep practicing — related questions