.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 22 23 24 25 26 27 28 29 30 31 32 … > >>   Sort: Rank

Explain all parts of a deployment diagram
Explain all parts of a deployment diagram? Package: It logically groups element of a UML model. Node: A physical system which represents a processing resource, example PC or a host machine. Component: It’s the actual implementation or physical module of a UML system. Node instance: It’s a runtime ph... 2007-10-26, 7311👍, 0💬

Explain Component diagrams
Explain Component diagrams ? Package: It logically make group of element of a UML model. Component: It’s the actual implementation or physical module of a UML system. Node: A physical system which represents a processing resource, example PC or a host machine. InterFace :It specifies the externally ... 2007-10-26, 5311👍, 0💬

Explain Different elements of a collaboration diagram
Explain Different elements of a collaboration diagram ? Classifier Role :It classifies a role.br> Association Role : It shows the relation between two classifier roles.br> Multi-Object : It used to show operation related to entire set of objects rather than on a single object.br> Constraint : Condit... 2007-10-26, 5901👍, 0💬

Give a small brief explanation of all Elements in activity diagrams
Give a small brief explanation of all Elements in activity diagrams? Action State : It is a type of state that has an internal action and one outgoing event that would complete the internal action. State : It is a condition when following events occur: Object satisfies a condition. performs a action... 2007-10-26, 5896👍, 0💬

How did you implement UML in your project PART II
How did you implement UML in your project ? PART II Implementation phase / Coding phase (Class diagrams for reverse engineering, Other diagrams for validity check) In this phase mostly class diagrams are re-engineered with the source code. But other diagrams are also present for validity check examp... 2007-10-26, 7661👍, 0💬

How did you implement UML in your project PART I
What is the sequence of UML diagrams in project? First let me say some fact about this question, you can not implement all the nine diagrams given by UML in one project; you can but can be very rare scenario. The way UML is implemented in project varies from project to project and company to company... 2007-10-26, 7650👍, 0💬

What is Modeling and why UML ?
What are advantages of using UML? As the name suggest UNIFIED MODELING LANGUAGE. Modelling has been around for years, not only in software field but also in other trades like civil, mechanical etc. Example in civil engineering drawing the main architecture built of diagram is a model by itself. Mode... 2007-10-26, 5434👍, 0💬

Explain in short all types of diagrams in UML
How many types of diagrams are there in UML ? There are nine types of diagrams in UML : Use case diagram: They describe "WHAT" of a system rather than "HOW" the system does it.They are used to identify the primary elements and processes that form the system. The primary elements are termed as "actor... 2007-10-26, 6025👍, 0💬

What is UML
What is UML? The Unified Modeling Language (UML) is a graphical language for visualizing, specifying, constructing, and documenting the artifacts of a software-intensive system.UML provides blue prints for business process, System function, programming language statements, database schemas and reusa... 2007-10-26, 4876👍, 0💬

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Following are some major differences between a stored procedure and user defined functions: UDF can be executed using the “SELECT” clause while SP’s can not be. UDF can not be used in XML FOR clause but SP’s can b... 2007-10-25, 6020👍, 0💬

What is SQl injection
What is SQl injection ? It is a Form of attack on a database-driven Web site in which the attacker executes unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall. SQL injection attacks are used to steal information from a databas... 2007-10-25, 5651👍, 0💬

If we have multiple AFTER Triggers on table how can we define the sequence of the triggers
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ? If a table has multiple AFTER triggers, then you can specify which trigger should be executed first and which trigger should be executed last using the stored procedure sp_settriggerorder. All the other trig... 2007-10-25, 7752👍, 0💬

What are the different types of triggers in SQl SERVER 2000
What are the different types of triggers in SQl SERVER 2000 ? There are two types of triggers : INSTEAD OF triggers INSTEAD OF triggers fire in place of the triggering action. For example, if an INSTEAD OF UPDATE trigger exists on the Sales table and an UPDATE statement is executed against the Sales... 2007-10-25, 5284👍, 0💬

What is BCP utility in SQL SERVER
What is BCP utility in SQL SERVER ? BCP (Bulk Copy Program) is a command line utility by which you can import and export large amounts of data in and out of SQL SERVER database. Below is a sample which shows BCP in action. 2007-10-25, 6251👍, 0💬

What are the different types of replication supported by SQL SERVER
What are the different types of replication supported by SQL SERVER ? There are three types of replication supported by SQL SERVER Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The ... 2007-10-25, 5522👍, 0💬

What is the purpose of Replication
What is the purpose of Replication ? Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber. Publisher Database server that makes data available for replication is called as Publisher. Subscriber Database Serve... 2007-10-25, 7148👍, 0💬

What is DBCC
What is DBCC? DBCC (Database Consistency Checker Commands) is used to check logical and physical consistency of database structure.DBCC statements can fix and detect problems.They are grouped in to four categories Maintenance commands like DBCC DBREINDEX , DBCC DBREPAR etc , they are mainly used for... 2007-10-25, 5885👍, 0💬

What is ACID fundamental? What are transactions in SQL SERVER
What is ACID fundamental? What are transactions in SQL SERVER ? A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ACID (Atomicity, Consistency, Isolation, and Durability) properties, to qualify as a t... 2007-10-25, 5616👍, 0💬

How can you raise custom errors from stored procedure
How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement c... 2007-10-25, 6840👍, 0💬

What is the difference between UNION and UNION ALL SQL syntax
What is the difference between UNION and UNION ALL SQL syntax ? UNION SQL syntax is used to select information from two tables. But it selects only distinct records from both the table, while UNION ALL selects all records from both the tables. Note : Selected records should have same datatype or els... 2007-10-25, 5116👍, 0💬

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. 2007-10-25, 5168👍, 0💬

What are advantages of SQL 2000 over SQl 7.0
What are advantages of SQL 2000 over SQl 7.0 ? User-Defined Functions: User-Defined Functions (UDFs) -- one or more Transact-SQL statements can be used to encapsulate code for reuse. Userdefined functions cannot make a permanent change to the data or modify database tables. UDF can change only local... 2007-10-25, 5136👍, 0💬

What are the different ways of moving data between databases in SQL Server
What are the different ways of moving data between databases in SQL Server? There are lots of option available; you have to choose your option depending upon your requirements. Some of the options you have are: BACKUP/RESTORE, detaching and attaching databases, replication, DTS, BCP, logshipping, IN... 2007-10-25, 4884👍, 0💬

What is LOCK escalation
What is LOCK escalation? Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Serve... 2007-10-25, 5177👍, 0💬

<< < … 22 23 24 25 26 27 28 29 30 31 32 … > >>   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML