Sybase Quiz :: 1 - Quiz & Trivia

1. When a create procedure command is successfully executed, the procedure's name is stored in sysobjects, and its source text is stored in syscomments.

True

False

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

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.

2. What is the Sybase function to remove spaces from a string?

REMOVE

RPAD and LPAD

RTRIM and LTRIM

None of Above

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.

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.

3. Can Index be created on temp tables?

Yes

No

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

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.

4. Which of the following datatype cannot be defined as NULL?

Char

Varchar

Bit

Datetime

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 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.

5. Which of the following command will be used for execute a stored procedure on a remote Adaptive Server?

Exec server_name.[database_name].[owner].procedure_name

Execute server_name.[database_name].[owner].procedure_name

Server_name.[database_name].[owner].procedure_name

All of above

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

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.