GeekInterview.com
  I am new, Sign me up!
 

Sybase Interview Questions


Sybase Interview Questions

Questions: 64
Comments: 144
 Sybase Tags
 Showing Questions 31-40 of 64 Questions
<< Previous 1 2 3 [4] 5 6 7 Next >>
 Sponsored Links

 
 Sybase Interview Questions
Sorting Options :  

Latest Answer: The data that are fetched by the SQL (select statement) is completely fetched from the index itself is called index covering.Example:-- TableA has 10 columns Col1, Col2, Col3, Col4, Col5...-- An index idx_TableA on TableA has composite non-clustered index ...
Read Answers (2) | Asked by : Keerthana

Latest Answer: Set rowcount 1Select col_name from table_name order by col_name desc ...
Read Answers (4) | Asked by : aruna

Latest Answer: You can execute the stored procedure sp_who , this will give you process id which is blocking what. This is more usefull since sometimes user doesn't have restricted permission for master database. ...
Read Answers (2) | Asked by : srihari

Latest Answer: Deferred update is donewhen the updated row does not fit in the same pagewhen the updated row needs to change information on the index pagewhen there is a subquery in the table joinwhen the update happens to the primary key which is being referenced by ...
Read Answers (2) | Asked by : keerthv

Latest Answer: 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 the inaccurate results shown by optimizer. This concept ...
Read Answers (1) | Asked by : keerthv

Latest Answer: use gosp_helpgoORuse goselect name,type from sysobjectsgo ...

Latest Answer: 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. ...

Latest Answer: 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 deleted in Sybase is entered and go is entered which results ...
Read Answers (1) | Asked by : Robert

Latest Answer: 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 of sorting and resorting as required for maintenance ...
Read Answers (1) | Asked by : Robert

Latest Answer: The minimum table size is equal to 1 extent (that is equal to 8 pages). ...
Read Answers (1) | Asked by : Robert

View page << Previous 1 2 3 [4] 5 6 7 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape