Sybase ASE
All versions
Last updated: 05 October 2003
ASE Quiz Questions 2002
 
This page contains some quiz-type ASE questions to test your ASE knowledge.
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.


December 2002
Is it possible to create a table without a name ?

Click here for the answer.

November 2002
Suppose you're writing some T-SQL code to produce a report. You want the first lines to be formatted like this:
***************
  R E P O R T
***************
What is the least amount of T-SQL code needed to print these three lines ?

Click here for the answer.

October 2002
Each ASE release is identified by an "EBF number" (also called a "SWR number") in its version string. This EBF number is unique, meaning that Sybase TechSupport can tell exactly which functionality (like bug fixes) is included in the specific ASE version you're running.

The question: is it possible that two different ASE executables have the same EBF number ?

Click here for the answer.

September 2002
It is a well-known fact that all objects in an ASE database (tables, procedures, triggers, etc.) have a unique object ID. These object IDs are stored in sysobjects, among other tables.

The question: is it possible that two different objects in the same ASE database actually have the same object ID ?

Click here for the answer.

August 2002
Suppose you want to know when your ASE server was started. How many different ways would you know to determine this ?

Click here for the answer.

July 2002
For most dbcc commands, the 3604 traceflag must be enabled to display any output at the client. However, some dbcc commands don't require the 3604 traceflag; do you know which ones ?

Click here for the answer.

June 2002
Let's use T-SQL to do some math!
How do you calculate a number's factorial, also known as n!, in a single select statement, without using any loops ?
(quick reminder: n! is defined as 1*2* ... *(n-2)*(n-1)*n, for n >= 0. Hence, 5! is 120)

Click here for the answer.

May 2002
You are happily working in an ASE server, but your collegue just can't seem to connect to the server. How do you quickly, and unambiguously, determine the network address (= host + port number) on which the ASE server is listening ?

Click here for the answer.

April 2002
In January 2002, Sybase Inc. has moved its corporate headquarters from Emeryville, CA to a new building in Dublin, CA.
Could this real-world move have any *technical* impact on the work of an ASE DBA ?

Click here for the answer.

March 2002
The following query is really very simple: there's not even a table involved. What is the result of this expression ?
1> select +2*-1*-3+-2--1*+3 
2> go
Click here for the answer.

February 2002
This month's question is about a select statement which looks very, very simple...
Suppose we have the following, very simple table:
1> select a from my_tab
2> go

 a
 -----------
          10
          20
          30

(3 rows affected)
These two queries on this table seem absolutely trivial (and they are!):
1> select a from my_tab where a > 10
2> go

 a
 -----------
          20
          30

(2 rows affected)


1> select sum(a) from my_tab where a > 10
2> go

 -----------
          50

(1 row affected)

Now, here comes the question: how many rows will the following query, which is a combination of the above two queries, return ? Will there be 1, 2 or 3 rows in the result set ?
1> select a, sum(a) from my_tab where a > 10
2> go
Click here for the answer.

January 2002
In ASE 12.5, the server page size can be 2Kb, 4Kb, 8Kb or 16Kb. How can you find out which size your server has been set up with ?

Click 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/quiz2002.html