+ Sybase Interview Questions and Answers, Question1: How do I tell which tables have Search and apply jobs on Sybase including Sybase DBA, Sybase . Sybase Interview Questions and Answers. Are you a Database Administrator? Need to update DBA technical knowledge or need to prepare for a job interview?. DBA Job Interview Questions and Answers – Tasks a DBA should do in Sybase – Sybase Interview Questions and Answers.

Author: Dutaur Dikus
Country: Montserrat
Language: English (Spanish)
Genre: Health and Food
Published (Last): 19 January 2007
Pages: 267
PDF File Size: 8.76 Mb
ePub File Size: 2.97 Mb
ISBN: 483-6-76077-684-7
Downloads: 51115
Price: Free* [*Free Regsitration Required]
Uploader: Kazitaur

January 27th, at Multiple shared locks can be held on one page; a single shared lock prevents any exclusive lock from being acquired. What will you do to allow nulls interiew a table without specifying the same in a create table statement?

Suppose our temdb is not recovered ,can we create new database? Whta is the archive database? Log in to the primary database. Status of the account.

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

The housekeeper is a task questons becomes active when no other tasks are active. You must be in the parent directory of snapshots and execute the below command. What’s the difference between managing permissions through users and groups or through user-defined roles?


If possible, use index covering.

Sybase Interview Questions & Answers

Comments 4 Trackbacks 0 Leave a comment Trackback. Therefore, this may be an advantage if the amount of data cache is currently a bottleneck. There are 3 types of triggers available with Sybase.

Survey Most Productive year for Staffing: Now configuration Completed, the next step is testing: Without a support contract, you’re completely on your own; you should ask yourself if aanswers can fulfill the company’s expectations in that case. During boot time ASE drops and recreates it. How do I configure Identities in Sybase?

What command you use to change the default value in column b to 5? We have tot 9 compression levels on Sybase, the default compress level is on Sybase is “1”. Index must exist on same segment as table. Will a file containing rows that have negative values for column b be added during a bulk-copy? Without a support contract, you’re completely on your own; you should ask yourself if your can fulfill the company’s expectations in that case.

What is gen id intervirw rep server? It is associated with non-clustered index. When we require log suicide of a DB?

Sybase/Unix Repository: Sybase DBA interview questions/Answers

How to perform bcp out? Provided as a learning tool, pubs2 is the basis of most of the examples in the SQL Server documentation. SQL Server-supplied stored procedures are xnd system procedures. All audit records are written into sysaudits.


Currently you have JavaScript disabled. Is object level recovery possible in ASE? What is my identity burn factor vulnerability right now in Sybase?

Tasks a DBA should do in Sybase

What are the uses of segments? When we use this dbcc command? I personally favor datapages locking as the default lock scheme for all tables because switching to datarows locking is fast and easy, whereas for allpages locking, the entire table has to be converted which may take long for large tables.

What are groups and what are roles? Sizes of the of the workspaces to use D. Two main performance enhancements in the tempdb feature allow for better throughput and.