Tuesday, 23 December 2014

ICELAND FOODS SALES ASSISTANT INTERVIEW QUESTIONS AND ANSWERS

Iceland is the second best growing company of 2014 in UK. So as this company growing, there would be the lots of jobs ahead.
Are you prepare for Iceland Foods sale assistant Job interview questions. We are come with questions and answers which are asked in Iceland Foods's sale assistant Interview. Soon you will get pdf.

1). Why do you want to work here?
Ans: I want to work here because it is very convenient as far as location. Also, I enjoy working with people and I think it will be a great experience for me.

2). if you have a customer who is very rude to you, then how would you handle with him/her being a sales assistant?
Ans: I will deal with them with courtesy and will try to help them out with their problem and if I fail in that then I will get some senior to handle such a customer but I will never be rude.

3). What would you do if a team member isn't contributing?
Ans: I would talk to the member individually and politely telling him what the situation is and if he can try to contribute more it would be both beneficial for him and the team.

4). Did you do any presentations at either school or college?
Ans: The question was along those lines, but I remembered that I was so confident in answering - without hesitation she was very impressed with what I had to say. I mentioned my personal experiences of delivering presentations at college and how they helped me with my skills development.

5). Your biggest flaw?
Ans: That I cant stop something until its perfect!

6). If you were going to handle your stress, what would you do on the job?
Ans: Scream stress relief.

7). What would you do if a customer asked you for help ordering something which is not belong to your department, and you were not trained on the department?
Ans: Go get someone who knows the system...i.e. a member of the home department, or management staff....NEVER say "I don't know" to a customer!
 

Sunday, 21 December 2014

ANGULARJS INTERVIEW QUESTIONS AND ANSWERS PDF FREE DOWNLOAD

Hey this is good news for Angularjs learner that www.dotnet-tricks.com/ Shailendra Chauhan comes with Free Angularjs Interview Questions with Answers PDF.
You can download it Free Of cost..
Or read it....

In Author Words(Shailendra Chauhan)
"AngularJS Interview Questions and Answers book has been written with the intent of preparing yourself with solid foundations on AngularJS – in a short time without wasting your time in googling. As an author, I have tried to present each topic with the help of appropriate questions with answers which have suitable examples."



Click on the following link to download this book.
http://www.dotnet-tricks.com/Home/AngularJSInterviewBook


TOP 300+ SQL SERVER INTERVIEW QUESTIONS AND ANSWERS PDF | FRESHERS AND EXPERIENCED

Now all SQL Server Interview Questions and answers at one place. Here we come with all Sql server questions asked during SQL Interview. This is not matter if you are a fresher or Experienced (DBA), these questions for all, From very simple to very complex. And Soon we come with answers as well as PDF.
So now you don't need to visit here and there for Sql Server Interview Interview/Telephonic Interview Questions.

PART 1 : SQL SERVER INTERVIEW QUESTIONS ANSWERS
1). What is RDBMS?

2). What are the properties of the relational tables?

3). What is Normalization?

4). What is De-Normalization?

5). What is Self Join?

6). What is Cross Join?

7). What are the different types of cursor?

8). What is a default constraint?

9). How to strip all non-alphabetic characters from string in SQL Server?

10). How do I find a value anywhere in a SQL Server Database?

11). Suppose that you have a table with AreaID but for that column you forgot set Identity. later you got it. Now you want to set identity without effecting the current records, and you only enabled Identity with seed 1. Then what would be the next value for AreaID in our below table example?

11.1). How to pass an array(or a table variable) into a SQL Server stored procedure?

12). When should you use "with (nolock)"?

13). Is it possible to insert into two tables at the same time?

14). Preferred Method of Storing Passwords In Database?

15). Can a view be updated/inserted/deleted? If Yes – under what conditions?

16). Where the integrity constraints are stored in data dictionary?

17). How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

18). What is Collation?

19). What is SQL Server Agent?

20). How to convert Rows to Columns in SQL Server?

21). What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

22). Difference between Where clause and Having clause in SQL Server?

23). What is data dictionary?

24). Explain the use of SSIS in BI?

25). In Linq Query why from clause come first as select statement ?

26). What is collation?

27). How to convert a table data in XML format in sql server?

28). What are the different types of locks?

29). What are Pessimistic and optimistic Locks?

30). What is the difference between an Update and Exclusive lock?

31). What is the difference between table and view in sql server?

32). What is NOLOCK hint?

33). What is NOT NULL Constraint?

34). What is the difference between DATETIME2 and DATETIME?

35). Explain Geography datatype in SQL Server?

36). What is nolock hint in sql server 2008?

37). What are the different types of SQL Commands?

38). What is the difference between a DDL trigger and a DML trigger?

39). What are the types of transaction levels in SQL SERVER?

40). Which TCP/IP port does SQL Server run on? How can it be changed?

41). What is @@ERROR?

42). what is the difference between count(*) and count(1)?

43). What are the difference between clustered and a non-clustered index?

44). What's the maximum size of a row?

45). What is HINT?

46). How do you delete duplicate records?

47). How do you delete all tables?

48). What is Aggregate function?

49). What is the difference between a query and stored procedure?

50). What will be the result of this query. select * from TableName order by 1 .Will this query throw an error?

51). What are the different index configurations a table can have?

52). What are the different types of BACKUPs avaialabe in SQL Server 2005?

53). What are the different locks in Sql Server?

54). What is OLTP (Online Transaction Processing)?

55). What's the difference between a primary key and a unique key?

56). What is the difference between DELETE and TRUNCATE statement?

57). What is SQL Profiler?

58). What are Data files?

59). What is difference between DELETE and TRUNCATE commands?

60). When is the use of UPDATE_STATISTICS command?

61). What is the default port of Microsoft SQl Server?

62). What is Data Compression in sql server 2012?

63). What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

64). What is a linked server?

65). What database does SQL Server use for temporary tables?

66). What are different Types of Sub-Queries?

67). What are the authentication modes in SQL Server? How can it be changed?

68). Which command using Query Analyzer will give you the version of SQL server and operating system?

69). What is service Broker?

70). What is the difference between HAVING and WHERE clause?

71). What is a B-Tree?

72). What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

73). What is an active database?

74). .........?

75). Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

76). What is Log Shipping?

77). Name 3 ways to get an accurate count of the number of records in a table?

78). What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

79). What is the difference between a Local and a Global temporary table?

80). What is the STUFF function and how does it differ from the REPLACE function?

81). What is the difference between TEMP tables and Variable Tables?

82). What are the different String Functions in SQL Server?

83). What are the different Index configurations a table can have?

84). What is a Filtered Index?

85). What are indexed views?

86). What is the restriction on Indexed view?

87). What are Statistics? How can you find it in SQL Server?

88). How you can remove time part of datetime in SQL Server?

89). NOT IN vs NOT EXISTS?

90). What are the different Mathematical Functions in SQL Server?

91). What is the difference between COUNT and COUNT_BIG?

92). What is WITH CHECK OPTION on view?

93). What is the difference between INSTEAD OF TRIGGER and AFTER Trigger?

94). How is the ACID property related to the database?

95). What are the different normalization forms?

96). What are different part of a SQL Page?

97). What is the difference between a local and a global variable?

98). What is PRIMARY KEY?

99). What is UNIQUE KEY constraint?

100). What is FOREIGN KEY?

101). What is CHECK Constraint?

102). What is the real time example of RIGHT Outer Join?

103). What are the types of database recovery models?

104). What is NOT NULL Constraint?

105). What are the different data types in SQL Server?

106). What is blocking?

107). What are the different Date functions in SQL Server?

108). How to get @@ERROR and @@ROWCOUNT at the same time?

109). What is a Scheduled Jobs or what is a Scheduled Tasks?

110). What are the advantages of using Stored Procedures?

111). What is a table called, if it has neither Cluster nor Non-cluster Index? What is it used for?

112). Can SQL Servers linked to other servers like Oracle?

113). What is BCP? When does it used?

114). How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

115). What is an execution plan? When would you use it? How would you view the execution plan?

116). What is the difference between CHAR and VARCHAR?

117). What is the difference between VARCHAR and VARCHAR (max)?

118). ..?

119). What are different types of Collation Sensitivity?

120). What is a Stored Procedure?

121). What are the different types of collation sensitivity?

122). What is dirty read?

123). How do you check collation and compatibility level for a database?

124). What is a covered Index?

125). What is the maximum row size for a table?

126). When I delete data from a table, Does SQL Server reduce the size of table?

127). How do you rebuild master database?

128). What is PIVOT and UN-PIVOT?

129). What is EXCEPT operation?

130). What are GROUPING Sets?

131). What are the row constructors inside SQL Server?

132). What are table valued parameters?

133). How do you identify and resolve deadlock?

134). What are Spare columns?

135). How to get last inserted id?

136). Which is database shrinking?

137). What is the maximum number of columns a table can have?

138). What are included columns?

139). What is INTERSECT operation?

140). What is RAID?

141). What are the limitations of Select Into clause?

142). What is FileStream in SQL Server?

143). What do you mean by TableSample?

144). What are the disadvantages of using Stored Procedure?

145). What is the difference between COMMIT and ROLLBACK?

146). What is Transaction?

147). How do you do Error Handling in SQL server?

148). What is RAISEERROR?

149). What is SQL INJECTION?

150). How do you find list of schema names and table names from the database?

151). Why can be there only one clustered index?

152). Can we create view on TEMP table?

153). Can we use constraints on TEMP Table?

154). How to recompile a stored procedure at run time?

155). Does the order of columns in UPDATE statement matters?

156). What are the different types of System database inside SQL Server?

157). What is the use of Transaction Log file?

158). What is the difference between view and Materialized view?

159). What is database mirroring?

160). How does SQL Server database engine work?

161). What is the maximum number of indices per table?

162). What are the purpose of Normalisation?

163). What does the Merge Statement do?

164). What are the new data types introduced in SQL Server 2012?

165). Define Hierarchyid data type?

166). What are synonyms?

167). What is CTE?

168). What are the advantages of CTE?

169). Can we write Sub Queries into Simple Select Using join and CTE?

170). Can CTE be recursive? Till what level it can be nested?

171). What is LINQ?

172). What is XML?

173). How can you find tables without Indexes?

174). How do you find the size of index?

175). How do you copy data from one table to another table?

176). What is ROW_NUMBER()?

177). What is ROLLUP clause?

178). What are ranking functions?

179). How do you stop a log file from growing too big?

180). How do we use DBCC commands?

181). What is CDC?

182). What are the main performance differences between varchar and nvarchar SQL Server data types?

183). What is the difference between varchar and nvarchar?

184). How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?

185). What is the difference between Index Seek and Index Scan?

186). Can we insert data if the clustered index is disabled?

187). What is standby server?

188). How do you disable Index?

189). How do you enable index?

190). What are the steps to create a Table Partition?

191). What are the basics of Table Partitioning in SQL Server?

192). How do you copy tables, schemas, and views from one sql server to another SQL Server?

193). Where are SQL Server user names and passwords stored in?

194). Can we have Triggers on Temp table and Variable Table?

195). What is the syntax for encrypting a column in SQL Server?

196). How do you send email on SQL Server?

197). What is query optimization ?

198). How many maximum Identity columns we can have in a single table?

199). How to find all Triggers in database?

200). Can we add constraint on Variable Table?

201). What is Schema?

202). Can we create multiple constraints on a single column?

203). Can we rename table and column using ALTER command?

204). How to rename Table and Column?

205). How to rename Database?

206). What is the disadvantage of Index?

207). How can we find the table size?

208). How to find N highest salary?

209). What is the difference between data mirroring and log shipping?

210). What are the different backup options within SQL Server?

211). How to add DEFAULT constraint on existing column? Write query

212). How to add NOT NULL constraint on existing column? Write query

213). How do you find why query is running slow?

214). How to create foreign key constraints on temporary table?

215). What is Dynamic SQL?

216). Can we create a table name as Table?

217). What is the difference between CAST and CONVERT Function?

218). What Are Binary String Data Types?

219). How to execute Dynamic SQL?

220). Can we use Variable table in Dynamic SQL?

221). How to execute queries stored in a table?

222). How can you capture the length of column when it is text, image and ntext data type?

223). Is it possible to import data using TSQL?

224). How can you prevent TSQL code from running on a Production server?

225). Define Unique Key?

226). What is the use of SP_Helptext , SP_HelpIndex stored procedure?

227). Can we change order of triggers?

228). What do you understand by Joins in SQL Server?

229). How to disable Auto Commit in SQL Server?

230). Can we recover deleted data?

231). How to delete Top 100 records from a table?

232). How to delete two tables using one Drop command?

233). Can I create CTE in Trigger?

234). Can we create Variable table in Trigger?

235). Can we use cursors in Trigger?

236). Can we call Stored Procedure in Trigger?

236). Can we call Stored Procedure in Trigger?

236.1). Can we call Stored Procedure in a View?

237). Can I create Triggers on TEMP table?

238). Can we use PRINT Command in Triggers?

239). How Triggers are fired?

240). Why do we use DECLARE for cursor and Variable table?

241). How to take database online –offline?

242). How to copy data using Bulk copy when columns data type doesn’t match?

243). What is SP_Configure commands and SET commands?

244). Can Inserted table have multiple records?

245). Can we perform DML & DDL operation on Inserted and Deleted tables?

246). What is the advantage of Index?

247). Which is fast UNION or UNION ALL?

248). Can we create clustered index on view?

249). Can we create computed columns?

250). Can we change the Column Sequence order inside table?

251). Truncate is DDL or DML?

252). Can we create view from view?

253). What the difference between UNION and UNIONALL?

254). How to join two tables from different database?

255). Can we use ORDER BY Clause in UNION?

256). What is difference between Deterministic and Non Deterministic Functions?

257). What is Synchronous and asynchronous function?

258). Can we add Identity column after creating the table?

259). Can we drop Identity column?

260). Can we store Image, MP3 and binary data in SQL Server?

261). How can we disable Identity column?

262). Can Foreign key column have NULL?

263). How to find column description of a table?

264). How to delete Duplicate records?

265). How to find employees hired in last month?

266). How to find all rows that contains only numeric data?

267). How to find primary key name if not given by the user for a particular column?

268). Can we add two columns using ALTER command?

269). How to get row number without ROW_NUMBER function?

270). What is Partitioned View?

271). What is the difference between UNIQUE Key and Primary Key?

272). How to find who deleted/ dropped from Transaction log?

273). Can we ALTER two columns using ALTER command?

274). How to clean Buffer in SQL Server?

275). How to clear Execution Plan cache?

276). How can we check for existence of any object in database?

277). What is meant by differed name resolution in SQL Server?

278). How to find Organization Employee Hierarchy using SQL?

279). How does a recursive CTE works?

280). What is Auditing inside SQL Server?

281). What is the difference between GETDATE() and SYSDATETIME()?

282). How do you check if Automatic Statistic Update is enabled for a database?

283). What are the limitations of view?

284). How to find department with highest number of employees?

285). What are different operation available on ONDELETE and ONUPDATE?

286). What are the uses of System tables?

287). What are WAIT Types?

288). What is Data Page?

289). What is FILL Factor?

290). Sql server difference between view and stored procedure?

291). Sql server difference between unique and nonunique index?

292). Sql server difference between update lock and exclusive lock?

293). Sql server difference between windows authentication and sql server authentication?

294). Sql server difference between sysobjects and sys.objects?

295). Sql server difference between session and connection?

296). Sql server difference between set and select variable?

297). Sql server difference between shrink database and shrink files?

298). Sql server difference between revoke and deny?

299). Sql server difference between rank and dense_rank?

300). Sql server difference between gdr and qfe?

301). Sql server difference between db_owner and dbo?

302). Sql server difference between log shipping and mirroring?

303). Sql server difference between isnull and coalesce?

304). Differences between ISNULL and IS NULL?

305). Difference between hadoop and sql server?

306). Difference between PatIndex and CharIndex function in SQL SERVER?

307). What is the difference between SQL Server standard and web edition?

308). Difference between numeric,float and decimal in sql server?

309). Difference between binary and varbinary datatype in Sql server?

310). Sql server difference between count(*) and count(1)

311). Sql server difference between exec and sp_executesql?

312). Difference between blocking and deadlock sql server?

313). Difference between detach and take offline in sql server?

314). Difference between Index Scan / Index Seek in sql server?

315). What is the difference between TRY_CONVERT and Convert?

316). Write down the query to get the list of tables changed with in the database in last 5 days?

317). Write a query to insert your name 1000 times without Using While Loop in SQL Server?

318). SQL Server 2016 came with new way to drop object if exist, Explain it.(DROP IF EXIST)

322). What do you understand by index_id = 0 and Index_id = 1, related to sys.indexes table? What they represent?

323). What are NDF files in SQL Server?

324). What is the difference between DateTime and DateTimeOffset data types in SQL Server?

325). What is Slot Array in Sql Server? How it is related to Database Page?

326). What is the extension for trace file in SQL Server Profiler? 

327). How to pass an array(or a table variable) into a SQL Server stored procedure?

328). What is forwarding pointer in SQL Server? How it is helpful in performance optimization?

