1. Which method gives the index position of an element in Stack data structure?
1. indexOf()
2. search()
3. elementAt()
4. elementIndexOf()
2. The removeRange(3, 8) removes all the elements in Vector
1. from 3 to 8
2. from 3 to 7
3. from 2 to 8
4. from 2 to 7
3. What is the maximum priority that can be assigned to the threads of main group.
1. 1
2. 5
3. 8
4. 10
4. The job is join() method is
1. to see the parent thread dies later than child thread
2. to see the child thread dies later than parent thread
3. to communicate between two threads
4. 1 and 3
5. Observe the following code. Choose the correct option.
public class Demo extends Thread
{
public void run() throws InterruptedException
{
Thread.sleep(1000);
System.out.println("Hello");
}
public static void main (String [] args)
{
Demo d1 = new Demo();
d1.start();
}
}
1. does not compile as instead of try-catch the InterruptedException is thrown in method body
2. compiles, executes and prints Hello with a late of 1000 milliseconds
3. run() is not called from main() method and thereby run() is not executed
4. compiles but throws exception
6. What the method printStackTrace() does?
1. prints the minute details of stack memory runtime problems
2. prints the major details of stack memory runtime problems
3. prints complete details of stack memory runtime problems
4. prints all the names of methods and classes involved with the problem
7. Choose the right option that is true of the following snippet of code?
public static void main (String [] args)
{
String cities[][] = { {"Chennai","Delhi"}, { null }, {"Hyderabad","Bhopal"}};
System.out.println(cities[1][1]);
}
1. compiles but throws ArrayIndexOutOfBoundsException
2. compiles but throws NullPointerException
3. compiles, executes and prints null
4. does not compile
8. Observe the following main() method code and choose the best right option that is true.
public static void main (String [] args)
{
List places = new ArrayList<>();
places.add("Kochi"); places.add("Kedarnath");
places.forEach(str -> {
if(str.equals("Kedarnath"))
throw new RuntimeException("Do not go, it is winter");
else
System.out.println("Enjoy Kochi");
});
}
1. code does not compile as exception cannot be thrown from Lambda expressions.
2. the code compiles, runs and prints
3. forEach loop is not supported by Java language
4. code does not compile as it is full of errors
9. If two files are opened with FileInputStream and FileOutputStream to copy a file, which order of the streams is the better way to close them?
1. first close FileInputStream and then FileOutputStream
2. first close FileOutputStream and then FileInputStream
3. streams need not be closed as they are closed automatically when copying is over
4. order is not important as both close() methods throw IOException.
10. Which method of LineNumberInputStream gives line numbers?
1. getLineNumber()
2. getLineCount()
3. getCount()
4. getNumber()
11. Fill up the blank with correct data type which can compile successfully?
FileInputStream fis = new FileInputStream ("Demo.txt");
---------- temp = 100;
fis.skip(temp);
1. byte
2. short
3. int
4. all above
12. Which of the following statements are correct?
1. Stored procedure is used for business logic and function is used for calculations.
2. try-catch can be used with stored procedures and not with custom-defined function.
3. Stored procedure does not have a return type and function have.
4. 1, 2 and 3
13. Which interface helps us to get the name of the driver used?
1. Connection
2. ResultSetMetaData
3. DatabaseMetaData
4. MetaData
14. Choose the best option that is true.
1. execute() method is used to execute both select and update SQL statements
2. executeQuery() method is used to execute only select SQL statements and executeUpdate() is used for only update SQL statements
3. 1 and 2
4. execute() method does not exist.
15. Which one of the following statements executes successfully to set a null value with PreparedStatement without throwing exceptions?
PreparedStatement psmt = con.prepareStatement(someSqlQuery); // con is an object of Connection
1. psmt.setNull(3, java.sql.Types.VARCHAR); // 3 is the column index of a table
2. psmt.setNull(3, null);
3. psmt.setString(3, null);
4. psmt.set(3, null);
16. The service() method can have one of the parameters as
1. ServletRequest or HttpServletRequest
2. ServletConfig or HttpServletConfig
3. ServletContext or HttpServletContext
4. Response or HttpResponse
17. What is the interface used to forward request from one servlet to another?
1. ServletConfig
2. ServletContext
3. RequestDispatcher
4. HttpSession
18. Which is the right statement that returns an object of RequestDispatcher?
1. RequestDispatcher rd = request.getRequestDispatcher(“/roses”);
2. RequestDispatcher rd = request.getDispatcher(“/roses”);
3. RequestDispatcher rd = request.createRequestDispatcher(“/roses”);
4. RequestDispatcher rd = request.requestDispatcher(“/roses”);
(where request is an object of HttpServletRequest and roses is the alias name of the other servlet)
19. To which package Cookie class belongs?
1. javax.servlet
2. javax.servlet.http
3. javax.servlet.session
4. javax.servlet.http.session
20. Which methods return the name and value of the Cookie?
1. name() and value()
2. getCookieName() and getCookieValue()
3. cookieName() and cookieValue()
4. getName() and getValue()
21. Choose the right statement.
1. Cookie xyz[] = request.getCookies();
2. ArrayList xyz = request.getCookies();
3. HashSet xyz = request.getCookies();
4. Hashtable xyz = request.getCookies();
(where request is an object of HttpServletRequest)
22. If “c” is the prefix for JSTL core tag library, which option will iterate over a list of elements of a Java collection data structure?
1. <c:iterate>
2. <c:listIterate>
3. <c:forEach>
4. <c:tokens>
23. If “c” is the prefix for JSTL core tag library, what is the output of the following snippet of code?
<c:set var=”quantity” value=”2″/>
<c:forEach var=”quantity” begin=”0″ end=”0″ step=”3″>
<c:out value=”${ quantity }” default=”hello”/>
</c:forEach>
1. does not compile
2. 0
3. 1
4. hello
24. Which one of the following options is of correct JSP syntax to fill up the blank?
--------------------------------------------- // fill up the blank
<%@ page import="java.util.*" %>
<% Date d=new Date(); %>
Time Particulars:
Hours: <%= d.getHours() %>
Minutes: <%= d.getMinutes() %>
Seconds: <%= d.getSeconds() %>
1. <% response.setHeader("refresh", 5); %>
2. <% response.setHeader("5"); %>
3. <% response.setHeader("refresh", "5"); %>
4. <% response.setHeader(5); %>
25. /bin is a directory of shell which contains ——————————.
1. all error messages and log messages
2. all logical names to pysical devices
3. all system configuration files
4. all normal user executable commands
26. A multiprocessing OS
1. it not possible to execute multiple processes at the same time on a single processor
2. it is possible to execute multiple processes at the same time on a single processor
3. can support of execution of a number of processes at the same time on different processors
4. does not support of execution of a number of porcesses at the same time.
27. In Unix, the sbin directory contains
1. binary files
2. system binary files
3. device specific files
4. system configuration files
28. How to compare two files? Which command is used in Unix?
1. comp
2. cmp
3. compareTo
4. compare
29. Choose the right option to fill the blank that is valid for the zero input values of the client.
CREATE OR REPLACE PROCEDURE calculate(x IN NUMBER, y IN NUMBER)
IS
z NUMBER;
begin
z := x/y;
dbms_output.put_line('Value is ' || z);
EXCEPTION
WHEN ------------------------------------ THEN -- blank here
dbms_output.put_line('Hello 1');
WHEN OTHERS THEN
dbms_output.put_line('Hello 2');
END;
1. PROGRAM_ERROR
2. VALUE_ERROR or ZERO_DIVIDE
3. STORAGE_ERROR
4. none above
30. What predefined exception of Oracle can accommodate the blank?
DECLARE
number varchar2(10);
BEGIN
number:= 'ten';
number := number * number;
DBMS_OUTPUT.PUT_LINE(number);
EXCEPTION
WHEN -------------------- THEN -- blank here
DBMS_OUTPUT.PUT_LINE('Conversion problem');
END;
1. PROGRAM_ERROR
2. NO_DATA_FOUND
3. VALUE_ERROR
4. TOO_MANY_ROWS
31. If the id 101 salary is 999, choose the right option that will be true for the following code.
DECLARE
small_man_detected EXCEPTION;
salary number;
PRAGMA EXCEPTION_INIT(small_man_detected, -1422);
BEGIN
select empsal into salary from Employee where empid=101;
dbms_output.put_line(salary);
if salary < 1000 then
raise small_man_detected;
end if;
EXCEPTION
WHEN small_man_detected THEN
dbms_output.put_line('You are small man. Enjoy many Govt. schemes');
END;
1. Both salary and exception message are printed and code compiles successfully
2. Code is with errors and does not compile
3. Only exception message is printed
4. none above
32. Choose the right option to fill the blank to get the message 'Problem'.
DECLARE
overdraft_exception EXCEPTION;
not_permitted_exception EXCEPTION;
overdraft number := 10000;
withdraw number := 20000;
BEGIN
IF withdraw > overdraft THEN
RAISE overdraft_exception;
END IF;
EXCEPTION
WHEN ------------------------ THEN -- blank
DBMS_OUTPUT.PUT_LINE('Problem');
END;
1. program_error
2. not_permitted_exception
3. value_error
4. overdraft_exception
33. Choose the right option that is true.
1. In Composite type variables, nested tables are bounded.
2. When you assign values to a record, you are not assigning values to the fields within it.
3. In Composite type variables, PL/SQL allows to define two kinds of composite data types - Collection and Record.
4. In Composite type variables, an associative array is stored in a database table.
34. Which of the following scalar variable codes execute successfully for Oracle. Choose the best option that is true.
Code A:
DECLARE n4 SIMPLE_INTEGER :=10; n5 PLS_INTEGER := 10; n6 INTEGER := 10;
BEGIN n4 := n5*n6; dbms_output.put_line(n4); END;
Code B:
DECLARE n4 BINARY_INTEGER :=10; n5 PLS_INTEGER := 10; n6 NUMBER := 10;
BEGIN n4 := n5*n6; dbms_output.put_line(n4); END;
Code C:
DECLARE n4 NATURAL :=10; n5 PLS_INTEGER := 10; n6 NUMBER := 10;
BEGIN n4 := n5*n6; dbms_output.put_line(n4); END;
Code D:
DECLARE n4 NATURAL := -10; n5 PLS_INTEGER := - 10; n6 NUMBER := - 10;
BEGIN n4 := n5*n6; dbms_output.put_line(n4); END;
1. A, D compiles successfully
2. B, C compiles successfully
3. A, B, C, D compiles successfully
4. none of above
35. Choose the right option that fits in the blank to compile successfully.
DECLARE
current_date1 DATE;
current_date2 DATE;
BEGIN
current_date1 := current_date;
current_date2 := sysdate;
-------------------------------------------------- // blank here
DBMS_OUTPUT.PUT_LINE('same');
else
DBMS_OUTPUT.PUT_LINE('not same');
end if;
END;
1. if current_date1 eq current_date2 then
2. if current_date1 = current_date2 then
3. if current_date1 == current_date2 then
4. none above
36. Choose the right option for the blank in the following code to compile successfully.
DECLARE
TYPE ename IS TABLE OF VARCHAR2(50) INDEX BY PLS_INTEGER ;
emp_name ename;
BEGIN
emp_name('01') := 'TCS1, Hyderabad';
emp_name('02') := 'TCS2, Pune';
emp_name('03') := 'TCS3, Bubaneswar';
dbms_output.put_line(---------------------------------); -- blank here
END;
Fill up the blank of how to get the first element of this associative array.
1. emp_name.FIRST
2. emp_name.1
3. emp_name.(1)
4. emp_name.getFirst()
37. Choose the right option that is true for the following nested record.
DECLARE
TYPE address IS RECORD (
city varchar2(20),
pincode binary_integer
);
TYPE customer IS RECORD(
name varchar2(20),
send_to address
);
cust customer;
BEGIN
cust.name := 'TCS';
cust.send_to.city := 'Hyderabad';
cust.send_to.pincode := 500020;
dbms_output.put_line(cust.name || cust.send_to.city || cust.send_to.pincode);
END;
1. Code compiles successfully and output is displayed
2. Compiles but throws exception
3. Error in code
4. none above
38. Choose the right option that is true regarding SQL cursors.
1. %ROWCOUNT is used to know the number of records affected by the SQL statement.
2. %ISCLOSED is used to know whether the cursor is opened or not.
3. Implicit cursors are more efficient than explicit cursors.
4. A cursor variable is tied to a specific query.
39. Choose the right option to fill the blank
DECLARE
CURSOR emp IS
SELECT empid, empname from Employee;
BEGIN
------------------------------------------------------------- -- blank
DBMS_OUTPUT.PUT_LINE(emp1.empid || ', ' || emp1.empname);
END LOOP;
END;
1. FOR emp IN emp1 LOOP
2. FOR emp1 IN emp LOOP
3. FOR emp1 IN Employee LOOP
4. none above
40. Choose the right option for the blank, that compiles successfully, in the following user-defined function.
CREATE OR REPLACE FUNCTION get_salary(id IN NUMBER)
RETURN NUMBER
IS esal NUMBER(6,2);
BEGIN
SELECT empsal INTO esal FROM Employee WHERE empid = id;
dbms_output.put_line(esal);
------------------------------------ -- blank here
END;
1. RETURN(empsal);
2. RETURN(Employee);
3. RETURN(esal);
4. RETURN(get_salary);
SOLUTIONS
| 1. 2 | 2. 2 | 3. 4 | 4. 4 | 5. 1 |
| 6. 4 | 7. 1 | 8. 2 | 9. 2 | 10. 1 |
| 11. 4 | 12. 4 | 13. 3 | 14. 3 | 15. 1 |
| 16. 1 | 17. 3 | 18. 1 | 19. 2 | 20. 4 |
| 21. 1 | 22. 3 | 23. 2 | 24. 3 | 25. 4 |
| 26. 3 | 27. 2 | 28. 2 | 29. 2 | 30. 3 |
| 31. 1 | 32. 4 | 33. 4 | 34. 2 | 35. 2 |
| 36. 1 | 37. 1 | 38. 1 | 39. 2 | 40. 3 |