- 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 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: How to view the log files in sybase

Answer: cd $SYBASE/$SYBASE_ASE/install 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: 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 the features of Sybase IQ?

Answer: Sybase IQ stores data base in the form of columns of data rather in rows. This storage model improves the accessibility and search criteria for the data. Performance of the search criteria improves greatly because it searches only columns rather than the rows and columns of the database. This is also environment friendly. Source:
Question: Explain about Open switch business continuity software?

Answer: Open switch business software helps you to work on the back up system without any hassles making your primary database server secured. It gives you connectivity to the primary database from the secondary server even in the middle of the application. Source:
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: Explain about Power Designer Data modeling software?

Answer: Power designer has two unique tools known as Link and Sync technologies. This technology offers Data base designers to design efficient data models through which one can offer efficient design. Also Data base designers can share resources among them which will improve the productivity and performance. Source:
Question: What is Open Server in Sybase?

Answer: Sybase open server is a vital component of Sybase and Microsoft Open Data Services. The Sybase open server is a major component for handling distributed database systems and thus forms a vital and powerful server side component of Sybase systems. One of the major feature of this is Sybase open server is interoperability. Source:
Question: Explain about ETL data integration software?

Answer: ETL supports data consolidation; it brings data from multiple sources and places it in a single repository. It brings scalable grid architecture for efficient management of data. 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: 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 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: 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: Give the benefits of Data integration suite?

Answer: Some of the benefits which you can get from a Data integration suite are
1) Flexibility: -This suite gives a greater flexibility to incorporate data from various sources such as web, file systems, etc and it can transfer this data to third party applications such as SQL, production systems, etc. 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: 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: Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

Answer: create temporary table with same table structure and then create unique index on this temporary table with option ignore_dup_row.

now insert data into temp table from the table in which duplicate records exists.

while inserting record into temp table, duplicate rows will get ingored.

Finally temp table will have unique records

select distinct * from table_1 into temp_table_1

truncate table_1

insert into table_1

selec 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:

1 2 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
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
Cache = 0.03125 Seconds