+ 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: Voodookazahn Doujin
Country: Ghana
Language: English (Spanish)
Genre: Video
Published (Last): 17 September 2016
Pages: 11
PDF File Size: 5.71 Mb
ePub File Size: 9.93 Mb
ISBN: 200-6-46552-436-5
Downloads: 83252
Price: Free* [*Free Regsitration Required]
Uploader: Akinomi

I wear a lot of hats Also system files occupy only one meta data.

Are timestamp columns good candidates for primary keys? Update locks — Initial phase of data modification, ASE applies update lock in a data. Adaptive Server applies an intent table lock with each shared or exclusive page or row lock.

All sybase dba interview questions and answers records are written into sysaudits. How can i do that? Given a table which contains sybase dba interview questions and answers rows with duplicate keys, how would you remove the duplicates?

The following example truncates the transaction log for mydb and then dumps the qurstions What is the named data cache, what is buffer pooling and how the cache hit effects the system performance? What is the difference between a primary key and a unique key?


Hows the object level recovery is possible in ASE? Is it possible to concatenate all sybqse values from a column and return a single row? How do you force a transaction to fail? Jobs in Meghalaya Jobs in Shillong.

I will shutdown the server. Explain about ETL data integration software? Asynchronous prefetch can improve performance for: If possible, use index covering. Open a case with Sybase TechSupport.

There is a limit for work tables to Ans ever any database permission to allotted to any rolea entry is made in sysroles table.

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

We have tot 9 compression levels on Sybase, the sybase dba interview questions and answers compress level is on Sybase is “1”. Questions for a candidate DBA to ask your potential future answerz When you’re being interviewed for a DBA vacancy, there are some things related to the DBA environment you might want to know as well. Data cache, procedure cache, engines. If tempdb is completley filled up?

Sybase/Unix Repository: Sybase DBA interview questions/Answers

So it is not a production practice. Explain your education, Family background and work experience. What types of relationships in sybase10? A collection of SQL statements and optional control-of-flow statements stored under a name.

What Are Magic Tables? What are diffrecnt locking scheme in ASE and what are the latches? What are the most important DBA tasks?

Sybase Interview Questions and Answers

Tables, partitions, indexes, stored procedures. What is Replication Server in Sybase? Answfrs, OK, this is a bit of a trick question You use this mode to allow access to the database for problem analysis, to copy out data, and so on. Based on a review of some of the coders questions, you would be better off to avoid them. SQL Server-supplied stored procedures are called system procedures.


The results of our survey Does Sybase support Row Level Locking? Exclusive locks Exclusive lock applies during data modification.

Bypass recovery starts Adaptive Server without recovering one or more databases. What are the main advantages and disadvantages of using identity columns?

Sybase Interview Question

We can complete update the process purpose. Both the growing plan and the limit have been removed since at least version A trigger is a stored procedure bound to a table, which is implicitly executed when a user attempts to modify data with an insert, delete, or update command.

Describe some scenarios that would cause the transaction log to fill up. How to update row by row from the database? What is the local and global indexes?