Explore topic-wise InterviewSolutions in .

They are TWO separate areas of memory in same process. TALKING about Java, stack is used to STORE primitive VALUES and REFERENCE type to object but actual object is always created in heap. One critical difference between heap and stack is that, heap memory is shared by all threads but each thread has their own stack.

They are two separate areas of memory in same process. Talking about Java, stack is used to store primitive values and reference type to object but actual object is always created in heap. One critical difference between heap and stack is that, heap memory is shared by all threads but each thread has their own stack.

DOM parser is a in memory parser so it loads whole XML file in memory and create a DOM tree to parse. SAX parser is a event based parser, so it parses XML document based upon event received e.g. opening tag, closing tag, start of attribute or end of attribute. Because of their working METHODOLOGY, DOM parser is not suitable for LARGE XML file as they will take lot of space in memory and your process may ran out of memory, SAX is the one which should be used to parse large files. For small files, DOM is usually MUCH faster than SAX.

DOM parser is a in memory parser so it loads whole XML file in memory and create a DOM tree to parse. SAX parser is a event based parser, so it parses XML document based upon event received e.g. opening tag, closing tag, start of attribute or end of attribute. Because of their working methodology, DOM parser is not suitable for large XML file as they will take lot of space in memory and your process may ran out of memory, SAX is the one which should be used to parse large files. For small files, DOM is usually much faster than SAX.

CRITICAL SECTION is the part of a code, which is very important and in multi-threading must be exclusively modified by any THREAD. Semaphore or mutex is USED to protect critical section. In JAVA you can use synchronized keyword or ReentrantLock to protect a critical section.

critical section is the part of a code, which is very important and in multi-threading must be exclusively modified by any thread. Semaphore or mutex is used to protect critical section. In Java you can use synchronized keyword or ReentrantLock to protect a critical section.

A class is said to be Immutable if its state cannot be changed once created, for example String in JAVA is immutable. Once you create a String say "Java", you cannot change its content. Any modification in this string e.g. converting into upper CASE, concatenating with another String will result in NEW object. Immutable object are very useful on concurrent programming because they can be shared between multiple threads without worrying about SYNCHRONIZATION. In fact, WHOLE model of functional programming is built on top of Immutable objects.

A class is said to be Immutable if its state cannot be changed once created, for example String in Java is immutable. Once you create a String say "Java", you cannot change its content. Any modification in this string e.g. converting into upper case, concatenating with another String will result in new object. Immutable object are very useful on concurrent programming because they can be shared between multiple threads without worrying about synchronization. In fact, whole model of functional programming is built on top of Immutable objects.

SQL injection is a security vulnerability which allows intruder to steal data from system. Any system which TAKE input from user and create SQL query without validating or sanitizing that input is vulnerable to SQL injection. In such system, intruder can INJECT SQL code instead of data to retrieve more than expected data. There are MANY instances on which sensitive information e.g. user ID, password and personal details are stolen by exploiting this vulnerability. In JAVA, you can avoid SQL injection by using Prepared statement.

SQL injection is a security vulnerability which allows intruder to steal data from system. Any system which take input from user and create SQL query without validating or sanitizing that input is vulnerable to SQL injection. In such system, intruder can inject SQL code instead of data to retrieve more than expected data. There are many instances on which sensitive information e.g. user id, password and personal details are stolen by exploiting this vulnerability. In Java, you can avoid SQL injection by using Prepared statement.

Version control are software which is used to store code and manage VERSIONS of codebase e.g. SVN, CVS, Git, Perforce and ClearCase. They are very effective while comparing code, reviewing code and creating build from previous stable version. All professional development USE some sort of revision or version control tool, without it you cannot mange code effectively, ESPECIALLY if 20 developers are working in same code base at same time. Version control tool plays very important role to keep code base consistent and RESOLVING code conflicts.

Version control are software which is used to store code and manage versions of codebase e.g. SVN, CVS, Git, Perforce and ClearCase. They are very effective while comparing code, reviewing code and creating build from previous stable version. All professional development use some sort of revision or version control tool, without it you cannot mange code effectively, especially if 20 developers are working in same code base at same time. Version control tool plays very important role to keep code base consistent and resolving code conflicts.

