Sybase Interview Questions

Can we add a column in between two columns in sybase when the table has some data?

When you specify the begin tran command, you have to close it with commit tran (if is nested , there must be one commit for each begin)If you don't specify begin tran, the dml statement will be execut...

Autosys is used for defining, scheduling and monitoring jobs. These jobs can be Unix script, java program or any other program which can be invoked from shell.

Regards,
Lokesh Talawar

Autosys is a job scheduling software like Control - M and cron, with the help of autosys we can define the runtime,day,date,week and which script or program needs to be run. The main advantage o...

The default option for maximum nesting level is 16 however this is a server configurable value and can be lesser than this also. To check the current maximum nesting level for stored procedures and tr...

Max nesting level is 16

Sybase SQL Server is the RDBMS developed by Sybase Inc (now an SAP company) which is now called as Sybase Adaptive Server Enterprise is the enterprise version and a flagship product of Sybase. Another...

is the original name for the product we know today as Adaptive Server Enterprise.

Sybase SQL Server name was changed since version 11.5 because they wanted to differentiate the product from Microsoft.

prefetch improves performance by anticipating the pages required for certain well-defined classes of database activities whose access patterns are predictable. The I/O requests for these pages are iss...

You can add a NOT NULL column to a table. This means that a constant expression, and not a null value, is placed in the column when the column is added. This also ensures that, for all existing rows, ...

First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True.

The with check option flag prevents insertion or updating of rows that will not meet the view criteria. e.g.: create view cal_publishers_chk as ...

When you create a view using the with check option clause, each insert and update through the view, is validated against the view’s selection criteria. If the rows inserted or updated are out of cri...

I suppose you want to do that because you refresh the database to a development/QA environment and you no longer need the replication to be working.So you just need to disable the secondary truncation...

There are only two options to clear the log1) Kill the tran which is filling up the log2) Extend the transaction log to complete the transaction.don't use 'dump with truncate_only' if you ...

I would dump the database to a removable storage device.

Try to take dump on external device...

is a mark in the primary db log up to which the replication agent has processed transactions.

sp_help - lists all objects (including tables and views)

List if Views : select name from sysobjects where type = "V"

Select name from sysobjects where type="U"

This gives the list of user defined tables in the current database.

set rowcount 1

We can do remove the duplicate records using the below single query

Delete from table1 where rowid not in (select max(rowid) from table1 group by dup_col)

Measure available to increase the DB space:
1) Drop objects which are no longer used.
2) Run alter database command to increase database size.

sp_helpdb gives information about memory used and available.

sp_spaceused - gives space used..

The retrieval task should be enclosed in a transaction. This will prevent other transaction to modify the data. Make sure the isolation level is at 1.

Do a set showplan oncheck each query and see if any table scan is used....if yes, check if any index is present on tables...if index is not present try adding it....if index is present, determine what...

We may need to identify the Culprit Spid Which is casuing the Tempdb to filled up and confirm about the is that ok to kill it and clear the log.

use dbcc log - Commad to identify the Cuprit Spid.

dbcc log

Purpose: displays transaction log records.

Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]})

Yes, You can use SET FORCEPLAN ON/OFF

The query for this question can be written by using the outer join.

select * from employee a,department b where a.emp_id*=b.emp_id

ANSI Syntax:SELECT Emp.ENAME, Dept.ENAMEFROM Employee Emp left join Department DeptON Emp.DEPTNO = Dept.DEPTNOTransact-SQL Syntax:SELECT Emp.ENAME, Dept.ENAMEFROM Employee Emp, Department DeptWHERE Em...