Topics
1. Know Your TCS (KYT) - 5 Marks
2. Business Skills - 5 Marks
3. UI (HTML, CSS, Javascript) - 10 Marks
4. Unix - 5 Marks
5. Core java - 15 Marks
6. SQL & PL/SQL - 10 Marks
PL/SQL
PL/SQL follows a block-structured approach, dividing programs into logical blocks of code.
Each block consists of three main sections −
● Declarations: This section, starting with the keyword DECLARE, is optional and used
for defining variables, cursors, subprograms, and other elements required within the
block.
● Executable Commands: Enclosed between the keywords BEGIN and END, this
mandatory section contains executable PL/SQL statements. It must include at least
one executable line of code, even if it's just a NULL command indicating no action.
● Exception Handling: This starts with the keyword EXCEPTION, this optional section
deals with handling errors in the program through defined exceptions.
PL/SQL statements are terminated with a semicolon(;). Additionally, blocks can be nested
within each other using BEGIN and END keywords.
PL/SQL saves time on design and debugging by strong features, such as exception handling,
encapsulation, data hiding, and object-oriented data types.
DECLARE
message varchar2(20):= 'Hello, World!';
BEGIN
dbms_output.put_line(message);
END;
/
PL/SQL identifiers are constants, variables, exceptions, procedures, cursors, and reserved
words. The identifiers consist of a letter optionally followed by more letters, numerals,
dollar signs, underscores, and number signs and should not exceed 30 characters.
By default, identifiers are not case-sensitive. So you can use integer or INTEGER to
represent a numeric value. You cannot use a reserved keyword as an identifier.
The PL/SQL supports single-line and multi-line comments. All characters available inside
any comment are ignored by the PL/SQL compiler. The PL/SQL single-line comments start
with the delimiter -- (double hyphen) and multi-line comments are enclosed by /* and */.
A PL/SQL unit is any one of the following −
● PL/SQL block
● Function
● Package
● Package body
● Procedure
● Trigger
● Type
● Type body
Core Java
1.Abstract: A non-access modifier. Used for classes and methods: An abstract class
cannot be used to create objects (to access it, it must be inherited from another
class). An abstract method can only be used in an abstract class, and it does not
have a body. The body is provided by the subclass (inherited from)
2. Byte: A data type that can store whole numbers from -128 and 127
3. double : A data type that can store fractional numbers from 1.7e−308 to
1.7e+308
4. float: A data type that can store fractional numbers from 3.4e−038 to 3.4e+038
5. final: A non-access modifier used for classes, attributes and methods, which
makes them non-changeable (impossible to inherit or override)
6. Access Modifiers: Access modifiers determine the visibility and scope of classes,
constructors, variables, and methods. They control which other parts of your
program can read or manipulate a specific piece of code.
7. static: A non-access modifier used for methods and attributes. Static
methods/attributes can be accessed without creating an object of a class.
8. abstract: Used to create blueprints. An abstract class cannot be instantiated and
demands to be inherited.
9.
Method Description Return Type
charAt() Returns the character at the specified index char
(position)
codePointAt() Returns the Unicode of the character at the int
specified index
codePointBefore( Returns the Unicode of the character before the int
) specified index
codePointCount( Returns the number of Unicode values found in a int
) string.
compareTo() Compares two strings lexicographically int
compareToIgnore Compares two strings lexicographically, ignoring int
Case() case differences
concat() Appends a string to the end of another string String
contains() Checks whether a string contains a sequence of boolean
characters
contentEquals() Checks whether a string contains the exact same boolean
sequence of characters of the specified
CharSequence or StringBuffer
copyValueOf() Returns a String that represents the characters of String
the character array
endsWith() Checks whether a string ends with the specified boolean
character(s)
equals() Compares two strings. Returns true if the strings boolean
are equal, and false if not
equalsIgnoreCase Compares two strings, ignoring case boolean
() considerations
format() Returns a formatted string using the specified String
locale, format string, and arguments
getBytes() Converts a string into an array of bytes byte[]
getChars() Copies characters from a string to an array of void
chars
hashCode() Returns the hash code of a string int
indexOf() Returns the position of the first found int
occurrence of specified characters in a string
intern() Returns the canonical representation for the String
string object
isEmpty() Checks whether a string is empty or not boolean
join() Joins one or more strings with a specified String
separator
lastIndexOf() Returns the position of the last found occurrence int
of specified characters in a string
length() Returns the length of a specified string int
matches() Searches a string for a match against a regular boolean
expression, and returns the matches
offsetByCodePoin Returns the index within this String that is offset int
ts() from the given index by codePointOffset code
points
regionMatches() Tests if two string regions are equal boolean
replace() Searches a string for a specified value, and String
returns a new string where the specified values
are replaced
replaceAll() Replaces each substring of this string that String
matches the given regular expression with the
given replacement
replaceFirst() Replaces the first occurrence of a substring that String
matches the given regular expression with the
given replacement
split() Splits a string into an array of substrings String[]
startsWith() Checks whether a string starts with specified boolean
characters
subSequence() Returns a new character sequence that is a CharSequen
subsequence of this sequence ce
substring() Returns a new string which is the substring of a String
specified string
toCharArray() Converts this string to a new character array char[]
toLowerCase() Converts a string to lower case letters String
toString() Returns the value of a String object String
toUpperCase() Converts a string to upper case letters String
trim() Removes whitespace from both ends of a string String
valueOf() Returns the string representation of the specified String
value