CoolInterview.com - 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
COOLINTERVIEW.COM DATABASE INTERVIEW QUESTIONS SYBASE INTERVIEW QUESTIONS 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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: How to view the log files in sybase

Answer: cd $SYBASE/$SYBASE_ASE/install Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com

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