Sybase ASE
All versions
Last updated: 25 November 2012
ASE Quiz Questions 2012
 
This page contains some quiz-type ASE questions to test your ASE knowledge.


November 2012
You need to test a stored procedure that operates on a text column in a database table.
How can you generate some sizable test data for that column? For example, let's say you want to put 10 MB of data in the text column -- what's the easiest way to do that?

Go here for the answer.

September 2012
If you are a RepServer DBA, you often have various active 'isql' sessions to manage your replication system; for example, you need one connection to each RepServer in the system, another connection for each RSSD, and often one or more for primary or replicate dataservers/databases.
Frankly, sometimes all those sessions drive me crazy. Worse, it can cause wasted time when you find out that things don't work since you've been running your command in the wrong database or the wrong RepServer.

The good news: you can basically do all of this with just a single 'isql' session. Do you know how?

Go here for the answer.

August 2012
As every DBA knows, set showplan on will generate the query plan for a query.
However, recently I ran into a situation where I had enabled showplan, but I didn't get a query plan no matter what I tried.
The queries themselves executed without problem (i.e. the result sets were correctly returned).
It took a while before I had figured it out what was going on.

Any idea what had caused this funny situation?

Go here for the answer.

April 2012
Every ASE DBA knows that ASE's approach to reconstructing a database is based on an initial database dump followed by multiple transaction log dumps.
However, during a recent customer engagement, I found myself making a database dump, only to immediately delete the dump file once the dump was successfully completed. In contrast, the subsequent transaction log dump files were carefully saved since they were needed in case the database needed to be reconstructed.
It is somewhat counterintuitive that the database dump file was no longer needed and could be deleted. Why did I have to make that dump anyway, and why did I delete it immediately after?

Go here for the answer.

February 2012
Last month's quiz question was about -F and -L options of the BCP utility -- specifically, how these do not really help you in performing parallel BCP sessions with the aim of getting higher throughput for copying a table to a file.

As it happens, there is actually a way to achieve better performance BCP-out with parallel BCP sessions, though not with -F and -L.
Do you know how?

Go here for the answer.

January 2012
As you probably know, the BCP utility has two -F and -L which let you specify the first and last row to be copied, respectively (for an example, see the quiz question from April 2007).

Recently a customer asked me why -F and -L didn't provide the scalability he expected when copying rows from a table to a file with multiple parallel BCP sessions. The idea was to use -F and -L to copy out a different portion of the table in each BCP session. However, this did not turn out to provide the performance improvement he was looking for.
Do you know why?

Go here for the answer.


More ASE quiz questions: 2013 - 2012 - 2011 - 2010 - 2009 - 2008 - 2007 - 2006 - 2005 - 2004 - 2003 - 2002 - 2001
For a randomly selected quiz question, click here.


 
 This document is located at www.sypron.nl/quiz2012.html