Tuesday, 30 May 2017

Oracle SQL Interview Questions and Answers




 Q1.) What is the difference between DML and DDL?

Ans: DDL (Data Definition Language) is used mainly for defining the database schema. It consists of SQL statements which give an idea about the structure of the database. Some examples of DDL statements are:

CREATE: Used to create new database objects
ALTER: Used to alter characteristics of already existing database objects
DROP: Used to remove database objects
TRUNCATE: Used to remove all records including all spaces allocated to record from the table

RENAME: Used to rename any database object
DML (Data Manipulation Language) are responsible for managing and manipulating various data schemas or database objects. They cannot alter the characteristics of a database object unlike DDL statements. Most common examples are:

SELECT: Used to retrieve data from the database
INSERT: Used to insert new data/records into the database
UPDATE: Used to update/modify the existing data/record from the database
DELETE: Used to remove the existing data/record from the database

Q2.) What does NVL function does?

Ans: NVL function is mainly used to replace NULL values with some other value provided the data type of the NULL value to be replaced with the given value is same.

Q3.) What is a BLOB data type?

Ans: BLOB is a binary string of varying length used to store data up to 2 gigabytes. Images, videos and other documents can be stored in the database using BLOB data type.

Q4.) What is the difference between varchar and varchar2?

Ans: The data type varchar is used to stored data up to 2000 bytes while varchar2 is used to store data up to 4000 bytes. However, the prominent difference between varchar and varchar2 is that varchar can occupy NULL values while varchar2 cannot.

Q5.) What are the different Oracle SQL database objects?

Ans:    Tables - Database object used to store various database records
           Views - It is a virtual table derived from one or more tables
           Indexes - Used to improve efficiency and performance of the database
           Synonyms - Aliases used for database tables

Q6.) What are various types of integrity constraints in Oracle SQL?

Ans: Unique: It ensures that the given column or entity is unique and cannot     be duplicated.

Not NULL: It ensures that the given column cannot be empty.

Foreign: It ensures that the two entities/tables share a common key with the one in parent table being a primary key and the one in child table being a foreign key.

Q7.) What is a hash cluster?

Ans: It is used to store table in a manner that query fetching results in faster data retrieval by using the hashing technique.

Q8.)
What is a sub query?

Ans: Sub query refers to a query written with in a query. It is often referred to as nested query or inner query. It is used to apply filters on selected data retrieved by the main query.

Q9.)
What is an alert?

Ans: A window appearing in the center of the screen overlaying the current screen to provide some form of information is termed as an alert.

Wednesday, 19 April 2017

Future Career Prospect Of MSBI

career opportunities in msbi
Microsoft Business Intelligence is the powerful business tool designed by Microsoft that offers excellent solutions for queries related to Business Intelligence and Data Mining.  This tool makes use of Microsoft Visual Studio Data Tools along with SQL Server.

Importance of MSBI:
MSBI allows the user to access the updated and accurate data which in turn facilitates proper decision making in the organisation. Different processes to be taken up in business intelligence require different set of tools for the solutions and MSBI provides the user with different tools to accomplish the task. It has an important application in Online Transaction Processing.

Business Intelligence has a very important role in almost all sorts of business in future. The obvious reason being handling of big data, its analysis and making smart decisions related to organisation is involved in every sector being IT, Engineering, Architecture, Banking, Government and Private agencies etc… and MSBI serves all the necessary requirements of BI

Future Aspects With MSBI

The business are now spread globally. The customer demands are increasing and to satisfy them and stay in the competitive environment successfully Business Intelligence is foremost requirement. Its perspectives in the future are detailed as follows:

Forecasting Using MSBI:


MSBI uses data mining tools and Predictive Analysis being the branch of data mining is beneficial in making future predictions by the analysis of present and the past data. The tool can help the organisations to work on their drawbacks, keep up with the strengths, understand the requirement of the customers in a better way and reduce the chances of occurrence of any loss and maximise the profit.

Thursday, 13 April 2017

Example showing Why MSBI?

We should comprehend this photo by taking a case of an association. We should take the case :- Calvin Klein (CK). We have outlets of Calvin Klein (CK) in many parts of India. Each outlet stores their client information in their separate database and it's not obligatory that each outlet is utilizing a similar database. A few outlets may have Sybase as their database, some may utilize prophet or a few stores incline toward putting away their information in basic content documents. 

