GeekInterview.com
Series: Subject: Topic:

Sybase Interview Questions

Showing Questions 1 - 20 of 74 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

How is a sybase transaction committed?

Asked By: sripri | Asked On: Apr 4th, 2007

Answered by: Siva Pitchai on: Apr 26th, 2013

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

Answered by: luisgranados on: May 20th, 2011

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

What is autosys? Why do we need to use autosys?

Asked By: srihari | Asked On: Aug 21st, 2007

Answered by: Lokesh Talawar on: Dec 16th, 2011

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

Answered by: rachitkhanna1981 on: Sep 1st, 2009

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

Five hundred eighty two and 71 cents " href="http://www.geekinterview.com/question_details/87471">Sybase ase server display the number value in words

Asked By: David Kelso | Asked On: Nov 21st, 2011

I need to convert a "check amount" to a "written out amount in english", for check printing. ex) $ 582.71 ---> five hundred EIghty two and 71 cents

Sybase stored procedure and triggers

Asked By: mamtasahu | Asked On: Nov 26th, 2009

What is the maximum nesting level of stored procedure and triggers in sybase?

Answered by: neo.sql on: Sep 10th, 2011

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

Answered by: Tejas More on: Jul 7th, 2011

Max nesting level is 16

What is sybase SQL server?

Asked By: Remasri | Asked On: Apr 4th, 2007

Answered by: neo.sql on: Sep 10th, 2011

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

Answered by: luisgranados on: May 20th, 2011

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.

Sybase prefetch

Asked By: keerthv | Asked On: Aug 4th, 2010

What is the significance of the keyword 'prefetch' in SQL queries?

Answered by: Tejas More on: Jul 7th, 2011

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

Add not null column in a table

Asked By: mamtasahu | Asked On: Sep 5th, 2008

How we can add a notnull column in a table by using alter command (without using default command)?

Answered by: Tejas More on: Jul 7th, 2011

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

Answered by: UncaAlby on: Oct 20th, 2008

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.

Views 'with check' option

Asked By: mamtasahu | Asked On: Sep 6th, 2008

What is the use of 'with check' option in views?

Answered by: Tejas More on: Jul 7th, 2011

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

Answered by: dhampack on: Nov 23rd, 2008

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

How to clear the logsegment when the secondary truncation point is on ?

Asked By: srihari | Asked On: Jun 18th, 2007

Answered by: luisgranados on: May 20th, 2011

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

Answered by: dhampack on: Nov 23rd, 2008

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

Database backup

Asked By: srihari_d | Asked On: Mar 2nd, 2010

How will you take database backup when there is no space in file system?

Answered by: luisgranados on: May 20th, 2011

I would dump the database to a removable storage device.

Answered by: rahul20j on: Nov 10th, 2010

Try to take dump on external device...

Secondary truncation point

Asked By: srihari_d | Asked On: Apr 21st, 2010

What is secondary truncation point?

Answered by: luisgranados on: May 20th, 2011

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

How to get the list of tables in sybase?

Asked By: christia | Asked On: Apr 4th, 2007

Star Read Best Answer

Editorial / Best Answer

Answered by: rlbafna

View all answers by rlbafna

Member Since Mar-2008 | Answered On : Mar 12th, 2008

sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"

Answered by: rlbafna on: Mar 12th, 2008

sp_help - lists all objects (including tables and views)

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

Answered by: keerthv on: Apr 21st, 2007

Select name from sysobjects where type="U"

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

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

Asked By: Pat | Asked On: Aug 14th, 2006

Answered by: krishna kanth on: Apr 14th, 2011

set rowcount 1


delete from mytable 
where (select count(*) from Mytable group by col1 having count(*)>1)>1

while(@@rowcount<>0)
delete from mytable 
where (select count(*) from Mytable group by col1 having count(*)>1)>1

set rowcount 0

go 

Answered by: gcvpgeek on: Mar 3rd, 2009

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)

Db space

Asked By: nslk.sap | Asked On: Aug 27th, 2009

How do you check db space and what are the measures available to increase the db space?

Answered by: subind123 on: Mar 4th, 2011

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

Answered by: nagaraju_p on: Sep 9th, 2009

sp_helpdb gives information about memory used and available.

sp_spaceused - gives space used..

Avoid data changes

Asked By: xxx123 | Asked On: Feb 24th, 2011

How to avoid data changes while retrieving data?

Answered by: subind123 on: Mar 3rd, 2011

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.

Query performance tuning

Asked By: nusrafs | Asked On: Aug 27th, 2010

What parameters would you look for while trying to optimise your query? How is the cost of a query measured

Answered by: subi_sybase on: Dec 20th, 2010

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

How to clear tempdb when the tempdb gets filled?

Asked By: srihari | Asked On: Oct 15th, 2007

Answered by: dychandran on: Oct 5th, 2010

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.

Answered by: jaya on: Nov 23rd, 2007

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

Query plan

Asked By: nusrafs | Asked On: Aug 27th, 2010

How does sybase system decide on which plan to use for a query? Can you force a plan to be used by the sybase system

Answered by: thenns75 on: Sep 12th, 2010

Yes, You can use SET FORCEPLAN ON/OFF

Performance tuning

Asked By: nusrafs | Asked On: Aug 27th, 2010

What is the role of page size and data and cache memory in increasing the performance of the query. What other external factors can cause performance issues?

There are 2 tables, employee and department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their...

Asked By: RK | Asked On: Mar 8th, 2006

Answered by: suresh1_saxena on: Aug 6th, 2010

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

Answered by: kevinkpatel99 on: Feb 21st, 2010

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

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.