Overriding is RESOLVED at runtime while overloading is COMPILE TIME. ALSO rules of overriding and overloading is different, for example in Java, method signature of overloaded method must be different than original method, but in case of overriding it must be exactly same as overriding method.

Overriding is resolved at runtime while overloading is compile time. Also rules of overriding and overloading is different, for example in Java, method signature of overloaded method must be different than original method, but in case of overriding it must be exactly same as overriding method.

A class is a blue print on which OBJECTS are created. A class has code and behavior but an object has state and behavior. You cannot create an object WITHOUT creating a class to REPRESENT its structure. Class is also used to map an object in memory, in JAVA, JVM does that for you.

A class is a blue print on which objects are created. A class has code and behavior but an object has state and behavior. You cannot create an object without creating a class to represent its structure. Class is also used to map an object in memory, in Java, JVM does that for you.

In a strongly typed language COMPILER ENSURE type CORRECTNESS, for EXAMPLE you can not store number in String or vice-versa. Java is a strongly typed language, that's why you have different data types e.g. int, FLOAT, String, char, boolean etc. You can only store compatible values in respective types. On the other hand, weakly typed language don't enforce type checking at compile time and they tree values based upon context. Python and Perl are two popular example of weakly typed programming language, where you can store a numeric string in number type.

In a strongly typed language compiler ensure type correctness, for example you can not store number in String or vice-versa. Java is a strongly typed language, that's why you have different data types e.g. int, float, String, char, boolean etc. You can only store compatible values in respective types. On the other hand, weakly typed language don't enforce type checking at compile time and they tree values based upon context. Python and Perl are two popular example of weakly typed programming language, where you can store a numeric string in number type.

Loose coupling is a desirable quality of software, which allows one part of software to modify WITHOUT affecting other part of software. For example in a loosely coupled software a change in UI LAYOUT should not affect the back-end class STRUCTURE.

Loose coupling is a desirable quality of software, which allows one part of software to modify without affecting other part of software. For example in a loosely coupled software a change in UI layout should not affect the back-end class structure.

Mock object are very useful to TEST an individual unit in your Software, in fact stud and mocks are powerful TOOL for CREATING automated unit TESTS. Suppose you write a program to display currency conversion rates but you don't have a URL to connect to, now if you WANT to test your code, you can use mock objects. In Java world, there are lot of frameworks which can create powerful mock objects for you e.g. Mockito and PowerMock.

Mock object are very useful to test an individual unit in your Software, in fact stud and mocks are powerful tool for creating automated unit tests. Suppose you write a program to display currency conversion rates but you don't have a URL to connect to, now if you want to test your code, you can use mock objects. In Java world, there are lot of frameworks which can create powerful mock objects for you e.g. Mockito and PowerMock.

When you fork a process, the new process will run same CODE as parent process but in different memory space, but when you spawn a new thread in existing process, it just CREATES ANOTHER independent path of execution but share same memory space.

When you fork a process, the new process will run same code as parent process but in different memory space, but when you spawn a new thread in existing process, it just creates another independent path of execution but share same memory space.

unit testing, INTEGRATION testing and smoke testing. Unit testing is used to test individual units to verify whether they are working as expected, integration testing is done to verify whether individually TESTED module can work together or not and smoke testing is a way to test whether most common functionality of software is working properly or not e.g. in a flight booking website, you should be able to BOOK, cancel or CHANGE flights.

unit testing, integration testing and smoke testing. Unit testing is used to test individual units to verify whether they are working as expected, integration testing is done to verify whether individually tested module can work together or not and smoke testing is a way to test whether most common functionality of software is working properly or not e.g. in a flight booking website, you should be able to book, cancel or change flights.

In HashMap it takes O(1) time, in binary tree it takes O(logN) where N is number of nodes in tree and in linked list it takes O(n) time where n is number of element in list. Millions of RECORDS doesn't affect the performance if data structure are working as expected e.g. HashMap has no or relatively less number of collision or binary tree is BALANCED. If that's not the CASE then their performance degrades as number of records GROWS.

In HashMap it takes O(1) time, in binary tree it takes O(logN) where N is number of nodes in tree and in linked list it takes O(n) time where n is number of element in list. Millions of records doesn't affect the performance if data structure are working as expected e.g. HashMap has no or relatively less number of collision or binary tree is balanced. If that's not the case then their performance degrades as number of records grows.

& is a bitwise operator while && is a logical operator. ONE difference between & and && is that bitwise operator (&) can be applied to both integer and boolean but logical operator (&&) can only be applied to boolean variabes. When you do a & b then AND operator is applied to each bit of both integer number, while in case of of a && b , SECOND argument MAY or may not be evaluated, that's why it is also known as short circuit operator, at least in Java. I like this question and OFTEN ASKED it to junior or developer and college graduates.

& is a bitwise operator while && is a logical operator. One difference between & and && is that bitwise operator (&) can be applied to both integer and boolean but logical operator (&&) can only be applied to boolean variabes. When you do a & b then AND operator is applied to each bit of both integer number, while in case of of a && b , second argument may or may not be evaluated, that's why it is also known as short circuit operator, at least in Java. I like this question and often asked it to junior or developer and college graduates.

A VALUE type is more OPTIMIZED type and always immutable e.g. primitive int, long, double and FLOAT in JAVA, while a reference type POINTS to a object, which can be mutable or Immutable. You can also say that value type points to a value while reference type points to an object.

A value type is more optimized type and always immutable e.g. primitive int, long, double and float in Java, while a reference type points to a object, which can be mutable or Immutable. You can also say that value type points to a value while reference type points to an object.

By USING MODULUS operator, number % 10 returns the last digit of the number, for example 2345%10 will return 5 and 567%10 will return 7. Similarly division operator can be used to get RID of last digit of a number e.g. 2345/10 will give 234 and 567/10 will return 56. This is an important technique to know and useful to solve problems LIKE number palindrome or reversing numbers.

By using modulus operator, number % 10 returns the last digit of the number, for example 2345%10 will return 5 and 567%10 will return 7. Similarly division operator can be used to get rid of last digit of a number e.g. 2345/10 will give 234 and 567/10 will return 56. This is an important technique to know and useful to solve problems like number palindrome or reversing numbers.

A well-formed XML is the one which has ROOT element and all TAGS are closed PROPERLY, attributes are defined properly, their value is also quoted properly. On other hand, a valid XML is the one which can be validated against a XSD file or schema. So it's possible for a XML to be well-formed but not valid, because they CONTAIN tags which MAY not be allowed by their schema.

A well-formed XML is the one which has root element and all tags are closed properly, attributes are defined properly, their value is also quoted properly. On other hand, a valid XML is the one which can be validated against a XSD file or schema. So it's possible for a XML to be well-formed but not valid, because they contain tags which may not be allowed by their schema.

Liskov substitution principle is ONE of the five principle introduced by Uncle Bob as SOLID design principles. It's the 'L' in SOLID. Liskov substitution principle asserts that every sub type should be ABLE to work as proxy for parent type.

For example: if a method EXCEPT object of Parent class then it should work as EXPECTED if you PASS an object of Child class. Any class which cannot stand in place of its parent violate LSP or Liskov substitution principle.

Liskov substitution principle is one of the five principle introduced by Uncle Bob as SOLID design principles. It's the 'L' in SOLID. Liskov substitution principle asserts that every sub type should be able to work as proxy for parent type.

For example: if a method except object of Parent class then it should work as expected if you pass an object of Child class. Any class which cannot stand in place of its parent violate LSP or Liskov substitution principle.

A process can have multiple threads but a thread always belongs to a SINGLE process. Two process cannot SHARE memory space until they are purposefully doing inter process communication via shared memory but two threads from same process always share same memory.

