Sybase Quiz :: 1

Explanation
Yes, an index can be created on temporary tables. Temporary tables are similar to regular tables but are used for storing temporary data within a session or a transaction. Creating indexes on temporary tables can improve the performance of queries that involve those tables, just like indexes on regular tables. However, it is important to note that the indexes on temporary tables are only available within the session or transaction where they were created and are automatically dropped when the session or transaction ends.

Explanation
All of the above options can be used to execute a stored procedure on a remote Adaptive Server. The first option "exec server_name.[database_name].[owner].procedure_name" uses the "exec" keyword to execute the stored procedure. The second option "execute server_name.[database_name].[owner].procedure_name" uses the "execute" keyword to execute the stored procedure. The third option "server_name.[database_name].[owner].procedure_name" directly specifies the server name, database name, owner, and procedure name without any keywords. Therefore, all of these options can be used to execute a stored procedure on a remote Adaptive Server.

Explanation
When a create procedure command is successfully executed, the procedure's name is stored in the sysobjects table, and its source text is stored in the syscomments table. This allows the database to keep track of all the procedures that have been created and their corresponding source code.

Explanation
The datatype "Bit" cannot be defined as NULL because it is a binary data type that can only have two possible values, 0 or 1. It does not have a third state for representing NULL values.

Explanation
The Sybase functions RTRIM and LTRIM are used to remove spaces from a string. RTRIM removes any trailing spaces from the right side of the string, while LTRIM removes any leading spaces from the left side of the string. These functions are commonly used to clean up data by removing unnecessary spaces.