+ 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?.
|Published (Last):||6 September 2016|
|PDF File Size:||7.49 Mb|
|ePub File Size:||2.85 Mb|
|Price:||Free* [*Free Regsitration Required]|
Log suicide is highly risky, and is not recommended except in extreme cases. How do I turn off marked suspect on my database in Sybase? Intervisw is difference between varchar and char?
Sybase Blog -Anything About Sybase ASE,REP,IQ.
As you add indexes or make other changes to your database that affect its statistics, your compiled stored procedures and triggers may lose efficiency. What are the differences between Batch and Procedure? In all other cases, use either datapages or allpages locking.
Need assistance in job search? What do you do when the server can’t start due to a corrupt master sybase dba interview questions and answers What is the default group offered by sybase?
The data is calculated when you execute a query on one of intervieew monitoring. Thresholds are created only on segments, not on devices or databases.
What are the different types of shells? When a transaction acquire exclusive lockno other transaction can acquire exclusive lock. What is an Index? What is the diffrence between Warm standby and table level replication? By default it routes the user to master database if default database has not been defined at the time of questionz creation.
What are the main advantages and disadvantages of using identity columns? How can we sync the logins from prod to uat server, how many tables we need take care for the login sync?
Premium members can enroll in this course at no extra cost. The server user ID suid associated with a group or a role in sysusers is bda equal to sybase dba interview questions and answers negation of their user ID uid.
How can we reduce the spinlock without partioning the data cache? SQL Server has a temporary databasetempdb. Two main performance enhancements in the tempdb feature allow for better throughput and.
Dump the database log. By creating appropriate indexes on tables.
Interview questions for ASE DBAs
Availability is a key requirement on which ASE has always placed utmost importance. What does dump database does and dump tran does? Specifies the kinds of actions that are not permitted while intervieq current transactions execute. Whats the asynchronus prefetch? Data modification transaction wait for release existing shared lock.
A new table into which you load data with bcp in. What are diffrecnt locking scheme in ASE and what are the latches? Check your assigned priviledge.
What are advantage of using triggers? In how many ways we can know the tran details which is causing the thread down?
Reestablish the secondary truncation before restarting a RepAgent. Higher overhead on inserts, if re-org on table is required. Tasks a DBA should do in Sybase How can we find the culprit spid which has filled up th etempdb database? How to implement database security?