A process can have multiple threads but a thread always belongs to a single process. Two process cannot share memory space until they are purposefully doing inter process communication via shared memory but two threads from same process always share same memory.

BINARY search tree is an ordered binary tree, where value of all NODES in left tree are less than or equal to node and values of all nodes in right SUB tree is greater than or equal to node (e.g. root). It's an important data structure and can be used to represent a sorted structure.

Binary search tree is an ordered binary tree, where value of all nodes in left tree are less than or equal to node and values of all nodes in right sub tree is greater than or equal to node (e.g. root). It's an important data structure and can be used to represent a sorted structure.

In SQL, there are mainly two types of joins, inner join and outer join. Again outer joins can be two types RIGHT and left outer join. Main difference between inner join and left join is that in case of former only matching records from both tables are SELECTED while in case of left join, all records from left table is selected in ADDITION to matching records from both tables. Always watch out for queries which has "all" in it, they usually require left join e.g. write sql query to find all DEPARTMENTS and number of employees on it. If you use inner join to solve this query, you will missed empty departments where no one works.

In SQL, there are mainly two types of joins, inner join and outer join. Again outer joins can be two types right and left outer join. Main difference between inner join and left join is that in case of former only matching records from both tables are selected while in case of left join, all records from left table is selected in addition to matching records from both tables. Always watch out for queries which has "all" in it, they usually require left join e.g. write sql query to find all departments and number of employees on it. If you use inner join to solve this query, you will missed empty departments where no one works.

TIME complexity specify the RATIO of time to the input. It shows how much time an algorithm will take to COMPLETE for a given number of input. It's approximated valued but ENOUGH to give you an indication that how your algorithm will PERFORM if number of input is increased from 10 to 10 million.

Time complexity specify the ratio of time to the input. It shows how much time an algorithm will take to complete for a given number of input. It's approximated valued but enough to give you an indication that how your algorithm will perform if number of input is increased from 10 to 10 million.

V stands for View in MVC pattern. View is what user sees e.g. WEB pages. This is a very important design pattern of web development which is based upon segregation of concern, so that each area can be modified without impacting other areas. In Java WORLD, there are lots of OPEN source framework which provides implementation of MVC pattern e.g. Struts 2 and Spring MVC. By the way, M stands for model and C stands for controller. Modes are actual business OBJECTS e.g. User, Employee, Order while controller is used to route REQUEST to correct processor.

V stands for View in MVC pattern. View is what user sees e.g. web pages. This is a very important design pattern of web development which is based upon segregation of concern, so that each area can be modified without impacting other areas. In Java world, there are lots of open source framework which provides implementation of MVC pattern e.g. Struts 2 and Spring MVC. By the way, M stands for model and C stands for controller. Modes are actual business objects e.g. User, Employee, Order while controller is used to route request to correct processor.

LINEAR probing, DOUBLE hashing, and chaining. In linear probing, if bucket is ALREADY OCCUPIED then function check NEXT bucket linearly until it find an empty one, while in chaining, multiple elements are stored in same bucket location.

linear probing, double hashing, and chaining. In linear probing, if bucket is already occupied then function check next bucket linearly until it find an empty one, while in chaining, multiple elements are stored in same bucket location.

ASSOCIATION means two OBJECTS are related to each other but can exists WITHOUT each other, Composition is a form of association where one object is composed of multiple object, but they only exists TOGETHER e.g. human body is composition of organs, individual organs cannot live they only useful in body. Aggregation is collection of object e.g. city is aggregation of CITIZENS.

Association means two objects are related to each other but can exists without each other, Composition is a form of association where one object is composed of multiple object, but they only exists together e.g. human body is composition of organs, individual organs cannot live they only useful in body. Aggregation is collection of object e.g. city is aggregation of citizens.

A STATELESS system is a system which doesn't maintain any internal STATE. Such system will PRODUCE same output for same input at any POINT of time. It's always easier to CODE and optimize a stateless system, so you should always strive for one if possible.

A stateless system is a system which doesn't maintain any internal state. Such system will produce same output for same input at any point of time. It's always easier to code and optimize a stateless system, so you should always strive for one if possible.

