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:

Data Formats ( XML & JSON ) XML AND JSON | Generate XSD for Students

By Astrio Jather
  Generate XSD for Students   Generate XSD for the following XML. XYZ School wants to store the details of students in an xml file. The following scenario helps in designing the XML document. Here StudentList  is the root tag. StudentList contains the entry of each student with rollno, name, age, address and department. <?xml version="1.0" encoding="UTF-8"?> <StudentList  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  xsi:noNamespaceSchemaLocation="StudentList.xsd">     <Student rollno="2017CSE0055">         <name>             <firstname>Savitha</firstname>         </name>         <age>20</age>         <address>             <doorno>35</doorno>     ...
Post a Comment
Read more

Data Formats ( XML & JSON ) XML AND JSON | Generate XSD for Persons

By Astrio Jather
  Generate XSD for Persons Generate XSD for the following XML. XYZ organization wants to store the details of persons in an xml file. The following scenario helps in designing the XML document. Here PersonList  is the root tag. PersonList contains the entry of each person with adhaarno, name, age and address. <?xml version="1.0"  encoding="UTF-8"?> <PersonList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PersonList.xsd">     <Person>         <adhaarno>414356782345</adhaarno>         <name>             <firstname>Zeenath</firstname>         </name>         <age>28</age>         <address>             <doorno...
Post a Comment
Read more

DFA Solutions

By Astrio Jather
  Question  1 Correct Mark 1.00 out of 1.00 Flag question Question text To secure the http messages in the API calls, its necessary to: Select one: a. All the above b. Use cryptography c. implement identity management d. avoid hardcoding any sensitive data in the messages Feedback The correct answer is: All the above Question  2 Correct Mark 1.00 out of 1.00 Remove flag Question text A team has completed 10 Sprints and moving to the 11th Sprint. Till Sprint 10, the team has achieved an average of 50 story points per sprint. The same is projected as their velocity for the upcoming sprints with the Client. What is this approach called? Select one: a. Velocity Driven Sprint Planning b. Velocity Driven Commitment c. Commitment Driven Velocity d. Commitment Driven Sprint Planning Feedback The correct answer is: Velocity Driven Sprint Planning Question  3 Incorrect Mark 0.00 out of 1.00 Remove flag Question text Jack is grooming himself to be a potential Product Owner. Kno...
Post a Comment
Read more

RDBMS Data Definition Language | Create Buses table

By Astrio Jather
 efer the below schema and create the buses table. Column Name Datatype Size Constraint Constraint name Bus_no Number 11 Primary key PK_BUSES Bus_name Varchar2 20   Type Varchar2 20   Total_seats Number 11   Avail_seats Number 11     Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

Programming using Java Running case study - Requirement 1 / 6 | State Board of Cricket Council –V1.0 *

By Astrio Jather
  State Board of Cricket Council –V1.0 * State Board of Cricket Council   State Board of Cricket Council (SBCC) is one of the leading cricket selection academies in the state . They are in need of an automated system that should manipulate the player details provided and also find the players who have secured star rating between a specific range from the database. You being their software consultant have been approached to develop a pilot java application which can be used by the  admin for the above mentioned requirement . UserInterface.java package  com.sbcc.main; import  com.sbcc.model.*; import  java.util.*; import  java.lang.*; import  com.sbcc.skeletonvalidator.SkeletonValidator; public   class   UserInterface  {      public   static   Player   pl ;      public   static   void   main ( String []  args ) {        ...
Post a Comment
Read more

Programming using Java Hands On - Control Structures | Celcius to Farenheit Conversion

By Anonymous
  Celcius to Farenheit Conversion Write a program to convert  Celsius to Farenheit.  Display the result correct to 1 decimal. Create a class "CelsiusConversion.java" and write the main method. Hint : 5 * (F – 32) = 9 * C,   F-Farenheit , C- Celsius   Sample Input  1 : 80 Sample Output  1 : 176.0 Sample Input  2 : 88 Sample Output  2 : 190.4 Result Description Summary of tests *Note: All the test cases might not have same weightage +------------------------------+ | 7 tests run/ 7 tests passed | +------------------------------+
Post a Comment
Read more

Mock 3 Slot3 - Handson - 21st July Java (30 Marks) 1. Farm Fest

By Astrio Jather
Anuj has a mango farm. He sells the mangoes and earns money from them. He fills the mangoes in a basket. To make the calculation much simpler, he fills the basket either with an odd number of mangoes or with an even number of mangoes. If the number of mangoes is a combination of both an even and an odd number of mangoes, then he needs to rearrange the basket. Note: Number of baskets cannot exceed 10 and cannot be zero or less, If so print “Invalid number of baskets”. A negative number of mangoes cannot exit, if so print "Invalid Input". Sample Input 1: Number of baskets 5 Number of mangoes in each basket 2 4 6 8 10 Sample Output 1: Even Sample Input 2: Number of baskets 4 Number of mangoes in each basket 13 29 45 5 Sample Output 2: Odd Sample Input 3: Number of baskets 3 Number of mangoes in each basket 12 13 14 Sample Output 3: Rearrange the mangoes Sample Input 4: Number of baskets 0 Sample Output 4: Invalid number of baskets Sample Input 5: Number of baskets 2 Number of ma...
Post a Comment
Read more

Subscribe to Get's Answer by Email