- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Sybase Interview Questions & Answers - Learning Mode

Sybase Interview Questions & Answers - Learning Mode

Sybase is a computer software company that develops and sells database management system (DBMS) and middleware products. The company was founded in 1984, and the headquarters offices are in Emeryville, CA. Sybase was the first enterprise DBMS for the Linux operating system. Sybase is an enterprise software and services company that produces software to manage and analyze information in relational databases. Sybase is a standalone subsidiary of SAP.

Try Sybase Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Sybase Interview Questions & Answers - Learning Mode
Try Sybase Interview Questions & Answers - Exam Mode
Question: How to clear tempdb when the tempdb gets filled?

Answer: Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]}) Source:
Question: How can you change to get the decimal separator as comma instead of the decimal point (.)?

Answer: Use stuff(convert(varchar,qty),charindex(".",convert(varchar,qty)),1,",") Source:
Question: What are the vital features of Sybase?

Answer: Absolutely there are numerous features but most important are as follows

1. Manages User Connection
2. Enforces Business Rules
3. Provide Recovery and BackUps
4. Understand T-SQL
5. Optimize Query Execution
6. Maintain Databases with NO Redundancy
7. Supports Data and Referential Integrity

many more.... Source:
Question: What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase?

Answer: Coalesce is also available in Sybase
This functions evaluates the listed expressions and returns the first non-null value. If all the expressions are null, coalesce returns null

USAGE: coalesce(expression, expression [, expression]...)

EXAMPLE: coalesce(initialqty,finalqty,middleqty)

Returns the first occurrence of a non-NULL value in either the initialqty or finalqty or middleqty Source:
Question: How to view the log files in sybase

Answer: cd $SYBASE/$SYBASE_ASE/install Source:
Question: What is procedure cache and data cache?

Answer: Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. <br>Data Cache is the memory area where data that is required for the current queries running is bought from Disk on to memory for building result sets. Source:
Question: Explain the structure of Adaptive server enterprise?

Answer: Structure of ASE installation hosts several databases and it comprises of one data server. Also system files occupy only one meta data. User databases are stored in the form of tables. Security and information privacy can be protected by setting permissions. Source:
Question: In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?

Answer: Yes, it?s possible that we can login to one database with
corresponding user id. Because we can have multiple users
associated to same login, each corresponds to different
database, so
We can login to one database with corresponding user id by
issuing command from command prompt
is : isql ?U_user id ?P_password ?D database_name Source:
Question: State some of the criticism about Sybase IQ?

Answer: Sybase storage systems are optimized for Dataware housing applications where data cannot be modified can be modified by searching and accessing the data.
Its column based search criteria gives high performance for search but it negates the writing capability to the data.
Performance for row based relational based databases is worse because it is very difficult for updating and modifying them. Source:
Question: Explain about Mirror Activator Disk mirroring?

Answer: This software works with storage replication systems and replicates the database to an available ASE or any database back up devices such as oracle. It increases the security of applications and also reduces the fail over time for data applications. Source:
Question: Explain What is Update Statistics?

Answer: The update statistics command helps the server make the best decisions about which indexes to use when it processes a query, by providing information about the distribution of the key values in the indexes. The update statistics commands create statistics, if there are no statistics for a particular column, or replaces existing statistics if they already exist. The statistics are stored in the system tables systabstats and sysstatistics. Source:
Question: What is Sybase system databases?

Answer: When you install Adaptive Server, it contains these system <br>databases:<br><br>The master database controls the user databases and the <br>operation of Adaptive Server as a whole. It stores <br>information about all user databases and their associated <br>database devices.<br><br>The model database is used by Adaptive Server as a template <br>for creating new user databases.<br> A new database cannot be smaller than the model <br&g Source:
Question: State some of the products of Sybase?

Answer: Sybase has worlds leading products some of them are
1. ASE
2. Avantgo
3. Power builder and power designer
4. SQL ianywhere
5. Sybase IQ
6. Sybase replication server
7. Sybase RTE
8. Sybase data federation
9. Main frame connect Source:
Question: Explain about the Sybase group?

Answer: Sybase exclusively focuses on mobilizing and managing information. It is known to be the third largest database

management company after Oracle and IBM. Sybase products on Investment banking are well known to the world over and it offers many customized solutions for business intelligence. Source:
Question: Explain the structure of Adaptive server enterprise?

Answer: Structure of ASE installation hosts several databases and it comprises of one data server. Also system files occupy only one meta data. User databases are stored in the form of tables. Security and information privacy can be protected by setting permissions. Source:
Question: Explain about Enterprise scalability and ROI of Data integration suite?

Answer: Enterprise scalability provides increased capacity without any new addition of hardware. It increases the capacity by increasing the availability in the enterprise data layer.
ROI: - Streamlining of application projects and reducing data management costs, data federation increases ROI. Complexity and superior decision making choices make ROI best in its class. Source:
Question: What is the relationship between JDBC and Sybase?

Answer: 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). Source:
Question: Explain about Sybase 365?

Answer: This product from Sybase is the world leader in messaging services through mobile. It distributes mobile content via MMS, SMS, UMTS and WAP. It process more than 8 billion messages monthly and with this product you have access to enterprise mobility anywhere. Source:
Question: What is the difference in storage type of numeric and decimal data types in sybase?

Answer: The numeric and decimal types
are identical in all respects but one: Only numeric types with a scale of 0
can be used for the IDENTITY column Source:
Question: Explain about Mobile enterprise application enablement?

Answer: Custom based applications for mobiles, existing applications, etc can be brought onto a mobile phone with this suite. It provides core integration, messaging, synchronization, data management of mobile phone, etc. It enables information exchange and transportability between developers and enterprise systems. Source:

1 2 Next

India News Network
Latest 20 Questions
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
"Holiday Packages" announced as an advertisement are an example of _________: (a) Offer (b) Counter Offer (c) Invitation to Offer (d) None of the above
A match fixing contract between a player and a broker is a: (a) Valid Contract (b) Unenforceable Contract (c) Void Contract (d) Illegal Contract
When a bookseller sells a book on cash payment then it is called as ___________: (a) Unilateral Contract (b) Bilateral Contract (c) Executed Contract (d) Executory Contract
____________ agreements are created by situation: (a) Written (b) Oral (c) Void (d) Implied
Cache = 0.109375 Seconds