Unit testing is way to test individual unit for their functionality instead of testing WHOLE APPLICATION. There are LOT of TOOLS to do the unit testing in different PROGRAMMING language e.g. in Java, you can use JUnit or TestNG to write unit tests. It is often run automatically during build process or in a continuous environment like Jenkins.

Unit testing is way to test individual unit for their functionality instead of testing whole application. There are lot of tools to do the unit testing in different programming language e.g. in Java, you can use JUnit or TestNG to write unit tests. It is often run automatically during build process or in a continuous environment like Jenkins.

You can USE combination of 'ps' and 'grep' command to find any process RUNNING on UNIX machine. Suppose your JAVA process has a name or any text which you can use to match against just use following command.

ps -ef | grep "myJavaApp"

ps -E will LIST every process i.e. process from all user not just you and ps -f will give you full details including PID, which will be required if you want to investigate more or would like to kill this process using kill command.

You can use combination of 'ps' and 'grep' command to find any process running on UNIX machine. Suppose your Java process has a name or any text which you can use to match against just use following command.

ps -ef | grep "myJavaApp"

ps -e will list every process i.e. process from all user not just you and ps -f will give you full details including PID, which will be required if you want to investigate more or would like to kill this process using kill command.

Cascade:

• Cascade process INVOLVES taking VALUES from various other prompts.
• The RESULT is a single report.
• The result is USED when a criteria is to be implemented.

Drill Through:

• Drill Through process is implemented when navigation from summary to detailed information.
• Drill Through has a PARENT and a child report.
• Data of another report can be seen based on the current details of data.

Cascade:

Drill Through:

• Scheduling and executing the batch jobs.
• Configuring, STARTING and stopping the real-time services
• Adapters configuration and managing them.
• Repository USAGE, Job SERVER configuration.
• Access Server configuration.
• Batch job publishing.
• Real-time services publishing through WEB services.

Manual Integration:

• ALSO KNOWN as Common User Interface. 
• All the relevant information to access form the source system or web page interface is operated by the USERS.
• Unified view of the data does not exist.

Application Based Integration:

• ABI requires specific applications for implementing all the integration efforts.
• When the number of applications is limited, this approach is WELL MANAGEABLE.

Manual Integration:

Application Based Integration:

Iteration uses loop to perform same STEP again and again while RECURSION calls function itself to do the REPETITIVE TASK. Many times recursion result in a clear and concise solution of complex problem e.g. tower of Hanoi, reversing a linked list or reversing a String itself. One drawback of recursion is depth, since recursion stores INTERMEDIATE result in stack you can only go upto certain depth, after that your program will die with StackOverFlowError, this is why iteration is preferred over recursion in production code.

Iteration uses loop to perform same step again and again while recursion calls function itself to do the repetitive task. Many times recursion result in a clear and concise solution of complex problem e.g. tower of Hanoi, reversing a linked list or reversing a String itself. One drawback of recursion is depth, since recursion stores intermediate result in stack you can only go upto certain depth, after that your program will die with StackOverFlowError, this is why iteration is preferred over recursion in production code.

Assume its a question about using bitwise operator as soon as you hear RESTRICTION about not ALLOWED to use arithmetic operator. If that restriction is not in place then you can easily CHECK if a number is power of two by using modulus and DIVISION operator. By the using bitwise operator, there is a nice trick to do this. You can use following code to check if a number if power of two or not

public static boolean powerOfTwo(int x) {

return (x & (x - 1)) == 0;

}

x & (x-1) is a nice trick to convert right most bit to ZERO if it's on.

Assume its a question about using bitwise operator as soon as you hear restriction about not allowed to use arithmetic operator. If that restriction is not in place then you can easily check if a number is power of two by using modulus and division operator. By the using bitwise operator, there is a nice trick to do this. You can use following code to check if a number if power of two or not

public static boolean powerOfTwo(int x) {

return (x & (x - 1)) == 0;

}

x & (x-1) is a nice trick to convert right most bit to zero if it's on.

