+ Sybase Interview Questions and Answers, Question1: How do I tell which tables have Search and apply jobs on Sybase including Sybase DBA, Sybase . Sybase DBA Interview Questions. Will it hit the server restart and how? Answer 7 Yes it will impact. SBT can also perform object level recovery. ~ Question 7. Sybase Interview Questions and Answers. Are you a Database Administrator? Need to update DBA technical knowledge or need to prepare for a job interview?.

Author: Arashizshura Brazil
Country: Antigua & Barbuda
Language: English (Spanish)
Genre: Education
Published (Last): 19 February 2005
Pages: 70
PDF File Size: 13.23 Mb
ePub File Size: 5.98 Mb
ISBN: 221-5-89692-156-8
Downloads: 45557
Price: Free* [*Free Regsitration Required]
Uploader: Goltirisar

There’s not answeers you can do yourself with this information, and only TechSupport has the information to determine whether it’s related to a bug, for example.

What is Sypron B. What is switch active?

Truncate only — removes the inactive part of the log without making a backup copy. Which version of ASE are they using, and on which platform? Here are some sample queries to gather information about the behaviour of your caches.

Check the indexes are on proper columns. So for that, end user must have valid permission on the object. Just write the name dbaa the index number in the bracket to force the index. Database recovery with no transaction logs in sybase it’s termed suicide recovery. It is associated with non-clustered index.


Sybase Interview Question

If there is no procedure in sybsystemprocs by that name, Qustions Server looks for the procedure in master. How can i do that? Can we create views on temporary tables? Run dump database at the earliest opportunity to ensure that your data can be recovered.

When we require log suicide of a DB? Adaptive Server applies an intent table lock with each shared or exclusive page or row lock.

How can we configure the dbcc database? What are the isolation levels? Temporary Database as a System Resource.

SAP Sybase BlogSybase DBA Interview Q&A – You Must Know ! – SAP Sybase Blog

The results of our survey Newer Post Older Post Home. Log in to the primary database. December 9th, at As Sybase recommends 4K syybase pool for log usage in 2k page size serverplease let me know the pool recommendtaion for 4K pagesize server?

The temporary database chosen for a session remains in effect for the duration of that session. It should make ‘m happy that you’re willing to get your certification, ‘cos it will make you a better DBA; try to get them to pay for at least part of it.


This applies to normal databases.

Sybase ASE/REP Interview Questions | Sybase Blog -Anything About Sybase ASE,REP,IQ.

Is it a good idea to use datarows locking for all tables by default? What are the different types of shells? With Adaptive Server If tempdb is completley filled up? For instance, suppose two applications are running—one sbase.

Sybase Blog -Anything About Sybase ASE,REP,IQ.

Other transaction wait for releasing existing exclusive lock. Adaptive Server versions Associate a password expiration value with a specified login or role. I’m certainly not claiming that these are the “best” or “most representative” questions you could ask.

When you switch on the statistics io on then you can see APF all page questione.