Breaking while loop in Java

import java.util.Scanner;

class TestingBreakWhileLoop {
public static void main(String[] args) {
int i;

Scanner input = new Scanner(System.in);

while (true) {
System.out.println(“Input an integer for this test program”);
i = input.nextInt();

if (i == 0) {
break;
}
System.out.println(“You have entered …  ” + i);
}
}
}

What is SQL ORDER BY Keyword

The purpose of ORDER BY keyword is used to sort the results in descending or ascending order

 

e.g SELECT * FROM Users

ORDER BY State DESC;

 

e.g SELECT * FROM Users

ORDER BY State ASC;

 

or

 

SELECT * FROM Users

ORDER BY State;

String reverse using java script split method

Assume given string ‘str’ value is “welcome”
function stringRev(str) {
var splitString = str.split(“”);// Use the reverse() method to reverse the array
var arrayReverse = splitString.reverse(); // equals to [“e”, “m”, “o”, “c”, “l”, “e”, “w”]

// Use join() method to join the elements of the array into a string as below in comments
var joinArray = arrayReverse .join(“”); //  [“e”, “m”, “o”, “c”, “l”, “e”, “w”] to “emoclew”

//Return the reversed string
return joinArray; // “emoclew”
}

stringRev(‘welcome’);

Differences between SQL and PL/SQL

PL/SQL is procedural language where s SQL is data oriented language.
PL/SQL purpose is to create applications but SQL is data manipulator and reviewer
PL/SQL executions works at block of code level while SQL execution is per statement at a time.
PL/SQL servers for building, formatting and display application screens but SQL sources data for that screens.
PL/SQL is procedural based and instructs database on how to do but SQL is declarative level which helps database on what to do.
PL/SQL purpose it to code program blocks, procedures, triggers, functions, and packages but SQL is used to code queries, DCL, DML and DDL statements
SQL can be subset of PL/SQL but PL/SQL can not be subset of SQL
 

 Popular databases or filesystems that uses SQL – Please click here

Defect priority and severity

Severity indicates the seriousness of the defect.
Severity types are Critical, Major, Moderate, Minor, Cosmetic
 
Priority indicates how quickly the defect needs to be fixed.
Priority types are High, Medium, Low.
 

Low Severity and Low Priority: A cosmetic error in a page which is not important to users.

High Severity and High Priority: An error in the login feature which does not allow user to login to application or a server error in the web application.

Low Severity and High Priority : The spelling mistakes that happens on the cover page or heading or title of an application.

High Severity and Low Priority: A page access error which page is rarely used by users.

What is Apex?

Apex is a programming language for salesforce (only)

    • Object Oriented Program, in which the data types have to defined.
    • Allows developers for flow execution in force.com platforms.
    • Enables developers to add business logic to most system events including button clicks, related record updates and visualforce pages.

Datatypes in Apex

  • Primitives

Apex primitives include the following datatypes.

  1. Integer
  2. Boolean
  3. Decimal
  4. Double
  5. Date
  6. Date Time
  7. Time
  8. String
  9. Long
  10. ID- Any valid salesforce.com Id.
  • sObjects
    • Any  object that can be stored in force.com platform database.
    • sObject variable unlike primitive variable refers to row of data in salesforce. That is a complete record as a variable.

What is Salesforce

Salesforce.com is an American cloud computing company.
Salesforce offers Software as a Service (SaaS) platform which helps in Customer Relationship Management.
It has a multi-tenant architecture and subscriptions.

 The following are the application clouds in Salesforce CRM.
1. Sales Cloud
2. Service Cloud
3. Marketing Cloud
4. Data cloud
5. App Cloud
6. Analytics Cloud
7. Community Cloud
Salesforce also offers Platform as a Service (PaaS) using Force.com sites.
People involved in Salesforce Implementation
1. End User ( Customer)
2. Administrator
3. Developer
4. Consultant
The following are the list of Salesforce Certifications.
1. Certified Administrator
2. Certified Advanced Administrator
3. Certified Sales Cloud Consultant
4. Certified Service Cloud Consultant
5. Certified Force.com Platform App Builder
6. Certified Force.com Platform Developer I
7. Certified Force.com Platform Developer II
8. Certified Technical Architect