List of top Information Technology Questions asked in CBSE CLASS XII

Consider the given table GARMENT:

+--------+--------------+------+--------+-------+
| GCODE  | GNAME        | SIZE | COLOUR | PRICE |
+--------+--------------+------+--------+-------+
| 111    | TShirt       | XL   | Red    | 1400  |
| 112    | Jeans        | L    | Blue   | 1600  |
| 113    | Skirt        | M    | Black  | 1100  |
| 114    | Ladies Jacket| XL   | Blue   | 4000  |
| 115    | Trousers     | L    | Brown  | 1500  |
| 116    | Ladies Top   | L    | Pink   | 1200  |
+--------+--------------+------+--------+-------+

Write SQL commands for the following: (a) To display names of those garments that are available in ‘L’ size.
(b) To change the colour of garments with code as 115 to “Orange”.
(c) To add a new row with the following data:
GCODE = 117, GNAME = Kurta, SIZE = M, COLOUR = White, PRICE = 1000
(d) To remove the column ‘COLOUR’ from the table ‘GARMENT’.

Consider the following string variables:
String str1 = "Hello";
String str2 = "Java Programming";
Write the code statements for the following in Java: (a) To display the string str1 into upper case.
(b) To display the character at the index 6 in string str2.
(c) To display the index of the first occurrence of letter ‘l’ in the string str1.
(d) To display the string str1 after replacing letter ‘l’ with ‘*’.

What will be the output of the following Java statements:
(a) System.out.println ("30 + 20");
(b) System.out.println ("Information Technology" + 802);