Tuesday, 25 April 2017

How Use sp_MSForEachTable SP for Tables Row Count

Easiest way to get row count of every table in a database. You can use sp_MSForEachTable
SP

CREATE TABLE #Tablescounts

(table_name varchar(255),row_count int)

 

EXEC sp_MSForEachTable @command1 = 'INSERT #Tablescounts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'

 

SELECT * FROM #Tablescounts


SQL Pivot Tricky Query Example Asked in TCS

1). We have a table(#Temp1) contain RollNumber, Subject, Marks and want output as below, Write query for same.(pivot) asked in TCS
 

SELECT * FROM (SELECT * FROM(SELECT RN,[Subject],Marks from #Temp1)a

PIVOT(MAX(Marks) for [Subject] in ([Math],[Hindi],[English]))E) K

CROSS APPLY (SELECT MAX(Marks) MaxMarks FROM #temp1 WHERE RN = K.RN) S

 



2). Now write query which will show Subject as well like below .(pivot)
 
SELECT * FROM (

SELECT * FROM( SELECT RN,[Subject],Marks from #temp1)a

PIVOT (MAX(marks) for [Subject] in ([Math],[Hindi],[English]))E) K

CROSS APPLY (

SELECT CONCAT(Marks,('-'+[Subject])) MaxMarks_Subject FROM (

SELECT ROW_nUMBER() OVER(PArtition by rn order by Marks DESC) RowNum,Marks,Subject FROM #temp1 Where RN= K.RN)

J WHERE J.RowNum = 1

) S

Wednesday, 5 April 2017

Tuesday, 4 April 2017

Explain what is AutoScaling?

Scaling by adding additional instances is often referred to as scaling out. Windows Azure also supports scaling up by using larger role instances instead of more role instances.
By adding and removing role instances to your Windows Azure application while it is running, you can balance the performance of the application against its running costs.
An auto-scaling solution reduces the amount of manual work involved in dynamically scaling an application.

What is the difference between Web and Worker Roles in Windows Azure?

As you know the main difference between the two is that an instance of a web role runs IIS, while an instance of a worker role does not. Both are managed in the same way, however, and it’s common for an application to use both.For example, a web role instance might accept requests from users, then pass them to a worker role instance for processing.

Explain what is Azure Blob?

Azure Blob storage is a service for storing large amounts of unstructured object data, such as text or binary data, that can be accessed from anywhere in the world via HTTP or HTTPS. You can use Blob storage to expose data publicly to the world, or to store application data privately.

What is the difference between Windows Azure and Azure SQL database?

Windows Azure  is the cloud based premium service provided by Microsoft where we can able to host our application and make it available globally.

Windows Azure SQL Database is the another Azure service provided by Microsoft where the SQL DB engine is available in the Azure i mean the cloud. in a simple way, cloud DB based on SQL server engine.

Thursday, 23 March 2017

2017 Emirates Airline Interview Questions Answers PDF

Emirates Airline: Emirates is an airline based in Dubai, United Arab Emirates. The airline is a subsidiary of The Emirates Group, which is wholly owned by the government of Dubai's Investment Corporation of Dubai. It is the largest airline in the Middle East, operating over 3,600 flights per week from its hub at Dubai International Airport, to more than 154 cities in 81 countries across six continents. Cargo activities are undertaken by Emirates SkyCargo.
Emirates is the world’s fourth largest airline by scheduled revenue passenger-kilometers flown, the fourth-largest in terms of international passengers carried, and the second-largest in terms of freight tonne kilometers flown. Emirates had the longest non-stop commercial flight from Dubai to Auckland until it was surpassed by Qatar Airways.

Cabin Crew: Cabin crew or flight attendants are members of an aircrew employed by airlines primarily to ensure the safety and comfort of passengers aboard commercial flights, on select business jet aircraft, and on some military aircraft.The role of an air cabin crew member is to provide excellent customer service to passengers while ensuring their comfort and safety throughout the flight. They are trained to deal with security and emergency situations which may arise and can administer first aid to passengers.Cabin crew ensure that all emergency equipment is in working order prior to take off and that there are enough supplies. They also help passengers to board the plane and give a demonstration of safety procedures and equipment.Air cabin crew strive to make the flying experience a pleasant one for the passengers and will serve refreshments and meals and sell gifts and duty-free items. Cabin crew may work on short or long-haul flights.

Think about what is important to the role of cabin crew to get an idea of what might be covered in your interview. You need to be an excellent communicator, place high value on great customer service, you need to be hard-working, proactive, have a good awareness of safety, be able to follow instructions and implement protocol, manage conflict and deal with difficult people and situations calmly….the list is pretty long! But by giving some thought to what is required in the role you can get a good idea of what sort of questions you might be able to expect.

Another good way of working out what you need to demonstrate is to pay close attention to any documents you are sent in advance of your interview such as the ‘job description’ or ‘person specification’.You need to make sure your experience matches what the interviewers are looking for.

Entry requirements:
Entry requirements can vary between airlines so you should check with them for exact details.
In general, you will need a good standard of education, including GCSEs (grades A-C) in maths and English, or equivalent qualifications, and previous experience in a customer service role.

You will also need:
a good level of fitness and color-normal vision
a smart appearance
the ability to swim well
a valid passport with no restrictions for the countries the airline travels to.

Skills required in cabin crew member are:
  • Excellent 'people' skills.
  • A confident and friendly manner.
  • Tact and discretion.
  • A polite but firm approach when dealing with difficult customers.
  • A clear speaking voice.
  • The ability to work as part of a team.
  • Calmness under pressure and in emergencies.
  • Sensitivity towards people who are anxious or upset.
  • Good maths skills for handling cash, including foreign currency.
Working activities or duties of cabin crew:
  • Welcoming passengers on board and directing them to their seats.
  • In case of emergencies, cabin crews are there to reassure passengers so that they follow the correct emergency procedures. The crew may have to deal with several emergencies such as cabin fires or first aid situations.
  • At the end of a flight cabin crew members are there to make sure that passengers disembark the aircraft safely. The crew members are then asked to complete a written report that records all details of the flight. 
  • Informing passengers of the aircraft safety procedures and ensuring that all hand luggage is securely stored away.
  • Attending a pre-flight briefing, during which air cabin crew are assigned their working positions for the upcoming flight (crew are also informed of flight details, the schedule and if there are passengers with any special requirements, such as diabetic passengers, passengers in wheelchairs or the number of infants on board).
  • Completing paperwork, including writing a flight report.
  • Ensuring passengers disembark safely at the end of a flight and checking that there is no luggage left in the overhead lockers.
  • Giving first aid to passengers where necessary.
  • Serving meals and refreshments to passengers.
  • Selling duty-free goods and advising passengers of any allowance restrictions in force at their destination.
  • Making announcements on behalf of the pilot and answering passenger questions during the flight.
  • Carrying out pre-flight duties, including checking the safety equipment, ensuring the aircraft is clean and tidy, ensuring that information in the seat pockets is up to date and that all meals and stock are on board.
After recruitment process when you will get select:
Once you have been successfully accepted by an airline to work as a cabin crew member you will have to complete a mandatory 4-6 week training course, which is governed by the Civil Aviation Authority and the European Joint Aviation Authorities. This training course is called SEP (Safety & Emergency Procedures) the SEP training is paid for by the airline plus you will also get your first month’s wages. During this time you will be trained on:
  • Aircraft Evacuation
  • Ditching (landing on water)
  • Decompression
  • Fire Fighting
  • Passenger Management
  • Security Related Issues
  • Extraordinary Situations
  • First Aid
  • Survival
Tips for cabin crew interview:
  • Always stick to the question you were asked. Don’t stray away from the discussion and move to irrelevant and unrelated topics.
  • Prepare in advance some examples and answer the questions in specifics not in generalities.
  • If you don’t have a skill, just tell the interviewer and don’t try to cover it up by giving examples that are not relevant. Even if you don’t have that particular skill, you might have some related skills and you can discuss them further if the interviewer wants to hear more.
  • Prepare in advance couple of topics or ask any questions that may have resulted from the information exchanged during the interview.
  • Try to establish the time frame for a hiring decision to be made and who you should get in touch with to follow up the status of your application.
  • Sincerely thank the interviewer for the time spent with you. Give a firm handshake and make eye contact when doing this.
  • Being successful at your cabin crew final interview is all about confidence. Confidence comes from being prepared.

Now here are the Top 30 Emirates Airlines Cabin Crew interview questions:

1). What you know about the duties of a cabin crew member?

2). What is the most important skill required by a member of an airline cabin crew?

3). What are your interests?

4). What do you know about this airline?

5). Why do you want to join this airline?

6). How would you deal with difficult or negative situation in your life?

7). Who are the major competitors of this airline?

8). What do you like most about this airline?

9). What is the customer care policy of this airline?

10). Why do you think you are perfect for this position?

11). How would you deal with an unsatisfied customer?

12). Would you like to work in a team or alone?

13). How would you handle pressure at work?

14). What are your strengths?

15). Tell me about your areas of improvement.

16). Can you give an example of when you have overcome a difficult challenge?

17). Why did you choose this career out of many others?

18). How long will you work for this airline?

19). What other languages you can speak?

20). Tell me something about your family background?

21). Why should we select you not others?

22). How would you measure your own performance on this job?

23). Do you think you are overqualified for this position?

24). Describe yourself in one line.

25). What would you do if any customer complaint about your service?

26). If you were an animal, which one would you want to be?

27). Have you ever worked in a customer care or customer service job?

28). How much do you expect to get paid?

29). What you can bring or contribute to this airline?

30). Do you have any question for us?

Wednesday, 22 March 2017

Explain why use Jira?

Below are the advantage of using Jira

  • Better visibility
  • Better prioritization
  • Better downtime between tasks 
  • Improved team work more predictability

What are the main types of testing?

Most used type of testing are:

  • Unit - testing by programmer, can be automated
  • Integration - functional entities, tester independent of coding, similar to blackbox
  • User Acceptance - verifies software meets requirements
  • System - functionality of modules when used together
  • Whitebox - full acess to code, flaws within code, debugging
  • Blackbox - no access to code, inputs/outputs tested
  • Stress - what happens when boundary conditions are reached
  • Regression - makes sure changes to one part of system doesn't break others

Friday, 17 March 2017

Alteryx Designer Interview Questions Answers

Explain what is Alteryx Designer?
Alteryx is a desktop application for data blending and advanced analytics, enabling users to gather data from any source, blend it, and provide sophisticated predictive and spatial analytics with an easy-to-use drag-and-drop interface.

What are the advantage and disadvantages of Alteryx Designer?
Advantage:
  • Alteryx has fantastic blending capabilities
  • Alteryx can interact with most popular databases and files available today
  • Alteryx is the only ETL tool in the market that can output a tableau data extract (TDE)
  • Alteryx is not just an ETL tool, it can be used to perform a whole lot of analytics on your data
  • Alteryx integrates with R seamlessly and can be used for predictive modelling.
  • Alteryx can also be used to build reports with prompt filters
Disadvantages:
  • While Alteryx outputs a tableau data extract seamlessly it cannot read a similar extract
  • Alteryx does not have good support for special characters
  • Alteryx is not stable and crashes frequently when multiple users access the same workflow on the server
  • Slight learning curve to understand all the tools and some of the Statistical R packages aren't always straightforward.
How do you turn annotations on and off?
Per Tool: You can turn them on/off per tool, meaning you want to keep some annotations while omitting others. To do this click on the individual tool. Go to Annotation from the Properties window and in the Display Mode, select the appropriate choice.
Per Module : There is a toggle switch on the Module Properties window where you can either turn all the annotations on or off for that particular module. Additionally you can have greater control leaving this feature on and controlling the annotations per tool as described above.
Through Global Settings: You can set up the global settings so that Annotations will appear the same way for each and every module and tool.

What is the difference between the Transpose tool and the CrossTab tool? 
The Transpose and CrossTab tools are alike in that they both transform the orientation of your data, but are opposite in their behavior.
The Transpose tool pivots horizontal data to a vertical axis. The CrossTab performs the reverse, pivoting vertical data to the horizontal axis, by summarizing the data on a grouping field.

How can you save an expression ? 
Expressions can be saved so that they can be used over and over again without having to create them from scratch.
Create your expression using a combination of selecting variables and inserting them into functions . Once you are happy with the formulated expression, click the Saved Expression tab. Hit the Save button and specify a name for your expression. Your expression is now saved for future use.

You received the following error, "No Values found before GetMean()" - What does this mean?
Check your configurations upstream. If there is an Allocate Append tool, be sure the spatial object specified in the drop down selection is a polygon object and NOT a point object. If the error is coming from a Reporting Map tool, ensure you are not choosing Smart Tiling on a String field as a Thematic mapping tile mode.

How can you change a word or a character or remove it? 
From the File menu, go to Open Sample --> Basic Samples --> Data Problem and Solution Flexibility

How can you change a field type? 
Primarily the best place to change a field's type is through the  Formula tool. There is more control for custom conversion through the formula tool.
The next best place to change a field's type is the Select tool or, there are a number of tools that have an embedded select within the tool. Therefore you can change a field's type there as well. Tools that contain an embedded select are: Join, Join Multiple, Append Fields, Spatial Match, and Find Nearest.

Hadoop Perspectives for 2017 eBook/PDF Free Download

Hi here you will got Free eBook of Hadoop by Syncsort, In Syncsort words

The results from Syncsort’s third annual Hadoop Market Adoption Survey are in!  As users gain more experience with Hadoop, they are building on their early success and expanding the size and scope of Hadoop projects. Download this report to find out what 250+ IT decision-makers have to say about topics such as:

  • The largest data sources populating the data lake
  • The role of Hadoop in your organization and top use cases
  • The business benefits companies are seeing from Hadoop

This ebook also features industry best practices and our Big Data experts’ five trends to watch for in 2017!

To download this book visit here

Tuesday, 14 March 2017

What do you understand by "sql_variant" datatype in SQL Server?

sql_variant is a datatype in SQL server,a column of type sql_variant may contain rows of different data types. For example, a column defined as sql_variant can store int, binary, and char value. sql_variant can have a maximum length of 8016 bytes. This includes both the base type information and the base type value. The maximum length of the actual base type value is 8,000 bytes.

Thursday, 2 March 2017

How Generate Email Formatted HTML Table with T-SQL

If you are database developer this is very common task to send automated email, and for that you need to created good html formatted table using your SQL Server table data. Here we are going to do same.

First Create a temp table to insert sample table. After that use below body code in which we have already implemented css. after that you will html table you can see in above image.

CREATE TABLE #temp( JobName NVARCHAR(100),StepName NVARCHAR(100), ErrorMsg NVARCHAR(200))
INSERT INTO #temp VALUES('Job 1','Step 1','Error no 1'),('Job 1','Step 2','Error no 2')
SELECT * FROM #temp

DECLARE @Xml NVARCHAR(MAX)
DECLARE @Body NVARCHAR(MAX)


SET @Xml = CAST(( SELECT [JobName] AS 'td','',[StepName] AS 'td','',[ErrorMsg] AS 'td'FROM  #Temp
FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))

SET @Body =N'<html>
<head><style type="text/css">th { background-color: #4CAF50; color: white; border: solid black 1px; padding: 10px 10px 10px 10px;font-size:12pt;}
td {border: solid black 1px;padding: 5px 5px 5px 5px;font-size:11pt;color:Black;}
table {border-collapse: collapse; }
body {font-family: "Arial", Helvetica, sans-serif;}</style></head>
<body><H3>Failed Job Detail</H3>
<table> <tr><th>Job Name</th> <th>Step Name</th> <th>ErrorMessage</th></tr>'   
SET @Body = @Body + @Xml +'</table></body></html>'
PRINT @Body

EXEC msdb.dbo.sp_send_dbmail
@Profile_name = 'SQL ALERTING', -- replace with your SQL Database Mail Profile
@Body = @Body,
@Body_format ='HTML',
@Recipients = 'ahlawatvikas.gmail.com', -- replace with your email address

@Subject = 'E-mail in Tabular Format' ;

Practical Tips on How to Prepare for the Entrance Exam

Many are the unknowns that come to the head of young high school graduates who have completed their secondary education, and is that apart from thinking and deciding which university to study also think about the examination of admission that if they have decided to study higher education in a public university.

Thus, to study in a university that receives benefits of 6%, its students have to solve the admission examination that includes subjects such as Spanish and Mathematics or Mathematics and Proficiency Test. For that reason we share below some tips that will prepare you before the test.

  1. To know the subject of the exam that the university has published in previous years.
  2.  Identify which are the topics or contents that dominate more and which you must study to reinforce them.
  3. Make groups of studies and organize activities to help you prepare better.
  4.  Stipulate your study hours in a schedule that allows you to concentrate.
  5.  Very important, before the exam DO NOT disclose yourself, sleep as much as you can to get up with lots of energy and positive attitude.
  6. Don't study one day before you take the exam, that is a serious mistake, what you have already learned will not be forgotten.
  7. Remember that you must leave the documents and the identification that will be asked at the entrance of the university ready to access your exam.
  8. When you arrive at the campus, keep calm, do not despair, as it is always taken into account the time it will take to enter all students. Once inside, locate your classroom and sit where you are most comfortable; And listen carefully to the directions that the teacher will give prior to the application of the exam.
  9. Do not forget to take your pencils, pens, pencils, erasers and calculator, because all these elements are of paramount importance to solve the test.
  10. When you receive the exam, read all the exercises carefully and if you are in doubt you can consult the examiner. Ask the question, do not stay with the doubt, do not be afraid or sorry for asking your questions, and something you can not forget, write all your personal data and everything that the test prompts you.
  11. Once you have the exam in your hands, start solving the easiest problems, that is, from the easiest to the most difficult, work in order, if there are marks that make sure you look at the form you are going to write answer.
  12. Finished the answer of your exam and if you still have time, carefully inspect your operations, you may have something to correct and give a last revised everything done, use all the time allocated to the exam.

Top 10 Tips to Crack Campus Aptitude Test | TCS | Infosys | Wipro

The Academic Aptitude Test is an instrument to determine the verbal skills, mathematical logic, effectiveness, creativity, speed and motor skills of the candidates. As you know each test is different and there are no magic formulas to get satisfactory results, but in general there are several lessons that can help you improve performance at the time of performing

Read: It is one of the first tips to obtain good results, a good habit of reading implies to improve the abilities of interpretation and comprehension of texts, contents and readings, which are evaluated in the test.
In addition, reading improves and broadens the vocabulary, which allows to approach exclusive exercises to measure the extension of a word within a sentence, the reasoning of a text and the synthesis of a sentence.
In that sense, the guidance department recommends interpreting readings of stories, short stories and novels, with the aim of conducting an analysis of each passage to determine who is the main actor? Which is the message?
The Aptitude Test measures linguistic skills, essential skills for success in higher education, so that a student who wants to pass the Test must be able to interpret a text, in order to enter the TCS/Infosys .

Preparation: Get important information about the test, investigate how long the application lasts and how it will be administered. Knowing exactly what to expect can help prepare you mentally and avoid confusion during the test. You can find this information once you sign up for the Aptitude Test.
On the internet you can find exams that can help you practice in the face of the Aptitude Test. You can also access the guide that provides the Admission System Management for free.
The aptitude tests often have a time limit, so answer the questions and use a timer or a timer to determine your performance. This will help you to be more concise at the time of testing.
It is also essential to have your registration card and a photo ID at the moment of entering the university facilities to carry out the Aptitude Test.

Concentration: In the Aptitude Test there are many mathematical exercises based on examples of daily life, and they evaluate the application of knowledge, that is, do not memorize a mathematical rule, but understand why it applies.
In this case, you can find exercises of arithmetic, algebra, geometry and statistics, in educational portals of the universities, you can also informarte with the exercises that is within the guide provided by the Admissions Directorate. Remember the exercises are examples, and only provide guidance, so it is best to look for similar exercises on the internet and seek academic advice if you have problems.
Logical reasoning is important for university education and life in general, since they allow for systematic analysis of a graph or evaluate a geometric figure, essential for careers such as engineering, architecture and other careers.

Avoid Stress: Focus on reducing stress and anxiety in the run-up to the test. Stress can negatively affect your mood, sleep patterns, and ability to focus. Additional relaxation techniques are advisable.

Follow instructions: Generally an average of 80 thousand to one lakh students performs the Aptitude Test, during the three tests that the TCS/Infosys applies in the year. Keeping this in mind, you should be aware of all the instructions and steps given before and during the test.
When completing the test, answer the questions you know first. If you are not sure about a particular question, avoid it. Once you have completed all the other answers, come back and try the difficult questions again. If you have time, check all your answers.
Make sure you know how much time you have to complete the test and use it in a proper way. Do not rush, as you can make mistakes. However, keep in mind the remaining time and do not spend too much time on each question.

Sleep well and eat well: Remember the day before the test it is best to sleep at least eight hours. Lack of sleep can lead to key concentration errors to perform a successful test.
Eating properly can give good results, remember that the test is done in the morning, so you must feed yourself balanced before performing the Aptitude Test in order to stay focused throughout the day.

Multiple choice questions tips:
When doing a "multiple choice" exam, know when to guess
  • First, eliminate the answers you know to be wrong. 
  • Always conjecture when there is no penalty for doing so or you can eliminate options. 
  • Do not guess if you have no basis for your choice and if you will be sanctioned for guessing 
  • If your first choice is usually correct, do not change your answers unless you are sure of the correction
Time saving: 
  • Reserve 10% of your exam time for review your exam 
  • Resist the urge to leave as soon as you have completed all items 
  • Make sure you have answered all the questions. 
  • Correct your writing regarding spelling, grammar, and punctuation. 
  • Check your math answers for careless errors (for example, decimal errors). Compare your current answers to math problems with a quick estimate
Panning for what to do first/last:
  • Plan to answer the easy questions first and the most difficult questions last. 
  • Answer the test questions in a strategic order.
  • The last questions you answer should be the most difficult,
  • Carry the largest written quantity, or have the lowest score value.
Test paper review:
  • Do a pre-test review.
  • Use 10% of your reading time reading the entire test carefully. 
  • Mark the key terms and decide how to manage your time. 
  • As you read the questions, write brief notes indicating ideas you can Use later in your answers.

ABB 2017 Placement Papers for Electrical Engineers

ABB (ASEA Brown Boveri) is a Swedish-Swiss multinational corporation headquartered in Zurich, Switzerland, operating mainly in robotics and the power and automation technology areas. It ranked as the 286th largest company by revenue for 2016 in the Fortune Global 500 list.
ABB is one of the largest engineering companies as well as one of the largest conglomerates in the world. ABB has operations in around 100 countries, with approximately 132,000 employees in December 2016.

Selection Process:
Company conducts recruitment process every year to select new candidates. The selection process of the company consists of 4 rounds. These rounds are as follows:

  • Written Exam
  • GD
  • Technical Interview
  • HR Interview
Click here for Placement Papers

TCS Placement Criteria for 2017 Fresher Batch


Hey fresher are you looking for job in TCS? Then here you can know that you are eligibility candidate for TCS or not

The TCS Eligibility Criteria for 2017 an entry level position, is as follows:
  • Minimum aggregate (aggregate of all subjects in all semesters) marks of 60% or above in the first attempt in each of your Class Xth, Class XIIth, Diploma (if applicable), Graduation and Post-Graduation examination which includes successful completion of your final year/semester examination without any pending arrears/back logs during the entire course duration. Please note that all subjects mentioned on the mark sheets should be taken into consideration while calculating the aggregate marks. For example, best of 5/6 subjects for calculating the aggregate is not acceptable as per the TCS Eligibility Criteria.
  • First attempt implies that you should pass the final year/semester examination (Xth, XIIh, Diploma, Graduation and Post-Graduation as applicable) with minimum aggregate (aggregate of all subjects in all semesters) marks of 60% and above within the first attempt itself. For example, if you have secured 58.9 % (aggregate of all subjects) in your Standard XIIth examination and you have taken an improvement exam in the next attempt securing 62 %, you are not eligible as per the TCS Eligibility Criteria, as improvement exam is not considered as first attempt.
  • Completion of all courses Class Xth onwards within the stipulated time as specified by your University/Institute without any extended education.
  • It is mandatory to declare the gaps/arrears/backlogs, if any, during your academic and work experience. Break in education should not be due to extended education. Any break in education should not exceed 24 months.
  • Only Full time courses will be considered.
  • You should be minimum 18 years of age to be eligible to apply for the TCS Selection process.
  • Candidates who have applied to TCS and have not been successful in clearing the TCSL selection process are not eligible to re-apply to TCS within six months from the date on which they had attended such selection test and/or interview. You are not eligible to appear for the TCS selection process within six months of the previous unsuccessful attempt.

Wednesday, 1 March 2017

TCS 2017 Placement Paper / Pattern with Solution

Hi Fresher, Here I come with latest TCS Test Pattern 2017 including with TCS Test Syllabus and Recruitment process. So that fresher can prepare for the Aptitude and get selected for the next round.
Good news is that here we come with TCS 2017 Placement paper with solution.
As you know big company like TCS recruits every year through campus and off-campus recruitment drives. If you want to get success in placement tests, you should know the patterns on the particular company like TCS.

TCS Test Pattern for 2017 Batch:
As you can see in the paper provided in this post, TCS added 30 Q. Ability questions and an Email writing to test your communication skill for recruit the 2017 batch students.
TestsDescriptionTime
Test 1Email Writing10 minutes
Test 2Quantitative ability-30 Questions80 minutes
Technical InterviewTechnical InterviewNA
Management InterviewManagement InterviewNA
HR InterviewHR InterviewNA


Test Details
Quantitative Ability: As you can see TCS have not changed the pattern for quite a long time.
There are same 30 Quantitative ability questions to be attempted in 80 minutes(less than 3 minutes per question). And other thing about TCS test is that there questions would be slightly tricky. Unlike other Companies, TCS tests the Quantitative ability on a wide variety of topics.

Topics List for Quantitative Ability /Aptitude:
  • Averages, Mixtures and Allegations
  • Permutation and Combinations, Probability
  • Percentages, Profit and loss
  • Time, speed, distance, Time and Work
  • Algebra, Ratio and Proportions
  • Functions, Geometry
  • Numbers
Email Writing:
In this part of the test, you are expected to write an email in around 70 words for the given scenario within 10 minutes. And you will also be given the keywords to be used in the Email, You must need to use that keywords in your email.

Click here to read TCS Aptitude Test Tips
2017 Placemen Paper with pdf will be avaliable soon
Click here for TCS Placement Papers

Friday, 17 February 2017

Explain me the difference between Issue and Risk?

Risk: A risk is something you feel may happen and for which eventuality you need to plan some mitigating actions to buy-pass it.

Issue: An issue is when a risk becomes reality and you have to drag the plan out of the drawer to deal with it.

Explain how to create an issue in Jira via rest api?

POST to this URL
https://<JIRA_HOST>/rest/api/2/issue/

This data:
{
"fields": {
   "project":
   {
      "key": "<PROJECT_KEY>"
   },
   "summary": "REST EXAMPLE",
   "description": "Creating an issue via REST API",
   "issuetype": {
      "name": "Bug"
   }
  }
}

In received answer will be ID and key of your ISSUE:
{"id":"83336","key":"PROJECT_KEY-4","self":"https://<JIRA_HOST>/rest/api/2/issue/83336"}
Don't forget about authorization. I used HTTP-Basic one.

Click here to read original article

How to find issues that at some point has been assigned to you in JIRA?

This is meanwhile possible by means of the JIRA Query Language (JQL)

A simple query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functions. For example:
project = "TEST"
This query will find all issues in the "TEST" project. It uses the "project" field, the EQUALS operator, and the value "TEST".

But here you find out all issue which has been assigned to you(current user) then your query look likes below:
project = "TEST" AND assignee = currentuser()
This query will find all issues in the "TEST" project where the assignee is the currently logged in user. It uses the "project" field, the EQUALS operator, the value "TEST",the "AND" keyword and the "currentuser()" function.

Or you can use 'WAS' operator, which has been introduced in JIRA 4.3 and extended in JIRA 4.4 to cover assignees and reporters as well, for example:
project = "TEST" and (assignee was 'vikas' or reporter was 'vikas')

Explain what is JQL (JIRA Query Language)? Interview Questions

JQL stands for JIRA Query Language. It’s the most flexible way to search for issues in JIRA and is for everyone: developers, testers, project managers, and even non-technical business users. This blog is intended to be a tutorial for those who have no experience with database queries as well as those who want faster access to information in JIRA. Basically, anyone who works in JIRA can benefit from a little JQL.

If you're a technical person/developer/dba who already knows SQL, you've got a leg up because Atlassian's implementation of JQL is very similar. The search box is even equipped with code hints and inline validation to make constructing queries easy.
To try out JQL in your JIRA instance, you can:

  • Click Issues > Search for issue
  • Click Edit (If you have a search in progress)
  • Click Advanced Searching

You can then type your queries directly into JIRA. For a complete reference, check out our help docs on advanced searching. I recommend bookmarking this link – I find myself returning to it often to look up obscure queries. The docs page has a lot of content, so it's helpful to do a "Ctrl/Cmd + F" so you can jump directly to a specific topic or keyword of interest.

To know more you can read Atlassian tech blog

What is a backlog in JIRA Agile?

A backlog is the list of tasks which are yet to be allocated for completion. Any large project will end up with lots of things people want; as a team you can use JIRA Agile to manage this long list of tasks by ranking, prioritizing, and scheduling the work.

How do you count all the Agile boards I currently have in my JIRA instance?

Procedure
This can be done by directly running an SQL select query from the database:
SELECT COUNT(id) FROM ao_60db71_rapidview;
This will return the number of boards regardless of Kanban or Scrum.

Kanban Specific
To get the number of Kanban-only boards:
SELECT COUNT(id) FROM ao_60db71_rapidview WHERE SPRINTS_ENABLED = 0;

Scrum Specific
To get the number of Scrum-only boards:
SELECT COUNT(id) FROM ao_60db71_rapidview WHERE SPRINTS_ENABLED = 1;

Thursday, 16 February 2017

Explain how to Watch / stop multiple issues in JIRA?

  1. Perform a search with the required filters to produce a list of issues.
  2. Select Tools > Bulk Change.
  3. Select the issues you'd like to perform the bulk operation on, and select Next.
  4. Select Watch Issues, and select Next.
  5. Review your bulk operation, and select Confirm when you are happy with the operation.

Explain what is JIRA Agile?

JIRA Agile is a JIRA add-on that adds a broad collection of agile project management capabilities to JIRA, and extends JIRA as a powerful platform for agile development teams. JIRA Agile simplifies the planning and organisation of tasks, workflows and reporting for agile teams.

What is an issue in JIRA?

Different organizations use JIRA to track different kinds of issues. Depending on how your organization is using JIRA, an issue could represent a software bug, a project task, a help desk ticket, a leave request form, etc.

What is Workflow, in JIRA?

A JIRA workflow is the set of statuses and transitions that an issue goes through during its lifecycle. The following diagram shows JIRA's built-in workflow:

What is a Project, in JIRA?

A JIRA project is a collection of issues, and is defined according to your organisation's requirements. For example, a JIRA project could be:

  • A software development project
  • A marketing campaign
  • A helpdesk system
  • A leave request management system
  • A website enhancement request system

Every issue belongs to a project. Each project has a name (e.g. Website Issues) and a key (e.g. WEB). The project key becomes the first part of that project's issue keys, e.g. WEB-101, WEB-102, etc

Explain what is Jira?

JIRA is a tool developed by Australian Company Atlassian. JIRA is used for bug tracking, issue tracking, and project management functions. The name "JIRA" is actually inherited from the Japanese word "Gojira" which means "Godzilla". The basic use of this tool is to track issues, and bugs related to your software and mobile apps. It has been developed since 2002.

Wednesday, 15 February 2017

Amazon has Announced Amazon Chime for online meetings with exceptional audio and video quality

What is Amazon Chime?
Amazon Chime is a communications service that transforms online meetings with a secure, easy-to-use application that you can trust. Amazon Chime works seamlessly across your devices so that you can stay connected. You can use Amazon Chime for online meetings, video conferencing, calls, chat, and to share content, both inside and outside your organization. Amazon Chime frees you to work productively from anywhere.

For more you can read Amazon chime official post


30+ Delta AirLine Cabin Crew Interview Questions with Best Answers

Delta Air Lines: Delta Air Lines, Inc. is a major American airline, with its headquarters and largest hub at Hartsfield–Jackson Atlanta International Airport in Atlanta, Georgia. The airline along with its subsidiaries and regional affiliates operate over 5,400 flights daily and serve an extensive domestic and international network that includes 319 destinations in 54 countries on six continents, as of October 2016. Delta is one of the four founding members of the SkyTeam airline alliance, and operates joint ventures with Air France-KLM, Alitalia, Virgin Atlantic, and Virgin Australia. Regional service is operated under the brand name Delta Connection.
Visit there official site for current jobs opening

Cabin Crew: Cabin crew or flight attendants are members of an aircrew employed by airlines primarily to ensure the safety and comfort of passengers aboard commercial flights, on select business jet aircraft, and on some military aircraft.The role of an air cabin crew member is to provide excellent customer service to passengers while ensuring their comfort and safety throughout the flight. They are trained to deal with security and emergency situations which may arise and can administer first aid to passengers.Cabin crew ensure that all emergency equipment is in working order prior to take off and that there are enough supplies. They also help passengers to board the plane and give a demonstration of safety procedures and equipment.Air cabin crew strive to make the flying experience a pleasant one for the passengers and will serve refreshments and meals and sell gifts and duty-free items. Cabin crew may work on short or long-haul flights.

Think about what is important to the role of cabin crew to get an idea of what might be covered in your interview. You need to be an excellent communicator, place high value on great customer service, you need to be hard-working, proactive, have a good awareness of safety, be able to follow instructions and implement protocol, manage conflict and deal with difficult people and situations calmly….the list is pretty long! But by giving some thought to what is required in the role you can get a good idea of what sort of questions you might be able to expect.

Another good way of working out what you need to demonstrate is to pay close attention to any documents you are sent in advance of your interview such as the ‘job description’ or ‘person specification’.You need to make sure your experience matches what the interviewers are looking for.

Entry requirements:
Entry requirements can vary between airlines so you should check with them for exact details.
In general, you will need a good standard of education, including GCSEs (grades A-C) in maths and English, or equivalent qualifications, and previous experience in a customer service role.

You will also need:
a good level of fitness and color-normal vision
a smart appearance
the ability to swim well
a valid passport with no restrictions for the countries the airline travels to.

Skills required in cabin crew member are:
  • Excellent 'people' skills.
  • A confident and friendly manner.
  • Tact and discretion.
  • A polite but firm approach when dealing with difficult customers.
  • A clear speaking voice.
  • The ability to work as part of a team.
  • Calmness under pressure and in emergencies.
  • Sensitivity towards people who are anxious or upset.
  • Good maths skills for handling cash, including foreign currency.
Working activities or duties of cabin crew:
  • Welcoming passengers on board and directing them to their seats.
  • In case of emergencies, cabin crews are there to reassure passengers so that they follow the correct emergency procedures. The crew may have to deal with several emergencies such as cabin fires or first aid situations.
  • At the end of a flight cabin crew members are there to make sure that passengers disembark the aircraft safely. The crew members are then asked to complete a written report that records all details of the flight. 
  • Informing passengers of the aircraft safety procedures and ensuring that all hand luggage is securely stored away.
  • Attending a pre-flight briefing, during which air cabin crew are assigned their working positions for the upcoming flight (crew are also informed of flight details, the schedule and if there are passengers with any special requirements, such as diabetic passengers, passengers in wheelchairs or the number of infants on board).
  • Completing paperwork, including writing a flight report.
  • Ensuring passengers disembark safely at the end of a flight and checking that there is no luggage left in the overhead lockers.
  • Giving first aid to passengers where necessary.
  • Serving meals and refreshments to passengers.
  • Selling duty-free goods and advising passengers of any allowance restrictions in force at their destination.
  • Making announcements on behalf of the pilot and answering passenger questions during the flight.
  • Carrying out pre-flight duties, including checking the safety equipment, ensuring the aircraft is clean and tidy, ensuring that information in the seat pockets is up to date and that all meals and stock are on board.
After recruitment process when you will get select:
Once you have been successfully accepted by an airline to work as a cabin crew member you will have to complete a mandatory 4-6 week training course, which is governed by the Civil Aviation Authority and the European Joint Aviation Authorities. This training course is called SEP (Safety & Emergency Procedures) the SEP training is paid for by the airline plus you will also get your first month’s wages. During this time you will be trained on:
  • Aircraft Evacuation
  • Ditching (landing on water)
  • Decompression
  • Fire Fighting
  • Passenger Management
  • Security Related Issues
  • Extraordinary Situations
  • First Aid
  • Survival
Tips for cabin crew interview:
  • Always stick to the question you were asked. Don’t stray away from the discussion and move to irrelevant and unrelated topics.
  • Prepare in advance some examples and answer the questions in specifics not in generalities.
  • If you don’t have a skill, just tell the interviewer and don’t try to cover it up by giving examples that are not relevant. Even if you don’t have that particular skill, you might have some related skills and you can discuss them further if the interviewer wants to hear more.
  • Prepare in advance couple of topics or ask any questions that may have resulted from the information exchanged during the interview.
  • Try to establish the time frame for a hiring decision to be made and who you should get in touch with to follow up the status of your application.
  • Sincerely thank the interviewer for the time spent with you. Give a firm handshake and make eye contact when doing this.
  • Being successful at your cabin crew final interview is all about confidence. Confidence comes from being prepared.

Now here are the Top 30 Delta Airlines Cabin Crew interview questions:
What you know about the duties of a cabin crew member?

What is the most important skill required by a member of an airline cabin crew?

What are your interests?

What do you know about this airline?

Why do you want to join this airline?

What are your strengths?

Tell me about your areas of improvement.

How would you deal with difficult or negative situation in your life?

Who are the major competitors of this airline?

What do you like most about this airline?

What is the customer care policy of this airline?

Why do you think you are perfect for this position?

How would you deal with an unsatisfied customer?

Would you like to work in a team or alone?

How would you handle pressure at work?

Can you give an example of when you have overcome a difficult challenge?

Why did you choose this career out of many others?

How long will you work for this airline?

What other languages you can speak?

How would you measure your own performance on this job?

Do you think you are overqualified for this position?

Describe yourself in one line.

What would you do if any customer complaint about your service?

If you were an animal, which one would you want to be?

Have you ever worked in a customer care or customer service job?

Tell me something about your family background?

Why should we select you not others?

How much do you expect to get paid?

What you can bring or contribute to this airline?

Do you have any question for us?

Do you have any question for us?

It is very important for you to ask questions  not just any questions, but those relating to the job, the airline and the industry.
So be prepared to ask questions. You can ask questions like:

  • Tell me about a typical day in this job.
  • What are the most challenging facts of the position?
  • What makes your airline different from its competitors?
  • What are your airline's strengths and weaknesses?

FLY HIGH :)

What you can bring or contribute to this airline?

The best way to answer questions about your contributions to the airline is to give examples of what you have accomplished in the past, and to relate them to what you can achieve in the future.
Describe specific examples of how effective you have been in your other positions, change you have implemented, and goals you have achieved. Talk about the depth and breadth of related experience that you have. Also, relate your abilities to the employer's goals. You will want to let the interviewer know that you have the skills necessary to do the job they are hiring for.

How much do you expect to get paid?

For this be prepared and research salary to find out what similar positions are paying in your area before you go to the interview. Try to find this information out before giving your salary expectations. You can and should provide a range instead of an exact number. But again, don’t say any numbers you’re not comfortable with because if the employer offers you a salary at the lowest end of your range, you don’t have much to negotiate with when it comes to getting a higher salary.

Why should we select you not others?

Here you need to give strong reasons to your interviewer to select you not others. Sell yourself to your interviewer in interview in every possible best way. You may say like I think I am really qualified for the position. I am a hard worker and a fast learner, and though I may not have all of the qualifications that you need, I know I can learn the job and do it well.”

Tell me something about your family background?

First, always feel proud while discussing about your family background. Just simple share the details with the things that how they influenced you to work in an airline field.

Have you ever worked in a customer care or customer service job?

If no then you can simply say no that you are a fresher in this field but have the ability to work effectively than experienced person. If yes than share your past good experiences of customer service along with what and how much you have learned there.

