GeekInterview.com
  I am new, Sign me up!
 

Sybase Interview Questions


Sybase Interview Questions

Questions: 64
Comments: 144
 Sybase Tags
 Showing Questions 11-20 of 64 Questions
<< Previous 1 [2] 3 4 5 6 7 Next >>
 Sponsored Links

 
 Sybase Interview Questions
Sorting Options :  

What is Locking in Sybase? What are its types? 
Latest Answer: Sybase does support locking at row level in version 12.5 onwards.Sybase use locking in below modes- Shared- Exclusive- UpdateFor APL(all page locking), sybase locks data as well index pageFor DOL(data only locks) either row level or data page level, sybase ...

Latest Answer: Rowid function is not supported in ASE, it's only supported in Sybase IQ ...
Read Answers (3) | Asked by : sudipbis

Explain What is Update Statistics? 
Latest Answer: ASE uses two system tables for maintaining stats on tables for obtimized query and data retrival.systabstats is used on table level and is maintained dynamically while sysstatistics maintains information on columns and is not maintained.Update statistcis ...

Latest Answer: Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for  building result ...
Read Answers (1) | Asked by : hari

Latest Answer: When you install Adaptive Server, it has single default data cache, with a 2K memory pool, one cache partition and a single spinlock. To improve performance you can add data caches and bind databases or database objects to them.use "sp_bindcache" ...
Read Answers (1) | Asked by : srinath

Latest Answer: @@errorlog will display the path of log file ...
Read Answers (2) | Asked by : Aarthy SK

Latest Answer: Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]}) ...
Read Answers (2) | Asked by : srihari

How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum
Read Answers (3) | Asked by : Bob

Latest Answer: 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 of using autosys w.r.t crontab is that it is has a Java ...
Read Answers (2) | Asked by : srihari

Latest Answer: Although there are numerous differences, probably the most relevant was the introduction of data-only (pages, row level) locking for tables in 12.x. That was the biggest one that shook up the Sybase community.UDB offers some nice tools not available in ...
Read Answers (1) | Asked by : ganesh Prasad

View page << Previous 1 [2] 3 4 5 6 7 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape