Everything about Project Management Professional (PMP) Certification and Exam

What is Project Management? Project management is the arrangement of chose strategies, abilities and devices frequently used to accomplish predefined goals of a project. The project manager possesses the duty to finish and convey the project on schedule and inside financial plan getting every one of the interests of customer and partners. At the point … Read more

What is YAML? What does it do?

YAML is an data serialization language. In 2001, YAML meant “Yet Another Markup Language.” The abbreviation was subsequently changed to “YAML Ain’t Markup Language” to underline that the language is proposed for data and not documents. Note: YAML is not a markup language. Official definition: YAML is a human friendly data serialization standard for all … Read more

What is OAuth?

OAuth stands for Open Authorization for token based authentication and authorization over web.OAuth was first introduced in year 2007. In year 2010 OAuth2.0 was introduced. OAuth acts as an agent for a user to fetch the information.OAuth allows a user’s account information to be used by a 3rd party such as Twitter, Facebook, Google, without … Read more

SQL Server Interview Questions Part2

Few important questions for SQL Server asked ASP.Net Developer. Part- 2  Indexes-Indexes are used to query data faster from a table. Indexing avoids full table scan. Create Index IX_customer_amount on tblcustomer (purchase_amount ASC) So this index will store purchase amount in ascending order.Purchase amount20005000550075009000 To view all indexes on a table either go to object … Read more

Difference between Stored Procedure and Function in SQL

Stored Procedure vs Function 1)Functions must return a value. Stored procedure need not be. 2)Stored procedures can be called using EXEC command where as Functions can be called from another SQL Statement. 3)Stored Procedures are precompiled. Functions are not precompiled. 4)Generally Stored procedures are used for executing business logic where as Functions are used to … Read more