+ 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: Shakak Vodal
Country: Mauritania
Language: English (Spanish)
Genre: Technology
Published (Last): 7 May 2017
Pages: 317
PDF File Size: 12.73 Mb
ePub File Size: 13.9 Mb
ISBN: 189-2-34123-186-9
Downloads: 46053
Price: Free* [*Free Regsitration Required]
Uploader: Zugore

Two-phase commit guarantees that either all or none of the databases in the participating Adaptive Servers are updated.

Specify the minimum password length required server-wide or for a specific login or role. Tell about your work environment? Alternate key is a key which is declared as a second key in composite key.

See the SQL Server installation and configuration guide for information about installing pubs2.

When we require log suicide of a DB? If you want to get a Sybase certification or get a more recent one will they pay for this?

Sybase Interview Question

Just write the name or the index number in the bracket to force the index. Get every solution instantly with premium.

I worked on ASE sybase dba interview questions and answers Suppose our temdb is not recovered ,can we create new database? If there is no procedure in sybsystemprocs by that name, SQL Server looks for the procedure in master.


Below is a sample stored procedure for this. Fixing a Munged Log in Sybase? Now configuration Completed, the next step is testing: Anf physical movement of data occurs at the time of record is deleted.

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

And let me know which you are using in your day to day operations? No; in older Sybase versions 4.

Query and stored proc tuning, available tools and techniques including: What dboption must be true to fix allocation errors on a system table? What are the most important DBA tasks?

The numeric and decimal types are identical in all respects but one: One victim is selected and his process is sybase dba interview questions and answers back. The sybsecurity database contains the audit system for SQL Server.

How can we do the master database replication? How do I make isql secure in Sybase?

Sybase Interview Questions and Answers

For a database with its log on interrview separate device, which of the following dbcc commands show the percentage of free log space? Experts Exchange Solution brought to you by Enjoy your complimentary solution view.

sybase dba interview questions and answers Diff Types Of Triggers? What is the difference between sysstats and systabstats table? How do I interpret the tli strings in the interface file? Whenever we add a user in any databaseit makes entry in sysusers table. In this case user has to ensure two things. Answeds out this collection of Sybase Interview Questions and Answers What is the difference between a primary key and a unique key? Sybase has worlds leading products some of them are.


If tempdb is getting fill? What is update Statistics and how is it useful?

Interview questions for ASE DBAs

Wait is over Now!! If recovery failed due to some corruption, there was no sybase dba interview questions and answers to recover theuncorrupt portion of the database and bring it online. Quewtions Server does not truncate the log past the secondary truncation point. Start the rep cba sybase dba interview questions and answers primary database as below: Granting Permission to Roles: With enhancements to this feature in ASE This tool can be used to see if your caches are performing well and which objects are present in cache.

I feel happy to find a dedicated Sybase ASE blog at last. I have colllected the detail foryou need to find out detail for all the blocking spids.