329). How you will trace all event only from a selected Database or Procedure using SQL Server Profiler?

330). What is the difference between SQL, PL-SQL and T-SQL?

331). Name any three standard trace templates provided by SQL Server Profiler?

332). Can you edit Sql Profiler existing/default templates?

333). How to strip all non-alphabetic characters from string in SQL Server? 

334). Database dot dot TableName(Database..TableName) will point to which schema in SQL Server, Is this way to select data will fail or not?

335). Write down the query to get list of all supported language by SQL Server?

336). Name the SQL Server functions used to encrypt and decrypt password?

337). What would be the output of the following script?
    DECLARE @Name VARCHAR(20)
    SET @Name = 'विकास अहलावत'
    SELECT @Name

338). What is the backup strategy in your organization? (TCS)

339). How to split a comma-separated value to columns?









340). What would be the output of following SQL Script.






341). What is the difference between Master, MSDB,TempDB and Model Databases?

342). What is the main rule of first normal form? second form ? third form?

343). What is the difference between Data files and Log Files in Sql Server?

344). How you will select all records using TOP keyword in SQL Statement, even you don't know the count of table?

345). How you will change the font size/style in SQL Server?

346). What will be the output of the following query?

347.) Suppose you have following table"TestUpdate".

SELECT * FROM Testupdate










What would be the output of following query?
UPDATE Testupdate SET ID = ID + (SELECT MAX(ID) FROM Testupdate)
SELECT * FROM Testupdate

348). Suppose you have above table"TestUpdate". then what would be the output of following query?
UPDATE Testupdate SET ID = ID + (SELECT MAX(ID) FROM Testupdate)
GO 2
SELECT * FROM Testupdate

349). Will Non-Clustered Index used every time by SQL Server Engine? Asked in HCL/Unitedhealth Group

350). What do you understand by Column Density in SQL Server?

351). How column Density is effect to Index?

352). What Execute in SQL Server First?
A) WHERE
B) SELECT
C) ON
D) FROM
E) TOP

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

354). What do you understand by "Sp_MSforeachtable", Please explain?

355). What will execute first tell the order of every keyword used in below query?(Wipro/Sapient)
356). Write query to show marks as below

357). What do you understand by sp_MSForEachTable?

358). How you will replace "A" with "B" and "B" with "A" in following string "ABAB"?(HCL)
http://www.interviewquestionspdf.com/2017/05/sql-server-replace-tricky-query-asked.html


359). How you will print table using SQL query?(HCL)
http://www.interviewquestionspdf.com/2017/05/how-you-can-print-1-to-10-table-using.html




360). What would be the output of following script. (asked in TCS with more nested question)






361). How to Generate Sequence without using Ranking functions in SQL Server?






362). Repeat Rows N Times According to Column Value in SQL Server?




363). Which built-in function returns the number of active transactions?


What Do you think this is ending of SQL Server Interview Questions?
NO

PART 2: SQL SERVER INTERVIEW QUERIES QUESTIONS ANSWERS
CLICK HERE FOR SQL SERVER INTERVIEW QUERIES (MORE THAN 100 INTERVIEW QUERIES)

Reference :
http://stackoverflow.com
http://www.c-sharpcorner.com/

Saturday, 20 December 2014

TELEPHONIC INTERVIEW TIPS PDF | POINT TO REMEMBER | CRACK EASILY

Telephonic Interview tips, What to do and not do | HOW TO CRACK TELEPHONIC INTERVIEW

Telephone interviews are now becoming the most popular types of interviews. Due to the advantages of less time consumption, less cost for conducting interview, many interviews conducted in less time, etc. it has now become one of the type of basic clearance or barrier which one has to clear to appear for a face to face interview.
Many big companies use telephone interviews in order to shortlist a few candidates out of many. Now to get into those few selected candidates you need to prepare a little for the phone interviews

Preparation:
Make sure that before you appear for a telephone interview, you are fully prepared to face it
It is suggested to find a silent a calm place so that there is no distractions and disturbances in the communication process.
Move into a place where you can think positively and can answer your questions asked to you with a free mind.
Keep your resume, a notebook, a pen and some notes already prepared about commonly asked questions in interview.
Try to disable or divert other calls which may come to you while the interview is going on.
Practice:
“Practice makes a man perfect.”
Practicing is very important as it will bring some confidence to you. You can practice a rehearsal with your friends.
What you should possibly do while appearing for a telephone interview:
1) Address the interviewer professionally.
Introduction and addressing the interviewer needs to be formal. Address them with proper salutations, don’t do a blunder by calling them with their names.

2) Speak in a uniform voice
Don’t rush in a hurry to say what you want to say, answer them in a pretty low and formal voice.

3) Take your time.
Don’t rush the interview. If you’re feeling nervous take a moment or two to collect your thoughts.

4) Listen to the complete statement of the interviewer and then answer.
Answer the questions which are being asked. Do not make the mistake of telling the interviewer what you want to tell them. Give them the answers to their questions.
Note: Let them complete themselves before you answer. Don’t be in a hurry of missing the train, trust me I can’t say about the train but you will definitely miss the job.

5)  Ask them questions
Asking questions implements a good level of conversation between both, the interviewer and the candidate. Most the jobs that require an employee with better speaking skills are recruited through the phone interview.
This is a straight way for the employer to examine the speaking skills of the candidate. Job interviews for call centers, online data entry, marketing, public relations, etc. are done on phone.

6) Remember to smile.
Experts say that smiling puts you in a better state of mind and will project a positive image to the listener. This will also keep your voice calm and help you answer politely with the interviewer.

7) Don’t forget to breathe.
It will help you stay calm and sound more relaxed. Interviews are times when people generally feel nervous, breathing normally will make you confident about yourself and your answers. If you don’t breathe well you may have some errors while speaking fluently.

8) Be prepared with “Notes”.
Be prepared with some notes about questions that are generally asked in interviews, this will help you a lot.

