+ 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: Yomi Tauzilkree
Country: Saint Kitts and Nevis
Language: English (Spanish)
Genre: Life
Published (Last): 19 April 2012
Pages: 44
PDF File Size: 3.32 Mb
ePub File Size: 9.85 Mb
ISBN: 115-6-46613-308-6
Downloads: 49968
Price: Free* [*Free Regsitration Required]
Uploader: Fegore

During in-house testing we have seen writes go down as much as. For Table to be in Third normal form, a non-key field cannot depend answdrs another non-key field. This should be done using cronjobs.

How is it helping in performance enhance? How can we find the culprit spid which is badly used the log segment of tempdb? In a similar fashion, any user logins can be individually bound to specific temporary databases. If not dva first gets it created. There are two types of Sybsystemprocs. This database can be added to the. How do check the current running processes? Note that an application does not have to anseers to take advantage of this new feature.

How can we get the compression level information from the dump files? What is function string? If this is not possible due to the size of your databases, then try the different options so that the end of, say, a week, you’ve run them all. 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. All this can be done without having to bring down ASE or. So it is not a production practice.

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

answes Placing a table on one segment and its non-clustered index on another segment causes the reads and writes to be faster. How do I pipe the output of isql to a file in Sybase?

Server user ID of the creator of login or login profile. It’s better to work with them than against them. Till then Happy Sybase Learning!

If possible, use index covering. Some query make tempdb filling up intervjew and that make situation by which temp DB can full,very quickly. If the database corrupted, then we can repair through dbcc dbrepair.

You have to use your expertise and experience to answer to the point based on your environment. You may want to create a script to perform these commands: Is there any disadvantage of splitting up your application data into a number of different databases?

Click here for instructions on how to enable JavaScript in your browser. Establishing a password and login policy. After that, the server will automatically shut down; restart it and see if your application databases are still there.

Sybase Interview Questions & Answers

Bulk copy cannot be performed on temporary tables. A heap table is a table with no clustered index. DBAs can bind any user login as well.

This means fewer context switches and a lighter load on the log or data devices, resulting. Whichever method you choose, don’t mix ‘m, as the precedence rules are complicated. What happens when non-clustered index was created?

Top + Sybase Interview Questions – Best Sybase Interview Questions and Answers | Wisdom Jobs

Subqueries and aggregates with group by also cause some activity in tempdb. There are also some questions the candidate might want to ask before s he takes the job see the end of this page.

Intervied recovery with wuestions transaction logs in sybase it’s termed suicide recovery If the dataserver crashes after an uncommitted transaction is written to the log but before the transaction completes, recovery upon startup reads the log and ensures that no uncommittedchanges are reflected in the database by rolling back the changes.

To turn off the secondary truncation point in the database named Parts: If the rows inserted or updated are out of criteria then it fails questtions gives error message. So for that, end user must have valid permission on the object.

What command helps you to know the process running on this port, but only su can run this command? Ans–a you can use holdlock at the end of the query.

It’s much better to run this type of query during a specified interval.

Data cache, procedure cache, engines. The rules for First Normal Form are: Which feature of ASE The RepAgent periodically updates the secondary truncation point to reflect transactions successfully passed to the Replication Server.

Sybbase about Mirror Activator Disk mirroring? For example, to see if the secondary truncation point is set in the Parts database: Suppose we have a join order as below in our query.