+ 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):||21 November 2014|
|PDF File Size:||12.16 Mb|
|ePub File Size:||11.97 Mb|
|Price:||Free* [*Free Regsitration Required]|
While locking prevent another processes from accessing process data which some time leading blocking and deadlock. How can we avoid the deadlock in the database? What should qustions do when you find a stacktrace in the server errorlog? In both cases, the speed of copying the data depends on whether there is a suitable index for retrieving the rows.
Sybase dba interview questions and answers is the archive database? How do you BCP only a certain set of rows sybase dba interview questions and answers of a large table? How do you set the sa password? Sybase recommends that you use this command if you think the output of error messages might overflow the error log.
There are optional databases which are sybaze on the requirement of environment. Your syslogins comes from ASE We are getting stack traces for one of our databases? Scenario If an application makes multiple statement and each statement calls to a specific stored procedure. System and Optional Intervied.
Plan to limit this permission to sybase dba interview questions and answers administrators and applications, and to audit their server activity. Open a case with Sybase TechSupport. If s he has, consider that a plus! What are the salient features of In an table level replication setup, we need to alter a coloum, what would be the step for the same? There are 2 types of indexes: Query – How to get current database segment mapping? Cost is calculated beaed on statistics of table and index.
What are the different options avilable with reorg? Two major functions of dbcc are: Describe questionns tables in sybase dba interview questions and answers clause so as the smaller table occurs first and then the larger tables. Whats the difference sgbase dsysnc and direct io?
We only have 10 days left Check out this collection of Sybase Interview Questions and Answers Why place tempdb and log on low numbered devices? The other two links seem to be of higher quality. What is cmaxpktsz good for in Sybase? Multiple transactions inserting in a single table. In the past, extensive use of ansewrs. To enable when you are ready.
Name of database in which to put user when connection established. Questions are from basic level to intermediate queations. How do you get a port number? Users and groups the classic method that has always been there since the first version of Sybase are limited to a single database.
How well the pages of the tables fill questikns extents. Is there any disadvantage of splitting up your application data into a number of different databases? What are the different roles available in sybase? Fast sybase dba interview questions and answers might enhance performance; however, slow bcp gives you greater data recoverability.
Sybase Interview Question
How do you drop a corrupted database? It is often used so that several users can assume the role of Database Owner.
Which optimizer statistics are maintained dynamically? What is proxy authorization?
Sybase Interview Question
Posted by lakshman gupta at I worked as a sybase developer creating SP,trigger,view, LDM modifications So, i am expecting a basic sybase interview questions. Oracle 11g Practice Tests.
The housekeeper is a task that becomes active when no other tasks are active. How to clear a log suspend What is the best value for cschedspins? By continuing to use this website, you agree to their use.