9) Keep a glass of water handy.
Nothing is worse than having a dry mouth. Some people may have the problem to their mouths drying during the interview. Don’t worry about it, this is just because you were feeling a little nervous at the time of the interview. Drinking water in regular breaks while listening to the interviewer will solve your problem.

10) Give them a researched answer.
Be ready with a little research about the firm which is going to call you for the phone interview. Answering their questions with respect to their values will help you to finish your interview a little earlier and a good chance of getting selected as well, because this trick can impress the employer and he will really appreciate your motivation for working with them.

What NOT to do during the phone interview:
1) Don’t eat anything, drink or chew a gum.
You may feel that these activities are not being noticed by the interviewer, but trust me you are fooling yourself. These activities will distract your mind from thinking and you will end up answering worthless answers.

2) Avoid smoking.
Smoking is an addiction with almost every fifth guy. Smoking may cause you to cough loud during the interview which is not a good sign. Even if you are a regular smoker please avoid smoking during the interview as this will also distract your mind and your will end up with a blunder.

3) Avoid interrupting the interviewer.
As mentioned earlier, let the interviewer complete himself and only then you should answer. You don’t have the rights of interrupting them as they are not your friends. The employer will take this as a sign of over smartness and will straight away reject you.

4) Answers in “yes” and “no” will not do.
Elaborate your answers, provide examples if applicable. Elaborating yourself also adds to your speaking skills which many call centers and telemarketing companies would want in their employees. You can use cheat nodes in case you find difficult to remember big sentences.

5) Avoid being too casual/informal.
Don’t try to be much formal by just supporting them on their statements, many interviewers play a trick to find how logical thinker or creative the candidate is. Remember that they are not hiring a servant, they are hiring an employee.

6) Avoid Jumbling up with your answers .
Your answers should be understood straight forward, don’t try to answer much deeper, answer only what is asked to you.

7) Avoid showing your nervousness
Avoid using sounds like “aa…a” in your answers, this will never help you. Be confident about what you are saying.

Last words,
Phone interviews are the easiest one to master as you don’t have the fear of facing the interviewer face to face, but on the other hand a little preparation is very important.
Many leading companies knock-out a large number of job applications by conducting phone interview before the face-off interview, it is advisable to follow the dos and don’ts suggested in this article to nail the telephone interview.
Readers will be appreciated if they share their experiences and views about the phone interview.

How Answer Behavioral Interview Questions | Top 10 Sample/Example

Simple steps to answer Behavioral Questions
Behavioral questions are the most crucial part of an interview, these kind of questions do require a homework done from your side in advance to crack them. These kind of questions are asked by the interviewer to check your abilities in applying the knowledge and experience from your past in the situations or circumstances that may probably occur in the future.
To solve this question you should have good thinking and vocabulary skills. These type of questions check your practical knowledge of how would you handle situations practically if they arise in your profession in future.
Cracking these questions is very simple if you have done your homework.
Before discussing on how to answer them, I want you to do your homework. Take a notebook and a pen. Start thinking in your past and list out some of the events about your education, work experience, community work, charity etc.  that had proved these qualities of you:
        • Leadership
        • Flexibility
        • Motivation
        • Commitment
        • Initiative
        • Teamwork
        • Responsibility
        • Decision making
        • Communication
        • Trustworthiness
        • Problem solving.
For example:
If in your life time so far, you had witnessed that one of your decisions proved to be very beneficial either for you, you’re classmates, your school or your friend. Just list that event in the book, write about what problem was your friend facing and what decision you gave to him that was beneficial to either of you.

Similarly, think of some different events that highlighted the qualities of you mentioned above.
Answering the Behavioral questions
To answer any behavioral question, you just need to follow the STAR format.

Now what is this STAR format?
STAR stands for Situation, Task, Action and Result.
Situation:
           The interviewer will ask you to mention about your abilities and an event of your life that
           highlighted the use of that ability.
Task:
           What you were trying to achieve?
Action:
           What problems did you face and what use did you make of your abilities to get things going in
           your way.
Result:
          After performing the action what result did you achieve?

Here are a few questions that will help you to understand how to deal with behavioral questions in a better way:
Example 1:
“Give me an example of a time when you set a target and successfully achieved it”
Situation:
           My role as an event manager was to manage to host best possible event in a given budget we
           had collected from our sponsors.
Task:
          I took the initiative and combines two floors of the college building rather than taking a private
          hall for the same. I had conducted a meet with the participants and the event heads for each
          event. We agreed a condition to make full use of what we had and minimizing the cost up to
          the lowest we could.
Action:
         All the event heads agreed to this and we had all of them working in a team.
Result:
        As a result of this more efficient working time we hosted a successful event on time and reduced
        costs by 20%. This new way of using the college premises has now been implemented as a
        permanent venue to host the events of the college.

Example 2:
 “Provide an example of when you showed initiative and took the lead.”
 Situation:
             In a college technical festival
Task:
            There was a technical problem in the LAN network of the college where the server was not
            functioning well. This network was going to be used for hosting a various gaming events in   
            the college fest.
Action:
            I took an initiative and got a few of my friends with me and replaced the complete connection
            network with another server.
Result:
           We successfully managed to shift to a new server in less than an hour and the events were
           conducted successfully.

Example 3:
 “Tell me about a situation where you have had to speak with an unhappy customer.”
Situation:
           Two years back, I was working in an insurance company
Task:
           I met a person who was initially cheated by some chit fund company in his past, he was not
           willing to take a policy for the very same reason that he was cheated initially and was not
           happy with policy I had presented to him.
 Action:
           I explained him about my firm’s statistics and records over the past years, I also made him
           consult a few of our policy holders.
Result:
          I successfully managed him to convince him to prefer my firm to take a new policy.

More tips to tackle the Behavioral questions:

1) Select a Strong Example:
Choose a genuine and a strong example that will prove your ability in a better way and apart from that it should also make a respectful image of yours in the mind of the interviewer.

2) Be Specific About Your Actions
Be specific of what type of actions you are going to use to explain your answers to the interviewers
Try to use the best of your vocabulary skills to explain them.

3) Practice
 
“Practice makes a man perfect”

Due to nervousness in the interview hall you may feel a little short of words while explaining your answer, so it is advisable to practice as many times as possible before the interview.

Top 10 Behavioral Interview Questions with Answers Sample/Example

Some sample behavioral questions you should practice well in advance:
1) Give an example of a problem you had with your classmate and how you overcame it?
2) Describe a situation when you had to make a new decision all of a sudden?
3) Give an example of a time when you used good decision making for solving a problem.
4) Give an example of a situation when you were in pressure and how did you overcome that situation
5) Provide an example of a time when you felt you were able to motivate your juniors.
6) What will you do if we will force you to go for a location which you didn't opt?
7) Tell me about a time when you were successful in a team environment?
8) Share an incident about you contributing in your team in the absence of your senior?
9) Give an example of when you had to use different management conditions for different kind of people.
10) What was your most difficult decision in the last 2 years? What did you find difficult in it?

Last words:
Behavioral questions are the questions that really examine you, please avoid skipping them for your interview. pdf will be available soon. just comment your email id.
 

Wednesday, 17 December 2014

Dreamweaver CS6/ 8 Keyboard Shortcuts PDF FREE DOWNLOAD with Images | Gif

 Here we are come with many of Dreamweaver 8/CS5/CS6 keyboard shortcuts. as seeing the success in our last "Google Chrome Keyboard Shortcuts", This time we come with new Keyboard shortcuts for web Designer, As every one know Dreamweaver is very useful tool to design HTML Page, So Its very impotent to keep in mind the very common keyboard shortcuts of this Tool, and the latest version of Dreamweaver is CS6, So we come up with latest version's shortcuts, For get free pdf leave your email id in comment section, We will send it to you as a PDF.

1). F10 : Code Inspector Menu


2). Shift + F11 : CSS Style

3). Ctrl + Shift + Hyphen(-) : Delete Column


4). Ctrl + Shift + M : Delete Row


5). Ctrl + G : Go to Line


6). Ctrl + Atl + I : Select Image

7). Ctrl + Shift + A : Insert Column

8). Ctrl + M : Insert Row

9). Ctrl + Alt + M : Merge Selected Cells


10). Ctrl + Shift + Space : Non-Breacking Space()

11). F4 : Show/Hide Panels

12). Ctrl + F3 : Properties

13). Ctrl + Alt + S : Split Cell

14). Ctrl + Alt + T : Insert Table

15). F9 : Tag Inspector

HOW PREPARE FOR JOB INTERVIEW | HOW ANSWER MOST COMMON INTERVIEW QUESTIONS PDF

Mastering a Successful Interview | Crack Interview | Top 15 Common/FAQ Internship Interview questions with answers | Best Interview Tips/Tricks 
All in one successful interview secret and story.

What is an Interview?
Interview as defined on Wikipedia “An interview is a conversation between two or more people where questions are asked by the interviewer to elicit facts or statements from the interviewee. Interviews are a standard part of journalism and media reporting, but are also employed in many other situations, including qualitative research.”

Interview is a formal process of qualitative research which generally has an employer or a hiring manager called the interviewer who asks questions to the candidate to know about his experiences and abilities. Interviewing, when considered as a method for conducting qualitative research, is a technique used to understand the experiences of others.

I am sure, since you are here you are definitely going to appear for a job interview or interview for various posts in an organization. Interviews are all about research, vocabulary skills, knowledge and speaking skills to put forward your abilities to get a job.

If you are going to appear for an interview, here are the steps from the basics you need to follow to master a successful interview.

“Congratulations Mr. XYZ,
You have been selected for the interview.”

This was the message you were waiting for, and the time has come to prove your abilities. The time has come to walk for the interview. But before you step out, please complete the following homework for the Interview.

Research:
Research about the company is the most important job you need to do before you walk in for the interview. 30% of the questions asked by the interviewer is about the company. They want you to know about the company where you have applied for a job before you walk in for the interview. Now the question is what really you need to know about the firm.
Many candidates do this by going to the company’s website and checking out the ‘About us’ pages on their website. This is not a wrong step, you will get the following details about the company there such as:
     • Establishment year.
     • Their achievements.
     • Their Head employees
     • Their Branches, etc.

But this doesn’t matter much helpful to you and hence it is an incomplete research. You need to know the following thing about the company very well:
     • History of their business
     • What types of services does the company deal with.
     • What are current projects they are trying to develop?
     • Number of employees the company has recruited.
     • Market share.
     • Competitors, etc.

This research will help you to frame your answers to behavioural and hypothetical questions asked by the interviewer with respect to their company’s values.

Interview Questions
After getting a brief understanding about the company, now is the time for you to prepare yourselves to answer the questions that will be asked to you at the interview.

Generally the interviews start with some formal and basic questions and then they follow behavioural and hypothetical questions.
What are the formal questions?
Formal questions deals with the interviewer asking you to introduce yourself, asking you about what you know about the company, your purpose of joining, your ambition and motivation.
These questions are the basics and you can expect them to be asked for any job interview no matter you have applied as a pizza delivery boy or a manager.
There are hundreds of such questions, but the most frequently asked of them are shortlisted below:
 
 
Top 15 Most Common Interview Questions | FAQ
 
1) “Introduce yourself” or “Tell us about yourself”
This is a very common question which is asked, and a good preparation for this question can serve as a solid first impression of you to the interviewer. You should be prepared for this before entering the interview hall.
Tips:
      • Say about yourself. Introduce your name, your qualifications from XYZ   
        College, your achievements, etc.
      • Be prepared for it from your place and do have a practice of it with your friends
      • Speak fluent English, use the best of your vocabulary skills.
        Point to Remember:
     • Do not talk about the members in your family and their business.
     • Do not talk about your friends and what are they doing.
     • Don’t even mention the recent place where you go for a picnic or the latest movie you 
       watched, this might seem a little funny but there have been such cases and those candidates were
       fired straight away.
A good introduction completes half of your interview successfully, rather on the opposite side a bad introduction can spoil your interview as well.

2) Why did you leave your last job?
This is a common question which is asked to people who were already employed before coming for this interview.
Tips:
      • Tell them that you are interested in working with them and you left the job because you found
         new opportunities here.
      • Don’t mention them about the salary even if you were paid less there.
      • Don’t talk something wrong about your last job, employer or the firm even if you didn’t like it.

What to do if you were fired?
Be honest!!
If you were fired then please tell them the truth, because they will have a background check before recruiting you. And if they found it later then this will create problems for you and your career.

3) What is your greatest strength?
Do say true about what all abilities you possess, because whatever you say will be examined by asking behavioural and hypothetical questions. And if you fail there, then you will definitely loose the job.

4) Tell us about your weaknesses
Your weaknesses are that information about you that should not be shared to everyone. If you mention some weaknesses then make sure your weaknesses do not affect your job.
Don’t even say that you are perfectionist with no weaknesses, because if you will dare to say this then this will be one of the interview which you will remember for your lifetime for sure.

5) What do you know about the company?
You can share the research about the company you have made before coming for the interview. Do mention the positive points about the company and the projects that the company is working on these days.
Tip:
You can suggest something from your side about how you could bring some vital changes to these projects and how will your knowledge be contributing to it.
Point to remember:
Don’t take anything ill about the company or else your job will be in trouble.

6) Where else have you applied apart from here?
Don’t lie this information if you have applied somewhere else, but in case if you have applied at many places then do just mention only a few of them.

7) Where do you see yourself in the next five years?
This question is asked to know how ambitious you are. This is an easy question nut still people make blunder.
The most common blunders are that people mention themselves working at a bigger firm than where they have applied for, even if you are taking this job for learning or for temporary and later on you are going to kick this job, please do not mention about this.
A good answer to this can be a researched one such as “I find myself at the post of a senior in this company and would work hard with the other employees to take this company on a much higher level.”
Such answers will give an impact that you are really bothered about your work and position in the company.

8) Why have you applied for this job?
This is a fair enough easy question. You can say that you are interested in the opportunities that will be given to you by this job and you want to utilize your abilities for the development of this company.
Please don’t mention that you are here for money,
Everyone works for money, no one is here to hire himself for free. The employer knows the fact that you are here for money but he asks this question to you to see how you look at this job.
So better avoid saying money.

9) Why should we hire you for this job?
This is an innocent question and the best answer to it is because you are the best person who is fit for this job.
Some candidates to say about their achievements and abilities, but trust me guys all that is mentioned in your resume. Don’t make a blunder of it by explaining stories about your past to them.
You can add about how your abilities will prove as an asset for the company,

Example:
If you have applied as a marketing manager, you can say that you are good in interacting with people and you have good contacts in various industrial and service sectors which will help the company to maximize its profits.

10) How do you handle pressure?
You should answer this question in a positive manner, if you say that you lose your temper or just keep yourself away from work under pressure then that will not help you get the job.
Instead you can say that you handle pressure properly and add one of your life event as an example where you came under pressure conditions and performed well.

11) How do you handle change?
This is one of the questions that makes the candidate think over for his answer.
A best answer to it can be that you look towards the change in a positive way rather than opposing the cause for it, you work harder and get the things done in your favour.

12) What is an ideal job for you?
Many would answer earning billion dollars for just working for 2-3 hours per day or perhaps playing cricket for the country.
These type of answers generally don’t help much.
I would suggest you to keep it simple and just say about what kind of job you have applied for in that firm. This will leave a positive impact on interviewers about you.

13) What motivates you to work hard?
Everyone is motivated by the salary they get for their work, the bonuses, the promotions, etc.
I would suggest don’t mention it directly, add some role of the company that motivates you as well
Example:
You can say that the promotions you get after working harder for this company to take this company to a next level of success makes you feel happy and motivates you.

14) How would your colleagues describe you?
This is the chance given to you to show about your attributes and talk something impressive about yourself. Don’t waste this opportunities by just saying them in simple English, use your vocabulary skills to describe yourself in some powerful words such as
      • Resourceful
      • Respectful
      • Creative
      • Committed
      • Conscientious
      • Dynamic
      • Hard Worker
      • Attentive
      • Confident
      • Trustworthy
      • Direct
      • Persistent
      • Methodical
      • Motivated
      • Objective
      • Tenacious
      • Sociable
      • Reliable
      • Trustworthy.

15) What are your salary expectations?
This is the question where many of them get tricked. Earning as much money as possible is the final goal of every candidate applying for the job. Many end up sharing their personal expectations, but this doesn’t help. The best way to answer this question would require some research about the market value of this job.
If you are looking for a job that pays a salary of Rs.10 lakhs per annum and the job for which you have applied pays you only Rs.5-6 lakhs, that will not help you because even if you get the job your focus will be diverted to jobs which pay you up to your expectations and you will end up losing your interest in the current work you are doing.
Show the employer that you researched the job and you know how much it pays.

Example:
A bad answer can be “I’m easy with whatever you guys will be paying me”.
A good answer can be the researched one “From my research, I know the salary range for this position is between Rs.5-6 lakhs per annum, and having worked in the industry for 5 years I feel that my value would fit into this range”.

Last words:
The questions listed above were the most frequent general questions asked in various interviews. As mentioned earlier there may be thousands of such questions. We will appreciate if the readers share about their experiences and thoughts as well in the comment box. Readers can feel free to come up with other questions and we will find a better solution for their questions as well.

Tuesday, 16 December 2014

The Internship Movie Google Interview Questions | Funny Interview

Funny Google Interview : Internship Movie
Today I saw the "The Internship" Movie relate to Google Job and Interview process. So I want to share something about this movie, Movie is great!! In this movie Billy (Vince Vaughn) and Nick (Owen Wilson) are salesmen whose careers have been torpedoed by the digital world. Trying to prove they are not obsolete, they defy the odds by talking their way into a coveted internship at Google, along with a battalion of brilliant college students.

Funny Interview clip.

Funny right?
1 Question: Are you setting in a library?

2 Question: If you have no computer then, I you do coding etc?

3 Question: How do you get a job, or an internship, you are not qualified for?
Ans: "I am in fact qualified, and here’s why."

4 Question: You are shrunken down to the size of nickels and dropped to the bottom of a blender. What do you do?
Ans: "You take her flat on your back just like this," says Vince Vaughn.
"Right, right, right,” add Owen Wilson. “Just lay back and enjoy that breeze."

“It’s not so much getting out of the blender, it’s what happens next,” said Vince Vaughn. “That’s the question.”
“You’ve got two nickel-sized men free in the world. Think of the possibilities,” said Owen Wilson.
“I mean, on top of my head, and I’m just speculating, sunglass repair,” explained Vince Vaughn. “We’d be hell on those little screws.”
“Maybe stick us in those submarines that they put in people’s bodies to fight diseases,” concluded Owen Wilson.

For more watch the clip.

Tuesday, 9 December 2014

Automate/Scheduled Database Backup SQL Server 2012 Express | SSIS | T-SQL

Here we will create and ETL which will keep full database backup of last 7 days. And will remove the older backup file/folder with are older than 7 days.
This we will do by SSIS and we will use T-sql script for take backup.
This T-Sql Script will take backup of all your database excluding ('master','model','msdb','tempdb') databases.
I think that you know SSIS, So lets create an ETL(dtsx file)/SSIS project
Drag and drop following 7 containers and connect with your server.

1). Check Database Integrity
(Check the allocation and structural integrity of user and system tables, and indexes in the database)
2.) Shrink Database Task
(It reduces the size of SQL Server database data and log files)
3). Reorganize Index
(Reorganizes indexes in SQL Server database tables and views)
4). Rebuild Index
(Rebuilds indexes in SQL Server database tables and views)
5). History Cleanup
(History Cleanup task, a package can delete historical data related to backup and restore activities, SQL Server Agent jobs, and database maintenance plans.)
6). Take the full backups and store it in E:\Vikas Ahlawat\CURRNET PROJECTS\DB Backup SSIS\DB_BackupPlan\DB_Backup_Daily\<yyyymmdd>\
Following is the T-Sql backup script you can use
 EXEC SP_CONFIGURE 'show advanced options', 1  
 RECONFIGURE  
 EXEC SP_CONFIGURE 'xp_cmdshell', 1  
 RECONFIGURE  
 DECLARE @folderdate VARCHAR (50) --The subdir for my backups with Format YYYYMMDD  
 DECLARE @cmd VARCHAR (4000) --The command to create Subdir  
 DECLARE @name VARCHAR(50) -- database name   
 DECLARE @path VARCHAR(256) -- path for backup files   
 DECLARE @fileName VARCHAR(256) -- filename for backup   
 SELECT @folderdate = CONVERT(VARCHAR(20), GETDATE(), 112)   
 SET @path = 'C:\Backup\' + @folderdate + '\'  
 SELECT @cmd = 'md "'+@path+'"'  
 EXEC master..xp_cmdshell @cmd, no_output  
 DECLARE db_cursor CURSOR FOR   
 SELECT name   
 FROM master.dbo.sysdatabases   
 WHERE name NOT IN ('master','model','msdb','tempdb')  
 OPEN db_cursor    
 FETCH NEXT FROM db_cursor INTO @name    
 WHILE @@FETCH_STATUS = 0    
 BEGIN    
     SET @fileName = @path + @name + '.bak'   
     --Full  
     BACKUP DATABASE @name TO DISK = @fileName WITH NOFORMAT, NOINIT, SKIP, REWIND, NOUNLOAD, STATS = 10  
     FETCH NEXT FROM db_cursor INTO @name    
 END    
 CLOSE db_cursor    
 DEALLOCATE db_cursor   
 EXEC SP_CONFIGURE 'xp_cmdshell', 0  
 RECONFIGURE  
 EXEC SP_CONFIGURE 'show advanced options', 0  
 RECONFIGURE  
7). Delete the backup files which are older than 7 days. (Powershell Script)
For this you can user Powershell Script, to create it use notepad file and write the following code and save as .ps1 file.


$Today = Get-Date


$DaysToKeep = "7"


$TargetFolder = "E:\Vikas Ahlawat\CURRNET PROJECTS\DB Backup SSIS\DB_BackupPlan\DB_Backup_Daily"


$LastWrite = $Today.AddDays(-$DaysToKeep)


 


$Folders = Get-ChildItem -path $TargetFolder |

Where {$_.psIsContainer -eq $true} |

Where {$_.LastWriteTime -le "$LastWrite"}

 

foreach ($Folder in $Folders)

{

    if ($Folder -eq $null) {

        write-host "No folders to delete" -foregroundcolor "Green"

    }

    else {

        write-host "Deleting "$Folder.FullName -foregroundcolor "Red"

        Remove-Item $Folder.FullName -recurse -Confirm:$false

    }

}


After create this you can use this script in SSIS by using Execute process task

It will automate your backup process. So you don't need to take backup manually or delete older backup file. All thing is done by above ETL. You can schedule it as a Job in Sql server Agent. Which will run on a particular time everyday.