Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    28

    Unanswered: Few Sybase Questions...

    Few Sybase Questions...I would need a answer...

    1) What’s the difference between a rollback transaction in a trigger and the same command in a stored procedure?
    2) If you were Bcp’ing some data into a table, and you violated a unique index, how would you find the offending data?
    3) If you were experiencing performance issues, what steps would you take to investigate and resolve the problem?
    4) How can you determine if one process is being blocked by another process? How can you determine which tables are being locked by a process?
    5) What is an ‘update in place’?
    6) What criteria must be achieved to enable a Fast Bcp?
    7) What restrictions are placed on the result set for an update cursor?
    8) How do you determine the last value inserted into an identity column after an insert statement?
    9) How many clustered indexes can you have? And unclustered?


    Thanks in advance
    Deb

  2. #2
    Join Date
    Jun 2003
    Posts
    140

    Re: Few Sybase Questions...

    1) What’s the difference between a rollback transaction in a trigger and the same command in a stored procedure?

    rollback trigger rolls back only the effect of the trigger and thestatement that caused the trigger to fire;
    rollback transaction rolls back the entire transaction.

    2) If you were Bcp’ing some data into a table, and you violated a unique index, how would you find the offending data?
    use -e option to route the error to log file


    3) If you were experiencing performance issues, what steps would you take to investigate and resolve the problem?
    This is debatable question, performance problem can be at applicaiton,database,server,network,os or hardware
    see ASE documentation for performace and tuning


    4) How can you determine if one process is being blocked by another process? How can you determine which tables are being locked by a process?

    for blocking processes
    use sp_who see blk column
    turn "print dead lock information" parameter on by sp_configure
    use sp_object_stats

    determine which tables are being locked
    sp_lock

    5) What is an ‘update in place’?
    A type of direct update operation. An in-place update does not cause data rows to move on the data page.

    6) What criteria must be achieved to enable a Fast Bcp?
    drop all indexes and trigggers before making BCP, but Fast bcp logs only the page allocations its not fully logged

    7) What restrictions are placed on the result set for an update cursor?
    table being updated should have a unique index.
    Cursor's select statement should not have anyof the following cluase
    distinct, group by , Aggregate function,Subquery, union , at isolation read uncommitted clause

    8) How do you determine the last value inserted into an identity column after an insert statement?
    SELECT @@indentity

    9) How many clustered indexes can you have? And unclustered?
    can have only one clustered index per table and 254 nc index (not very sure abt nc check documents )

  3. #3
    Join Date
    May 2002
    Posts
    28

    Thanks Perl

    Thanks Perl for the answers...

    Regards
    Debkumar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •