srihari

• Jul 28th, 2007

Adaptive Server Enterprise is the relational database management software manufactured and sold by Sybase.

Answer Question  Select Best Answer

Som

• Oct 5th, 2006

natural join is basically a form of equi join where one of the join fields is projected out. i.e. it avoids repeatition of the join column. ex:select pub.id,pub.name,au.*from publisher pub, author auw...

Answer Question  Select Best Answer

What is the significance of the keyword 'prefetch' in SQL queries?

Tejas More

 Profile Answers by Tejas More Questions by Tejas More

• Jul 7th, 2011

prefetch improves performance by anticipating the pages required for certain well-defined classes of database activities whose access patterns are predictable. The I/O requests for these pages are iss...

Answer Question  Select Best Answer

How does Sybase system decide on which plan to use for a query? Can you force a plan to be used by the Sybase system

thenns75

 Profile Answers by thenns75 Questions by thenns75

• Sep 13th, 2010

Yes, You can use SET FORCEPLAN ON/OFF

Answer Question  Select Best Answer

GregMark

 Profile Answers by GregMark Questions by GregMark

• May 5th, 2007

Index are handled automatically by Sybase database to speed up the query and in short to optimize the query .But in certain scenarios and situation the user may need to force the index for handling th...

Answer Question  Select Best Answer

christia

 Profile Answers by christia Questions by christia

• May 5th, 2007

Clustered index and Nonclustered indexes are the two type’s index handled by Sybase. In the case of Clustered index the physical and logical order are maintained in the same order by the process...

Answer Question  Select Best Answer

Ganapathi Masilamani

• Jul 5th, 2007

Live table will be created using: 1. Create table ( column name datatype ) 2. Select * into from e-x: select * into new_emp from emp Temp Table will be created using: 1. Create table ...

Answer Question  Select Best Answer

anubhashjain

 Profile Answers by anubhashjain Questions by anubhashjain

• Jun 18th, 2010

Workspaces are special tables in dbccdb that store intermediate results of the dbcc checkstorage operation. Workspaces differ from worktables in that they: --  Are preallocated contiguously ...

Answer Question  Select Best Answer

lakshmi mandava

• May 16th, 2007

Reports on permissions for database objects, users, groups, or roles. 

Answer Question  Select Best Answer

shamimaziz

 Profile Answers by shamimaziz Questions by shamimaziz

• Jul 21st, 2007

Solaris 32-bitSolaris 64-bitHP-UX PA Risc 64-bitIBM AIX 64-bitLinux x86 32-bitWindows x86 32-bitLinux on Power 64-bitLinux Opteron 64-bitSol Opteron 64-bitHP-UX Itanium 64-bit Windows Opteron X64

Answer Question  Select Best Answer

Sushil Kumar

• Jun 23rd, 2007

The minimum table size is equal to 1 extent (that is equal to 8 pages).

Answer Question  Select Best Answer

Reemi

• Apr 10th, 2007

dump tran database to physical name will make of the transaction that have occured against your database since the last transaction log dumpwhen we use dump tran database with truncate_only ,no copy o...

Answer Question  Select Best Answer

JamesMike

 Profile Answers by JamesMike Questions by JamesMike

• May 5th, 2007

The data types supported by Sybase are integer, smallint, tinyint, float, real, double precision, smallmoney, money, decimal, char(n), varchar(n), text, image, datetime, timestamp, timestamp, varbinary(n), binary(n) and bit.

Answer Question  Select Best Answer

santosh

• Apr 25th, 2007

use gosp_helpgoORuse goselect name,type from sysobjectsgo

Answer Question  Select Best Answer

manish hoiyani

• Dec 8th, 2006

If a col of table already had one default,,,  we cannot put any other default  on the same column..... but if is banking system and all we can zero  in place of null.

Answer Question  Select Best Answer

StephenRaj

 Profile Answers by StephenRaj Questions by StephenRaj

• May 5th, 2007

The table in Sybase can be deleted by using the command drop table. The syntax of this command is as below:drop table Then the window waits for entering the table name where the table name to be delet...

Answer Question  Select Best Answer

ssukralia

 Profile Answers by ssukralia Questions by ssukralia

• Dec 3rd, 2007

JDBC is a Application programming Interface which helps Java Developers to interact with Database like Sybase via DML Statements (Insert, Update, Delete and so on).

Answer Question  Select Best Answer

shamimaziz

 Profile Answers by shamimaziz Questions by shamimaziz

• Jul 21st, 2007

Partition is a old technology helps to access data faster (not actually faster) in almost all the databases. Sybase ASE 15.0 opens up a new possiblity of this. Sybase ASE contains semantic Partioning ...

Answer Question  Select Best Answer

amodsv

 Profile Answers by amodsv Questions by amodsv

• Mar 26th, 2008

The numeric and decimal typesare identical in all respects but one: Only numeric types with a scale of 0can be used for the IDENTITY column.

Answer Question  Select Best Answer

Gary C

• Jul 12th, 2007

In pre sybase 15 all database options will take effect after a use database and checkpoint command is run.For Sybase 15 the option take effect immediately since all sp_dboption commands have an automatic checkpoint.

Answer Question  Select Best Answer