With the answer to that question, I get to HEAR about the interviewee's thought process, favorite DIAGNOSTIC tools, and biases, as well as WHETHER they really know how to solve problems. Getting the "right" answer isn't important, but it tells me about how the person thinks and how well they've familiarized themselves with the tools they use.

With the answer to that question, I get to hear about the interviewee's thought process, favorite diagnostic tools, and biases, as well as whether they really know how to solve problems. Getting the "right" answer isn't important, but it tells me about how the person thinks and how well they've familiarized themselves with the tools they use.

Linked list and array are two of the most important data structure in programming world. Most significant difference between them is that array stores its element at CONTIGUOUS LOCATION while linked list stores its data anywhere in memory. This gives linked list enormous FLEXIBILITY to EXPAND itself because memory is always scattered. It's always possible that you wouldn't be able to create an array to STORE 1M integers but can do by using linked list because space is available but not as contiguous chunk. All other differences are result of this fact. For example you can search an element in array with O(1) time if you know the index but searching will take O(n) time in linked list.

Linked list and array are two of the most important data structure in programming world. Most significant difference between them is that array stores its element at contiguous location while linked list stores its data anywhere in memory. This gives linked list enormous flexibility to expand itself because memory is always scattered. It's always possible that you wouldn't be able to create an array to store 1M integers but can do by using linked list because space is available but not as contiguous chunk. All other differences are result of this fact. For example you can search an element in array with O(1) time if you know the index but searching will take O(n) time in linked list.

I need people who can LEARN, and LEARNING MEANS making mistakes, RECOGNIZING that, and doing a better job next TIME.

I need people who can learn, and learning means making mistakes, recognizing that, and doing a better job next time.

Following are the major DATA INTEGRATION JOBS:

• Transformation jobs - for preparing data
• Should be used when data must not be changed unless job completion of transforming data of a particular subject of interest
• PROVISIONING jobs - for transmission of data
• Should be used when data must not be changed unless job transformation when the data provisioning is large.
• HYBRID jobs - to perform both transformation and provisioning jobs.
• Data must be changed irrespective of success / failure. 
• Should be implemented neither the transformation nor the provisioning requirements are large

Following are the major data integration jobs:

• No, DATA INTEGRATION and ETL programming are different.
• PASSING of data to different systems from other systems is known as data integration.
• It may integrate data within the same application.
• ETL, on the other hand, is to EXTRACT the data from different sources.
• The primary ETL tool job is to transform the data and loads into other objects or tables.

• NO_CACHE - It is USED for not caching values.
• PRE_LOAD_CACHE - Result column preloads and COMPARES the column into the memory, prior to EXECUTING the lookup.PRE_LOAD_CACHE is used when the table can exactly fit in the memory space.
• DEMAND_LOAD_CACHE - Result column loads and compares the column into the memory when a FUNCTION performs the execution.DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data.

Following are the data integration factors:

• Sub set of the available data should be OPTIMAL. 
• Noise/distortion ESTIMATION levels because of sensory/processing CONDITIONS at the time of data collection.
• Accuracy, spatial and SPECTRAL resolution of data.
• Data formats, storage and retrieval MECHANISMS.
• Efficiency of computation for integrating data sets to reach the goals.

Following are the data integration factors:

The RATIONAL Unified Process (RUP) is an iterative software development process framework. RUP is not a single concrete prescriptive process, but rather an ADAPTABLE process framework, intended to be tailored by the development ORGANIZATIONS and software project teams that will select the elements of the process that are appropriate for their needs. RUP is a specific implementation of the unified process.

The Rational Unified Process (RUP) is an iterative software development process framework. RUP is not a single concrete prescriptive process, but rather an adaptable process framework, intended to be tailored by the development organizations and software project teams that will select the elements of the process that are appropriate for their needs. RUP is a specific implementation of the unified process.

This tells me a LOT about what they know, what they value, what actual positions they've HELD on a team, and WHETHER they ACTUALLY think about what they're doing.

This tells me a lot about what they know, what they value, what actual positions they've held on a team, and whether they actually think about what they're doing.

