The file that store data in Sybase is usually called as
Datafile
Device
Data Object
Material
select trim(column_name1),left(column_name2,5),substring(column_name3,2,4) from Table1 - The result of the above statement is
Blank removed Column_name1, first 5 character of column_name2,2 to 4 character part of string from Column_name3
Blank removed Column_name1, last 5 character of column_name2,2 to 4 character part of string from Column_name3
Blank removed Column_name1, first 5 character of column_name2 and 2,3,4,5 character part of string from Column_name3
None of the above
@@sqlstatus can't have any of the below values
1
3
2
Which is not part of "case" keyword in sybase
End case
When
then
which of the below functions are not used in Sybase
Current_date
Datachange
Gettime
Convert
Which one of the below is not related to Cursor
Sensitive
Forward
Fetch
Position
Some of the core sys tables can be updated, true or false
True
False
Which of the following statements is NOT true of local variables?
Their name must begin with @
They are local to the batch or stored procedure where they are declared
They can be declared in a select statement
They cannot have a datatype of text or image
Total no of index in the user tables
250
255
2065
1026
It is possible to create a constraints on the existing tables by creating new column