1. What is the index position of element 10 in the Stack?
Stack st = new Stack();
st.push(10);
st.push(20);
st.push(30);
1. 0
2. 1
3. 2
4. 3
2. With what you can fill up the blank so that the output is Hyderabad.
List cities = new ArrayList();
cities.add("Hyderabad");
------- abc = cities.get(0);
System.out.println(abc);
1. Object
2. String
3. 1 and 2
4. None of the above
3. The classes/interface required to write threads are
1. class Thread and interface Runnable
2. class Object
3. class ThreadGroup
4. 1, 2 and 3
4. To print the name of the thread “hello”, what method you will call with t1 (fill up the blank).
public class Demo
{
public static void main(String[] args)
{
Thread t1 = new Thread("hello");
String str = ------------------;
System.out.println(str);
}
}
1. t1.getName();
2. t1.getThreadName();
3. t1.getThread();
4. t1.name();
5. What is the output of the following program?
public class Demo extends Thread
{
public void run()
{
synchronized()
{
System.out.println("hello");
}
}
public static void main(String[] args)
{
Demo d1 = new Demo();
d1.start();
}
}
1. hello
2. does not compile
3. throws exception
4. none of the above
6. What is the alternative way of handling the checked exception with try-catch?
1. throwing the exception with throws keyword in the method signature
2. throwing the exception with throw keyword in the method signature
3. using finally
4. using user-defined exceptions
7. Fill up the blank with the option that can compile and execute the code successfully?
try
{
FileInputStream fis = new FileInputStream("abc.txt");
}
catch( --------------------- e)
{
System.out.println(e.toString());
}
1. FileNotFoundException
2. IOException
3. Exception
4. all the above
8. What about the facts of the code? Choose the right option that is true.
class InsufficientFundsException extends Exception
{
public InsufficientFundsException(String message)
{
super(message);
}
}
public class Demo
{
public static void main(String[] args)
{
int balance = 5000;
if(balance < 10000)
{
throw new InsufficientFundsException("No required funds");
}
}
}
1. compiles, executes successfully and prints the message "No required funds"
2. does not compile as main() is not throwing InsufficientFundsException
3. does not compile as throw is used instead of throws
4. compiles but throws exception
9. What could be the blank in the following snippet of code to compile successfully?
FileInputStream fis = new FileInputStream("abc.txt");
------------ x = fis.read();
1. int
2. boolean
3. byte
4. Object
10. Which is the most appropriate option to create fos1 object that compiles successfully?
1. FileOutputStream fos1 = new FileOutputStream("abc.txt");
2. FileOutputStream fos1 = new FileOutputStream("abc.txt", false);
3. FileOutputStream fos1 = new FileOutputStream(new File("abc.txt"));
4. all above
11. When the first println() prints 1000, what the second println() statement prints?
FileInputStream fis = new FileInputStream("abc.txt"); // file is opened
System.out.println(fis.available()); // prints 1000
fis.skip(500);
fis.skip(100);
System.out.println(fis.available()); // what it prints?
fis.close(); // file is closed
1. 600
2. 500
3. 100
4. 400
12. Java Designers divided the JDBC drivers into how many types?
1. 2
2. 3
3. 4
4. 5
13. Which of the following are classes of java.sql package.
1. Blob
2. Clob
3. 1 and 2
4. none of the above
14. What is the super class of SQLException?
1. Exception
2. JDBCException
3. DatabaseException
4. QueryException
15. Which one of the following statements is correct about the return type of forName() method?
1. Class cls = Class.forName(String);
2. Class.forName(String) returns void
3. Connection con = Class.forName(String);
4. DatabaseConnection dc = Class.forName(String);
16. getMimeType(String) is a method of
1. ServletConfig
2. ServletContext
3. HttpServlet
4. GenericServlet
17. getServletContext() is a method of
1. ServletConfig
2. ServletContext
3. RequestDispatcher
4. HttpSession
18. Which is the correct statement that returns an object of ServletOutputStream?
1. ServletOutputStream sos = response.getServletOutputStream ();
2. ServletOutputStream sos = response.getIOStream();
3. ServletOutputStream sos = response.getOutputStream();
4. ServletOutputStream sos = response.getStream();
(where response is an object of HttpServletResponse)
19. Choose the correct option to fill the blank.
Session ----------------------------------------.
1. is a conversational state between client and server.
2. consists of multiple requests and responses between client and server.
3. comes with an unique ID
4. all above
20. addCookie(Cookie obj) method returns --------------
1. void
2. Cookie object (which added)
3. boolean (of true if cookie is added else false)
4. int (0 if added or non-zero if not added)
21. Choose the correct option.
setMaxAge(-1) of a cookie indicates
1. Cookie should not be be destroyed
2. Cookie to be destroyed when the browser is shutdown
3. throws IllegalArgumentException
4. throws NegativeIndexException
22. getParameter(String) method is defined in -------------------- implicit object.
1. session
2. out
3. request
4. response
23. Which one of the following options is correct syntax for a JSP expression.
1. <%= request.getParameter("password"); %>
2. <%= request.getParameter("password") %>
3. <=% request.getParameter("password"); %>
4. <% request.getParameter("password"); %>
24. Choose the correct option for the following code if the salary is 80000.
<%!
public void display(double sal)
{
if(sal >= 75000)
out.println(" are great");
}
%>
<%
out.println("You");
String str2 = request.getParameter("salaryField");
double salary = Double.parseDouble(str2);
display(salary);
out.println(" man");
%>
1. prints You are great man
2. prints You are great
3. prints are great
4. does not print anything as code contains errors
25. Interrupt and trap handling is done by -------------------.
1. shell
2. kernal
3. application layer
4. application libraries
26. In preemptive multitasking
1. CPU time is divided into slices
2. CPU time is not divided into slices
3. more than one task can be performed at the same time on a single processor
4. each program gets number of slices
27. In Unix, the home directory contains
1. binary files
2. user directories and files
3. device specific files
4. system configuration files
28. What command is used to terminate a running process in Unix?
1. kill
2. close
3. invalidate
4. cancel
29. What is the output for the following Oracle code when user enters 10 for x and 0 for y. Choose the right option.
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 VALUE_ERROR THEN
dbms_output.put_line('Hello 1');
WHEN OTHERS THEN
dbms_output.put_line('Hello 2');
END;
1. Hello 1 and Hello 2
2. Hello 1
3. Hello 2
4. nothing printed
30. What exception suits for the problem of the code?
DECLARE
num number;
BEGIN
num:= 'five';
num := num * num;
DBMS_OUTPUT.PUT_LINE(num);
EXCEPTION
WHEN --------------------- THEN
DBMS_OUTPUT.PUT_LINE('Conversion problem');
END;
1. NO_DATA_FOUND
2. TOO_MANY_ROWS
3. STORAGE_ERROR
4. VALUE_ERROR
31. Choose the right option that is true.
create or replace procedure Pragmademo(id in number)
IS
manyrecords_detected EXCEPTION;
nodata_detected EXCEPTION;
salary number;
PRAGMA EXCEPTION_INIT(manyrecords_detected, -1422);
PRAGMA EXCEPTION_INIT(nodata_detected, -100);
BEGIN
select empsal into salary from Employee where empid=id;
dbms_output.put_line('Salary of ' || id || ' is ' || salary);
EXCEPTION
WHEN manyrecords_detected THEN
dbms_output.put_line('Many records exist on ID');
WHEN nodata_detected THEN
dbms_output.put_line('No data found for this ID');
END;
1. declaring two Pragma exceptions in a single procedure does not raise compilation error
2. procedure does not compile successfully
3. depending on id input value appropriate exception is not caught
4. none above
32. Choose the right option that is true for the following code.
DECLARE
table_already_in_use EXCEPTION;
PRAGMA EXCEPTION_INIT(table_already_in_use, -955);
new_table_status VARCHAR2(100) := 'CREATE TABLE Employee(empid number)';
BEGIN
EXECUTE IMMEDIATE new_table_status;
EXCEPTION
WHEN table_already_in_use THEN
DBMS_OUTPUT.PUT_LINE('Table is already existing in the database');
END;
1. statement EXECUTE IMMEDIATE causes compilation error
2. VARCHAR2(100) raises error
3. the code does not compile with other errors
4. the code does not contain errors and happily compiles
33. Choose the right option that is true.
1. In Composite type variables, nested tables cannot increase the size dynamically.
2. Composite variables does not have internal components.
3. Composite data type stores values that do not have internal components.
4. In Composite type variables, manipulation of associative array can only be carried out by collections functions and not with DML statements.
34. Choose the best right option for the following codes that executes successfully in Oracle.
Code A:
DECLARE x binary_float := 2.5; y binary_double := 2.5; z binary_float;
BEGIN z := x*y; dbms_output.put_line(z); END;
Code B:
DECLARE x real := 2.5; y binary_double := 2.5; z number;
BEGIN z := x*y; dbms_output.put_line(z); END;
Code C:
DECLARE a char(10) := '222'; b long(4) := 'abcd';
BEGIN dbms_output.put_line(a || b); END;
Code D:
DECLARE c nchar(10) := 'klmn'; d rowid := 'pqrs';
BEGIN dbms_output.put_line(c || d); END;
1. Code A, Code B, Code C, Code D
2. Code A, Code B
3. Code C, Code D
4. none above
35. Read the code and choose the right option that is true.
DECLARE
stock_price number;
num_stocks number;
BEGIN
stock_price := 50.5;
num_stocks := 50;
DECLARE
total_cost number;
BEGIN
total_cost := stock_price * num_stocks;
END;
dbms_output.put_line('Total cost is ' || total_cost);
END;
1. code does not compile due to nested blocks
2. code does not compile due to scope problem of total_cost
3. code compiles fine and gives the output of total_cost
4. none above
36. Choose the right option for the blank in the following collection code.
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 last element of this associative array.
1. emp_name.LAST
2. emp_name.1
3. emp_name.(1)
4. emp_name.getLast()
37. Choose the right option to fill the blank for the following nested record to compile successfully.
DECLARE
TYPE address IS RECORD (
city varchar2(20)
);
TYPE customer IS RECORD(
name varchar2(20),
send_to address
);
cust customer;
BEGIN
cust.name := 'TCS';
------------------------ := 'Hyderabad'; -- blank here
dbms_output.put_line(cust.name || cust.send_to.city);
END;
1. cust(send_to(city))
2. (cust.send_to).city
3. cust.send_to.city
4. (cust.send_to) city
38. Choose the right option that is true regarding SQL cursors.
1. A cursor can hold more than one row, but can process only one row at a time.
2. Cursor does not point to context area of a SQL statement
3. When you fetch a row the current row position does not move to the next row implicitly.
4. Implicit cursors are not created automatically by the Oracle engine.
39. Choose the right option to fill the blank
DECLARE
------------------------------- -- blank here
SELECT empid, empname from Employee;
BEGIN
FOR emp1 IN emp LOOP
DBMS_OUTPUT.PUT_LINE(emp1.empid || ', ' || emp1.empname);
END LOOP;
END;
1. CURSOR emp IS
2. CURSOR emp1 IS
3. CURSOR Employee IS
4. none above
40. What could be the blank to compile the following trigger. Choose right option that is true.
Employee table contains three fields of empid, empname and empsal.
create or replace trigger emp_insert
before INSERT
on
------------------------ -- blank here
for each row
BEGIN
dbms_output.put_line('record affected successfully');
END;
1. empid or empname or empsal
2. empid
3. Employee
4. none above
SOLUTIONS
| 1. 4 | 2. 3 | 3. 4 | 4. 1 | 5. 2 |
| 6. 1 | 7. 4 | 8. 2 | 9. 1 | 10. 4 |
| 11. 4 | 12. 3 | 13. 3 | 14. 1 | 15. 1 |
| 16. 2 | 17. 1 | 18. 3 | 19. 4 | 20. 1 |
| 21. 2 | 22. 3 | 23. 2 | 24. 4 | 25. 2 |
| 26. 1 | 27. 2 | 28. 1 | 29. 3 | 30. 4 |
| 31. 1 | 32. 4 | 33. 4 | 34. 1 | 35. 2 |
| 36. 1 | 37. 3 | 38. 1 | 39. 1 | 40. 3 |