Before continuing ahead with our clarification, we ought to know "what OLTP is"? It remains for Online Transaction Processing. These are essentially the online exchanges (Insert, Update, Delete) performed on database at each outlet by the client.

In the wake of putting away day by day information of the clients who went by Calvin Klein outlet at various stores, the information is then incorporated and spared it in a brought together database. This is finished with the assistance of OLTP part of MS SQL Server. Incorporation implies converging of information from various information stores (i.e. it might be a level document, Excel sheets, Sybase, Oracle, and so on.), invigorating information in information distribution centers and to rinse information (e.g. - Date arrangement might be diverse for various outlet's database, so same organization is made to make it even) before stacking to expel mistakes. Presently, you should be clear with the Integration idea. This is our Phase 1-"SSIS". 

msbi courses in bangalore
Next stride is to break down the put away unified information. This tremendous information is then isolated into Data Marts on which logical process is gone ahead. Investigation administrations utilize OLAP (Online Analytical Processing) segment and information mining abilities. It permits to fabricate multi-dimensional structures called CUBES to pre figure and store complex conglomerations, and furthermore to manufacture mining models to perform information examination which distinguishes significant data like what are the current patterns, designs, abhorrences of clients. Business examiner then perform information mining capacity on multi dimensional solid shape structure to look information from alternate points of view. Multi Dimensional investigation of gigantic information finishes the Phase 2-"SSAS". 

msbi courses in bangalore


Presently, the main thing left is to speak to this examination graphically so that an association (Calvin Klein) can settle on viable choice to improve their income, increase most extreme benefit and to decrease time wastage. Along these lines, this is done in types of Reports, Scorecards, Plans, Dashboards, Excel exercise manuals, and so on. This information reports will tell the association what is the income of Calvin Klein in particular time at particular place, where they caught the market, in which part they are missing and needs to support up and numerous different things which end clients wish to investigate. This detailing is finished with an instrument SQL Server Reporting Services and finishes Phase 3 – "SSRS".

This finishes our chart and i trust that you are presently evident with the parts of MSBI. We will get into the center in our later instructional exercises of MSBI.

For More Information: MSBI Training Cost in Bangalore

Wednesday, 12 April 2017

What is MSBI - Microsoft Business Intelligence

What is MSBI
 
MSBI remains for Microsoft Business Intelligence. This intense suite is made out of tools which helps in giving best answers for Business Intelligence and Data Mining Queries. This tools utilizes Visual studio alongside SQL server. It enable clients to access precise and progressive data for better basic leadership in an association. It offers distinctive tools for various procedures which are required in Business Intelligence (BI) arrangements. 

MSBI Training in Bangalore
MSBI is isolated into 3 classifications:-

1. SSIS – SQL Server Integration Services
2. SSAS – SQL Server Analytical Services
3. SSRS – SQL Server Reporting Services

1. SSIS– SQL Server Integration Services :- SSIS: (Sql Server Integration Services) This tool is utilized for the coordination like tricking the information starting with one database then onto the next like from Oracle to SQL Server or from Excel to Sql Server and so on. This device is likewise utilized for mass exchanges in the database like embeddings lac's of records without a moment's delay. We can make the mix administrations modules which will carry out the employment adversary us.

2. SSAS– SQL Server Analytical Services - SSAS: (SQL Server Analysis Services) This apparatus is utilized to break down the execution of the sql server as far as load adjusting, overwhelming information, tranasction and so forth. So it is pretty much identified with adminsitration of the SQL Sevrer utilizing this device. This is intense instrument and through this we can examine the information embeddings into the database like what number of exchanges occurs in a moment and so forth.

3. SSRS– SQL Server Reporting Services
- SSRS(SQL Server Reporting Services) This apparatus is identified with the era of report. This is exceptionally productive device as it is stage autonomous. We can produce the report utilizing this device and can use in an applications. Presently a days this is exceptionally prevalent in the market.

Few of the advantages of MSBI


1. Easy Data Exploration and Visualization
2. Managed Self-service BI tool
3. Full Use Of Native Excel Features
4. Dashboards And Scorecards
5. MSBI Support To Web Services
6. Complete End to End Business Solutions
7. MSBI Supports Data warehousing Applications

For More Information: MSBI Training Institutes in Bangalore

Friday, 17 February 2017

Top 15 Reasons Why You Must Learn PEGA

Introduction

Everybody is not an analyst; but instead living and nearness is coordinated by sensible headways. In reality, even the charged scientists have their scopes of specializations. By goodness of the above facts, an attempt at portraying what PEGA is about will be made before going into the very supportiveness of the structure to our ordinary nearness.

History


It is to a great degree principal to know the start of this structure with the objective that you will welcome it and the escort comfort it applies as an intense impact for your business. PEGA is an item association from America arranged in Cambridge, Massachusetts. The start of this system backpedals to 1983 when the then 28 years old Alan Trefler set up it.

The association has created more prominent now with its presentation in 1996 that it would be exchanged on an open market on the NASDAQ stock exchange. From the starting point of the year 2010, the association has climbed the venturing stool by getting more associations into its wrinkle.

Why Must You Embrace PEGA?

In the domain of business today, the customer is basic in business improvement and progression. Any business that toys with buyer faithfulness will end up speedier than imagined in the dustbin of history. The universe of business has gone propelled; things now happen with the speed of light by method for the web. Flexible shops are by and by the demand of the day.

Business is directly driven on the web. For collaborations among chiefs and the customer, the course of action lies in the use of pertinent programming. It is a pity that there is much cumbersome programming that leaves buyers perplexed on the net today. This is the place PEGA comes in.

There is in like manner the necessity with the desire of complimentary stream of information inside the affiliation. Time is a perishable thing and it is watched that most blue chip associations waste critical time endeavoring to get information transversely over inside their affiliation. There are various structures that have left most of these associations fairly bewildered in their find a way to dissipate information. PEGA has the reactions to each one of these fakes.

The accompanying are 15 Top Reasons Why You Must go PEGA in Business

1. Makes Interaction Easy for the Customer:


The customer is ruler in a business-without them, the arrangements won't come in; without arrangements, business is headed for frustration. PEGA makes things basic for the customer; the item is fundamental and straight forward. It makes the customer feel the maker through the fundamental easy to take after interface. The development is so clear, even a learner can move beyond using the structure.

2. In Health Care Delivery System:

There is the necessity for facilitated exertion between the patient on one hand and the restorative administrations specialists of course. Gone are the days when the issue relies on upon paper diagrams and mending focus charging structure. The bleeding edge patient will get a kick out of the opportunity to participate with his/her specialists with no hitch. This stage is immediately given by PEGA. Prosperity is wealth; no one should squander critical time using programming systems that will leave the patient afloat.

3. Conforms Seamlessly to Rapidly Changing Expectations:


The customer oversees what they require. Their coordinates changes times without number. It is watched that a great deal of affiliations are taken reeling when the customer asks for an essential change in timetable. In some tremendous affiliations, the entire system falls by ethicalness of a minor change in the customer's chain of intrigue. PEGA structure is altered to help acclimate to all conceivable change that the customer may devise, thusly keeping up the fancied soundness in the chain of business. It ensures that each electronic organization are uniquely crafted to specific needs.

4. Human Relationships:

The chain of spread is much sooner than it gets to the customer. The customer needs to feel that human touch however much as could sensibly be normal in the chain of dissemination that is mechanized based. PEGA has had the ability to use her development with a particular true objective to make the customer feel that needed human touch in every movement of the experience. An individual human relationship is delivered through the entire method; thusly making the customer to have that extraordinary sentiment richly pined for human interface in the propelled chain of dissemination.

5. Customer until the end of time:

Basic technique for cooperating can no longer party with the solicitations of today. Numerous associations have subsequently gone modernized to remain imperative in business. Substantial parts of these associations have no game plan for the human point. In this manner their customer base is debilitating instead of the other course round. PEGA has a structure set up that passes on operational remarkableness near to passing on a world class customer experience. Using this system will ensure that the steadfastness of your customers is held for eternity. There is nothing practically identical to that for business holding her customers for whatever period of time that business is in nearness PEGA guarantees this.

6. Assurance of Digital Transformation Delivered:

There is an overabundance of development in the nation today. Many will ensure a faultless system just to leave the customers lost afloat. There have been a couple of grievances of dissatisfaction regarding some item to pass on certification. Some of this item is excessively frustrated, making it impossible to ever be appreciated by the customers. In numerous illustrations, where the item is fundamental and easy to tail, they truly don't work with respect to genuine organization movement. PEGA has the limit and bona fide capacity to pass on each one of the promises it has made as it is settled in the clear easy to examine and take after instructional guide.

7. Clouding the Physical World:

There have been exchanges going round that advancement will soon supplant the person in the nearest future. The kite has been flown in various coherent get-togethers consistently. Despite the way that it has not possessed the capacity to widely inclusive reality, pointers are in the course this may soon be a reality. PEGA is arranged to meet with the troubles this may stance to the chain of scattering soon.

8. Speed and Accuracy:

In all likelihood each business person pines for that the technique is done with as quick and beneficially as possible with no extra cost to the association and the customer toward the complete of the allocation chain. The story gets the opportunity to be unmistakably sweeter when the system guarantees cost feasibility. That is the thing that the Sprint module in PEGA passes on to the table. It is fast and at no extra cost to the business chain at both completions of the association and the customer.

9. In Banking Experience:

The conformity in the best approach to manage business dealings has been extended to the sparing cash portion. There are various especially in the U.S who is doing combating with Mastercard portions. The disappointment persevered by bank customers have made the Banks in the US to scan for ways to deal with deal with the issue. They have come to fruition to PEGA and the system has handled the issue for the last time. Every business needs to deal in one way or the other with some measure of cash related trades; consequently the introduction of this PEGA structure is never a lost need.

10. People Oriented Marketing:

The overall public are the basic inspiration driving why any business, colossal or little is in nearness. In this way, any favorable publicizing system should be people orchestrated. It has been for the most part hard to connect with the customer by virtue of the blundering chain required in the scattering orchestrate. Cheerfully, this is by and by a relic of past circumstances in light of the way that PEGA has created a structure whereby gadgets, for instance, PEGA Marketing blended with ace advancing organizations can pass on a people arranged support of the customer.

11. The use of Design Thinking:

This is the use of human concentrated approach to manage issues with the purpose of making a trial that will make business correspondence between the organizations journey effectively without disintegration. Time is furthermore saved in light of the way that it is a productive measure. On the other hand it in like manner makes the surge of the chain of business smooth among agents and the customers. If and when this is refined in a business set up, we have a win situation. PEGA system in like manner guarantees this. In business today, arrange theory is the line most associations are towing to achieve their optimal without much ado.

12. A Captivating customer Experience:

The happening to modernized business has heaved a pool of millennial customers. In reality, even free organization concerns have gone modernized in a race to get by in the ever forceful market. Colossal quantities of the customers know negligible about the way things are done in electronic advancing. In view of "Accenture" curtsey of PEGA through which a wonderful customer experience is passed on through PEGA's guardrails. The traps and procedures included are clear.

13. It Creates an Exceptional Value:

PEGA has what it takes to make that great regard which is the dream of every business concern. AEGON today has a sweet story to tell. If the change their business experienced using PEGA structure is anything to cruise by, then every bona fide disliked and result orchestrated outfit should bring it into their chain of business since it guarantees the pined for accomplishment. It has completely enhanced the fortunes in their customer advantage list. This is perhaps what every business needs to get to their Eldorado.

14. IoT Reality:

IoT remains for web of things. Innovation is changing each day, business that is innovation based should likewise adjust to these progressions if the business must stream with current patterns. What about workers having a three in one? This is the capacity of the workers to view 3-4 screens dense into one single guide. It makes the stream of business quicker. Helps the representatives to keep pace with the quick rhythm with which business is done these days without extending them as far as possible. It has offered approach to genuine client victories. PEGA ensures this also.

15. Utilization of Robotic Automation:


The features have been with us for a long while now that robots will soon assume control over the elements of individuals in the chain of appropriation leaving the person repetitive. PEGA has ventured out in front of the circumstances with the presentation of their Robotic Automation. This is the utilization of robots to secure the productivity of the human work. It is attractive for each business who needs to keep pace with patterns in the work showcase. The workers are not un-fundamentally worried up on the grounds that they have a prepared partner in the robots who performs work with only a little touch or push of the catch.

Conclusion

The focuses said above are no buildups. They are as of now in the framework for all to see and check reality or generally of their viability. PEGA to be sure has the format for the accomplishment of organizations in this thousand years. They have demonstrated their significance. A promise to them today is an exertion toward business development.

If anyone willing to learn Pega Training in Bangalore at reputed Pega Training Institute reach us Sgraph Infotech. We are the leading training provider in Bangalore. We also offer real time Pega Online Training at affordable price.