If you were an animal, which one would you want to be?

Interviewers use this type of psychological question to see if you can think quickly. If you answer ‘a bunny’, you will make a soft, passive impression. If you answer ‘a lion’, you will be seen as aggressive. What type of personality will it take to get the job done? So answer this question smartly matching with your personality.

What would you do if any customer complaint about your service?

To handle customer complaints you need to:

  • Listen to the customer to figure out why they are upset. 
  • Listen to the customer to determine whether any of your policies were not abided by or if this is something outside or not contemplated by your systems. 
  • Next put yourself in the shoes of the customer. Given what you now know try and see their point of view. Why did they come to you? 
  • Once you have heard the complaint and understand the basis for the same, elevate the customer to a supervisor or manager where possible. 
  • Defend if you must. But do not fight with the customer.
  • Once you have listened and understood the customer’s complaint and have avoided fighting over the same divert the customer’s focus to how you intend to resolve the matter.
  • Use customer complaints as a manner to learn about potential flaws in your systems. Maintain a manner of tracking customer complaints .
If you are aware about all these steps then you will not face any problem in answering this question.

Describe yourself in one line.

When you respond, keep in mind the type of position you are interviewing for, the company culture, and the work environment. Your answer should help show the interviewer why you’re a match for the job and for the company. Sample answers are:

  • I’m a people person. I really enjoy meeting and working with a lot of different people.
  • I’m a perfectionist. I pay attention to all the details, and like to be sure that everything is just right.
  • I’m a creative thinker. I like to explore alternative solutions to problems and have an open mind about what will work best.
  • I’m efficient and highly organized. This enables me to be as productive as possible on the job.
  • I enjoy solving problems, troubleshooting issues, and coming up with solutions in a timely manner.

Do you think you are overqualified for this position?

It’s an invitation to teach the interviewer a new way to think about this situation, seeing advantages instead of drawbacks. Remember always it does not necessarily mean you are over qualified. Don’t be trapped. The recruiter wants to see you to demonstrate your long term commitment to stay in the airline. The recruiter worries about the position will not stimulate you enough to keep you stay. With a little preparation you can turn this question around and demonstrate the benefits to the airline if you are given the job, rather than purely focusing on why you want
it.

How would you measure your own performance on this job?

This is quite straight question, discuss about the key
performance indices against which your performance was
rated. This also shows your suitability for the position. You may say that the performances can be measure as set of goals that achieve by person in his life. Performances measured by achieving self-satisfaction with our work. So I feel satisfaction is the measure of performance. Or to measure your performance on the job you can do following things:

  • Set up random methods of quality control throughout your airline.
  • Survey your clients about their customer service experience as a way of assessing employee performance.
  • Compare Yourself to the Competition.
  • Understand Your Strengths and Weaknesses.

Find job here...