Skip to main content

Accenture Mock Quiz | Part 4

Image
By Astrio Jather

 

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:
 

Feedback

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:
 

Feedback

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:
 

Feedback

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:
 

Feedback

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:
 

Feedback

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:
 

Feedback

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:
 

Feedback

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:
 

Feedback

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:
 

Feedback

Labels:

Comments

Post a Comment

Must Read:

RDBMS Data Definition Language | Alter-Rename the field

By Astrio Jather
RDBMS  Data Definition Language  Alter-Rename the field Write a query to change the field name Distributor_name to Distributor_Full_name in Distributor table. Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

Logic Development | Object Oriented Programming Pre Quiz

By Astrio Jather
 
Post a Comment
Read more

Count Encodings

By Astrio Jather
 1. You are given a string str of digits. (will never start with a 0) 2. You are required to encode the str as per following rules     1 -> a     2 -> b     3 -> c     ..     25 -> y     26 -> z 3. You are required to calculate and print the count of encodings for the string str.      For 123 -> there are 3 encodings. abc, aw, lc      For 993 -> there is 1 encoding. iic       For 013 -> This is an invalid input. A string starting with 0 will not be passed.      For 103 -> there is 1 encoding. jc      For 303 -> there are 0 encodings. But such a string maybe passed. In this case       print 0. Input Format A string str Output Format count of encodings Constraints 0 < str.length <= 10 Sample Input 123 Sample Output 3 Solution: import java.io.*; import java.util.*; public class Main {   ...
Post a Comment
Read more

Count A+b+c+ Subsequences

By Astrio Jather
 1. You are given a string str. 2. You are required to calculate and print the count of subsequences of the nature a+b+c+. For abbc -> there are 3 subsequences. abc, abc, abbc For abcabc -> there are 7 subsequences. abc, abc, abbc, aabc, abcc, abc, abc. Input Format A string str Output Format count of subsequences of the nature a+b+c+ Constraints 0 < str.length <= 10 Sample Input abcabc Sample Output 7 Solution: import java.io.*; import java.util.*; public class Main {     public static void main(String[] args) throws Exception {         Scanner sc = new Scanner(System.in);         String str = sc.nextLine();         int counta = 0, countb = 0, countc = 0;         for(int i=0;i<str.length();i++){             char ch = str.charAt(i);             if(ch == 'a')                 ++coun...
Post a Comment
Read more

Basics of Java | Operators | Day 1

By Astrio Jather
Problem: Operators are symbols that perform operations on variables and values. For example, + is an operator used for addition , while * is also an operator used for multiplication . Operators in Java can be classified into 6 types: Arithmetic Operators Assignment Operators Relational Operators Logical Operators Unary Operators Bitwise Operators References: Click Here . We will discuss about arithmetic operators and rest you can study from the references mentioned above. Arithmetic Operators: Arithmetic operators are used to perform arithmetic operations on variables and data. For example, a + b; Here, the + operator is used to add two variables a and b. Similarly, there are various other arithmetic operators in Java. Operator Operation + Addition - Subtraction * Multiplication / Division % Modulo Operation (Remainder after division) Task: You are given two integers as input a and b You need to perform several...
Post a Comment
Read more

0-1 Pattern

By Astrio Jather
  /* @ToDo  0-1 Pattern     1     0   1     0   1   0     1   0   1   0     1   0   1   0   1 */ #include   <iostream> using   namespace   std ; int   main (){       #ifndef  ONLINE_JUDGE          freopen ( "../asset/input.txt" , "r" , stdin );          freopen ( "../asset/output.txt" , "w" , stdout );     #endif     // Code here!!      int   n ;  cin >> n ;      int   sign  =  1 ;      for ( int   i = 1 ; i <= n ; i ++){    ...
Post a Comment
Read more

Reverse a Number

By Astrio Jather
  /* @ToDo     Reverse a Number    7325 => 5237    12345 => 54321 */ #include   <iostream> using   namespace   std ; int   main (){       #ifndef  ONLINE_JUDGE          freopen ( "../asset/input.txt" , "r" , stdin );          freopen ( "../asset/output.txt" , "w" , stdout );     #endif     // Code here!!      int   n ;  cin >> n ;      int   num  =  0 ;      while ( n > 0 ){          num  = ( num * 10 ) + ( n % 10 );          n  /=  10 ;     }       cout << nu...
Post a Comment
Read more

RDBMS Data Definition Language | Alter - removing a column in Mobile Specification

By Astrio Jather
RDBMS  Data Definition Language  Alter - removing a column in Mobile Specification   Write a query to remove the column weight from the mobile specification table. Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

RDBMS Data Definition Language | Alter -Modify the field type

By Astrio Jather
Write a query to change the field type weight varchar(20) in Mobile_specification table to number(10). Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

Subscribe to Get's Answer by Email