Accenture Mock Quiz | Part 4

 

Question 31

Correct

Marked out of 1.00

Flag question

Question text

What will be the output of the following Java code?

class Test extends Throwable { }
class Base extends Test {}
public class Main {
   public static void main(String args[]) { 
      try {
         throw new Base();
      }
      catch(Test t) {
         System.out.println("Test Exception");
      }
      finally {
         System.out.println("Finally block ");
      }
  }
}

Select one:

a. Complilation error : Bass calss can't extends Test

b. print-"Test Exception"

c. Complilation error: Test Class cant extends Throwable

d. print - "Test Exception" "Finally block " 

Feedback

The correct answer is: print - "Test Exception" "Finally block "

Question 32

Correct

Marked out of 1.00

Flag question

Question text

Which of the following statement(s) is/are TRUE?

(i) In a non-correlated(independent) subquery, the subquery is always executed only once.

(ii) In a non-correlated(independent) subquery, the inner query (sub query) references the column from the outer query (main query).

Choose most appropriate option

Select one:

a. Both (i) and (ii)

b. Neither (i) nor (ii)

c. Only (ii)

d. Only (i) 

Feedback

The correct answer is: Only (i)

Question 33

Incorrect

Marked out of 1.00

Flag question

Question text

The employee tables contains EmployeeId,EmployeeName and DeptCode Columns. Which is the CORRECT SQL query to display the EmployeeId and EmployeeName of employees who are working in DeptCode 10 OR 20?

(i) SELECT EmployeeId,EmployeeName FROM Employee WHERE DeptCode IN (10,20);

(ii) SELECT EmployeeId,EmployeeName FROM Employee WHERE DeptCode = 10 OR DeptCode = 20;

Choose most appropriate option.

Select one:

a. Only (i)

b. Both (i) and (ii)

c. Only (ii) 

d. Neither (i) nor (ii)

Feedback

The correct answer is: Both (i) and (ii)

Question 34

Correct

Marked out of 1.00

Flag question

Question text

Which of the following statement(s) is/are TRUE?

(i) In a subquery, the inner query is responsible for giving result.

(ii) In a subquery, the outer query is responsible to display output.

Choose most appropriate option

Select one:

a. Both (i) and (ii) 

b. Only (i)

c. Neither (i) nor (ii)

d. Only (ii)

Feedback

The correct answer is: Both (i) and (ii)

Question 35

Incorrect

Marked out of 1.00

Flag question

Question text

Which of the following SQL query will not be executed successfully? Assume all the column names and table name given here are correct. Choose the most appropriate option.

Select one:

a. SELECT ename FROM emp ORDER by ename,job GROUP BY ename;

b. SELECT deptno,ename FROM emp WHERE empno&gt100 group by ename,deptno; 

c. SELECT deptno FROM emp GROUP BY deptno,job;

Feedback

The correct answer is: SELECT ename FROM emp ORDER by ename,job GROUP BY ename;

Question 36

Correct

Marked out of 1.00

Flag question

Question text

Assume that table Asset(assetId number(2)) is created and 2 records are already inserted and saved.

COMMIT;
DELETE FROM ASSET;
ROLLBACK;
INSERT INTO ASSET VALUES(5);
COMMIT;

What would be the output of the below SQL statement after executing the above statements sequentially.

SELECT COUNT(*) FROM Asset;

Select one:

a. 3 

b. 2

c. 0

d. 1

Feedback

Your answer is correct.

The correct answer is: 3

Question 37

Incorrect

Marked out of 1.00

Flag question

Question text

Consider the below tables.
Event(eventId,eventName) – eventId is primary key
Employee(empId, empName, eventId) – empId is primary key and eventId is foreign key referring to Event table.
Identify the correct SQL statement to retrieve empid, empname and eventName for all employees. If employee has not registered for an event then it should display ‘Not Registered’.

Select one:

a. SELECT e1.empId, e1.empName, NVL(e2.eventName,'Not Registered') FROM event e2 LEFT OUTER JOIN employee e1 ON e2.eventId=e1.eventId;

b. SELECT e1.empId, e1.empName, NVL(e2.eventName,'Not Registered') FROM event e2 INNER JOIN employee e1 ON e2.eventId=e1.eventId; 

c. SELECT e1.empId, e1.empName, NVL(e2.eventName,'Not Registered') FROM employee e1 LEFT OUTER JOIN event e2 ON e1.eventId=e2.eventId;

d. SELECT e1.empId, e1.empName, NVL(e2.eventName,'Not Registered') FROM employee e1 RIGHT OUTER JOIN event e2 ON e1.eventId=e2.eventId;

Feedback

Your answer is incorrect.

The correct answer is: SELECT e1.empId, e1.empName, NVL(e2.eventName,'Not Registered') FROM employee e1 LEFT OUTER JOIN event e2 ON e1.eventId=e2.eventId;

Question 38

Incorrect

Marked out of 1.00

Flag question

Question text

'link', 'vlink' and 'alink' are attributes of which HTML tag?

Choose the most appropriate option.

Select one:

a. <body>

b. <head>

c. <img>

d. <a> 

Feedback

Your answer is incorrect.

The correct answer is: <body>

Question 39

Correct

Marked out of 1.00

Flag question

Question text

Which of the following attribute is used by a HTML tag to apply inline style? Choose most appropriate option.

Select one:

a. class

b. id

c. styleclass

d. style 

Feedback

Your answer is correct.

The correct answer is: style