This is one of the classic question from SQL interviews, event it's quite old it is still INTERESTING and has lots of follow-up you can use to check depth of candidate's knowledge. You can FIND second highest salary by using correlated and non-correlated SUB query. You can also use keyword's like TOP or LIMIT if you are using SQL Server or MYSQL, given Interviewer allows you.

The simplest way to find 2nd highest salary is following :

SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)

This query first find maximum salary and then exclude that from list and again finds maximum salary. Obviously second time, it would be second highest salary.

This is one of the classic question from SQL interviews, event it's quite old it is still interesting and has lots of follow-up you can use to check depth of candidate's knowledge. You can find second highest salary by using correlated and non-correlated sub query. You can also use keyword's like TOP or LIMIT if you are using SQL Server or MySQL, given Interviewer allows you.

The simplest way to find 2nd highest salary is following :

SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)

This query first find maximum salary and then exclude that from list and again finds maximum salary. Obviously second time, it would be second highest salary.

Look for the existence of the following items:-

• Generic Data Models
• An Enterprise Data Platform
• Identify the Data Sources
• SELECTION of a MDM Product
• Implementation of a Customer Master INDEX or APPROPRIATE alternative

Look for the existence of the following items:-

A software design DESCRIPTION (SDD) is a written description of a software product, that a software DESIGNER writes in order to give a software DEVELOPMENT TEAM overall GUIDANCE to the architecture of the software project. An SDD usually accompanies an architecture diagram with pointers to detailed feature specifications of smaller pieces of the design. Practically, the description is required to coordinate a large team under a single vision, needs to be a stable reference, and outline all parts of the software and how they will work.

A software design description (SDD) is a written description of a software product, that a software designer writes in order to give a software development team overall guidance to the architecture of the software project. An SDD usually accompanies an architecture diagram with pointers to detailed feature specifications of smaller pieces of the design. Practically, the description is required to coordinate a large team under a single vision, needs to be a stable reference, and outline all parts of the software and how they will work.

Answer is zero, because XOR RETURNS 1 if two operands are DISTINCT and zero if two operands are same, for EXAMPLE 0 XOR 0 is ALSO zero, but 0 XOR 1 or 1 XOR 0 is always 1.

Answer is zero, because XOR returns 1 if two operands are distinct and zero if two operands are same, for example 0 XOR 0 is also zero, but 0 XOR 1 or 1 XOR 0 is always 1.

A TRACEABILITY matrix is a document, USUALLY in the form of a table, that correlates any two baselined documents that REQUIRE a many-to-many RELATIONSHIP to DETERMINE the completeness of the relationship

A traceability matrix is a document, usually in the form of a table, that correlates any two baselined documents that require a many-to-many relationship to determine the completeness of the relationship

FOLLOWING are the ways to PERFORM this:

• Using array FETCH size.
• Ordering the joins.
• Extracted DATA minimizing.
• Locale conversion minimization.
• SETTING target-based options to optimize the performance.
• Improving throughput.
• Data type conversion minimization.

Following are the ways to perform this:

FULL Outer JOIN is implemented by using SQL Transformation and WRITING custom query.

Following example describes SQL Transformation to implement Full Outer Join:

SELECT emp.*, dept.deptname, dept.deptno DNO, dept.location from scott.employee emp 

FULL OUTER JOIN

scott.department dept on (emp.deptno = dept.deptno) ;

Following example illustrates custom query to implement Full Outer Join:

• Drag EMPLOYEE, DEPARTMENT tables as src.
• Place the query transform for performing the Left Outer Join.
• Place one more query transform for performing the Right Outer Join.
• Merge and load them into the target.

Full Outer Join is implemented by using SQL Transformation and writing custom query.

Following example describes SQL Transformation to implement Full Outer Join:

select emp.*, dept.deptname, dept.deptno dno, dept.location from scott.employee emp 

FULL OUTER JOIN

scott.department dept on (emp.deptno = dept.deptno) ;

Following example illustrates custom query to implement Full Outer Join: