+ 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: Vudozil Dougar
Country: Antigua & Barbuda
Language: English (Spanish)
Genre: Business
Published (Last): 8 December 2006
Pages: 249
PDF File Size: 20.54 Mb
ePub File Size: 20.76 Mb
ISBN: 544-9-37104-874-9
Downloads: 49647
Price: Free* [*Free Regsitration Required]
Uploader: Disida

If user database log is rapidly filling up, then we dump transaction with truncate options. Size of the named cache to use C. When such applications start running on the same ASE server. What is histogram and what its default step value? Interview Tips 5 ways to be authentic in an interview Tips to help you face your job interview Top 10 commonly asked BPO Interview questions 5 things you should never talk in any job interview Best job interview tips for job seekers 7 Tips to recruit the right candidates in 5 Important interview questions techies fumble most What are avoidable questions in an Interview?

How do I manipulate varbinary columns in Sybase?

How can we refresh a database in the replication enviorment? The default is level 1. By default, every users belongs to a public group and avail all permission for public group. The numbers of rows you are inserting into a table, that many number of times trigger gets fire. How can you configure sybsecurity? What do you do when a segment gets full? SQL Server Tutorial. This allows for load balancing between the users of the default group. There are 3 types of triggers available with Sybase.


Interview questions for ASE DBAs

Update Lock is kind of Exclusive Lock except it can be placed on the row which already have Shared Lock on it. How do I set a password to be null? What is the difference in storage type of numeric and decimal data types in sybase?

You must be in the parent directory of snapshots and execute the below command. A new table into which you load data with bcp in.

There are two types of Sybsystemprocs. On the primary database: Row level, Column Level? You can install one or both of these scripts. Subqueries and aggregates with group by also cause some activity in tempdb. This user must have an account on SQL Server but cannot sba a user in the current database.

Please bear in mind that these are just some suggestions which I personally think are relevant.

Tasks a DBA should do in Sybase

Read our privacy guarantee. Raw partitions or regular files? Explain Different Types Of Constraints? An update operation to any column in wybase view, is not allowed Q Thereby, being a multithreaded application it will call stored procedure multiple times at a time.

The server user ID suid associated with a group or a role in sysusers is not equal to the negation of their user ID uid. Similarly, instead of one log device for tempdb transactions, multiple log devices will substantially. It is associated with clustered index. If s he has, consider that a plus! Data integration suite offers advanced development and management tools. What command helps you to know the process running on this port, but only su can run this command?


Sybase Interview Questions & Answers

What is isolation level in ASE? Sql server displays a message when a deadlock occurs. Make sure that the preceding columns of index are available in search inerview. How do check the current running processes?

Where as Korn shell is superset of Bourne shell. The current data cache hit rate in the cache to which the table is bound. Whichever method you choose, don’t mix ‘m, as the precedence rules are complicated.

Leave This Blank Too: Scene 3 – Make sure there are no table scan on large tables. Suppose a table is partioned based on a coloum, how dataserver will be handle the insert on the table? What is housekeeping task? A collection of SQL statements and optional control-of-flow statements stored under a name. Clustered Indexes dictate the physical order of data. Temp DB can be referred as a workspace for the users to perform operations.

How do you set the sa password? Describe differences between chained mode and unchained mode?

You can tell if a table has identities one of two ways: Sybase IQ stores data base in the form of columns of data rather in rows. If possible, use quedtions covering.