Accenture TFA Quiz | Part 1

 

Question 1

Correct

Marked out of 1

Flag question

Question text

The employee table contains EmployeeNumber, EmployeeName, Salary and DeptCode Columns. Which is the CORRECT SQL query to display DeptCode and average salary of each department? Choose most appropriate option.

Select one:

a. SELECT DeptCode,avg(salary) FROM Employee GROUP BY DeptCode; 

b. SELECT DeptCode,avg(salary) FROM Employee GROUP BY EmployeeNumber;

c. SELECT DeptCode,avg(salary) FROM Employee;

d. SELECT DeptCode,avg(salary) FROM Employee GROUP BY Salary;

Feedback

The correct answer is: SELECT DeptCode,avg(salary) FROM Employee GROUP BY DeptCode;

Question 2

Correct

Marked out of 1

Flag question

Question text

Which is the CORRECT SQL Query to display names of employees which has only 3 letters that starts with 'A' and ends with 'e'? Choose most appropriate option.

Select one:

a. SELECT EmployeeName FROM Employee WHERE EmployeeName LIKE 'A_e'; 

b. SELECT EmployeeName FROM Employee WHERE EmployeeName LIKE 'A%e';

c. SELECT EmployeeName FROM Employee WHERE EmployeeName = 'A_e';

d. SELECT EmployeeName FROM Employee WHERE EmployeeName LIKE '__e';

Feedback

The correct answer is: SELECT EmployeeName FROM Employee WHERE EmployeeName LIKE 'A_e';

Question 3

Correct

Marked out of 1

Flag question

Question text

Consider the table Student(StudentId, StudentName, Email, PercentageOfMarks). Which is the CORRECT query to display the details in the ascending order (lowest to highest) of PercentageOfMarks and in the descending order of StudentId in case PercentageOfMarks is the same. Choose most appropriate option

Select one:

a. SELECT StudentId, StudentName, Email, PercentageOfmarks FROM Student ORDER BY PercentageOfMarks DESC, StudentId DESC;

b. SELECT StudentId, StudentName, Email, PercentageOfmarks FROM Student ORDER BY PercentageOfMarks, StudentId DESC; 

c. SELECT StudentId, StudentName, Email, PercentageOfmarks FROM Student ORDER BY StudentId DESC, PercentageOfMarks;

d. SELECT StudentId, StudentName, Email, PercentageOfmarks FROM Student ORDER BY PercentageOfMarks DESC, StudentId;

Feedback

The correct answer is: SELECT StudentId, StudentName, Email, PercentageOfmarks FROM Student ORDER BY PercentageOfMarks, StudentId DESC;

Question 4

Incorrect

Marked out of 1

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. Neither (i) nor (ii)

b. Both (i) and (ii) 

c. Only (ii)

d. Only (i)

Feedback

The correct answer is: Only (i)

Question 5

Correct

Marked out of 1

Flag question

Question text

Which of the following is CORRECT about DELETE command?

a) It can delete single or multiple columns from a table

b) It can delete single or multiple records from a table

c) Records deleted can be roll backed.

Choose most appropriate option.

Select one:

a. b and c 

b. a only

c. a and c

d. a and b

Feedback

The correct answer is: b and c

Question 6

Incorrect

Marked out of 1

Flag question

Question text

Which of the following about DELETE command in SQL is FALSE? Choose most appropriate option.

Select one:

a. Is a DML statement and has to be manually committed

b. Used for deleting a single column value in a record

c. Used for deleting multiple records in a table 

d. Throws constraint violation error when deleting a parent record, for which child records exists

Feedback

The correct answer is: Used for deleting a single column value in a record

Question 7

Correct

Marked out of 1

Flag question

Question text

Identify the CORRECT SQL statement to create a table with composite primary key. Choose most appropriate option.

Select one:

a. CREATE TABLE Account (AccountNumber Number(5), CustomerId Number(10) CONSTRAINT Acc_Pkey2 PRIMARY KEY (AccountNumber,CustomerId), OpeningDate Date, Balance Number(10,2));

b. CREATE TABLE Account (AccountNumber Number(5), CustomerId Number(10), OpeningDate Date, Balance Number(10,2), CONSTRAINT Acc_Pkey COMPOSITE PRIMARY KEY (AccountNumber,CustomerId));

c. CREATE TABLE Account (AccountNumber Number(5) CONSTRAINT Acc_Pkey1 PRIMARY KEY, CustomerId Number(10) CONSTRAINT Acc_Pkey2 PRIMARY KEY, OpeningDate Date, Balance Number(10,2));

d. CREATE TABLE Account (AccountNumber Number(5), CustomerId Number(10), OpeningDate Date, Balance Number(10,2), CONSTRAINT Acc_Pkey PRIMARY KEY (AccountNumber,CustomerId)); 

Feedback

The correct answer is: CREATE TABLE Account (AccountNumber Number(5), CustomerId Number(10), OpeningDate Date, Balance Number(10,2), CONSTRAINT Acc_Pkey PRIMARY KEY (AccountNumber,CustomerId));

Question 8

Incorrect

Marked out of 1

Flag question

Question text

Which of the following can be created as a table level constraint?

(i) primary Key

(ii) foreign key

(iii) unique

Choose most appropriate option.

Select one:

a. (i) only

b. (i), (ii) and (iii)

c. (i) and (ii) 

d. (i) and (iii)

Feedback

The correct answer is: (i), (ii) and (iii)

Question 9

Correct

Marked out of 1

Flag question

Question text

State True/False?

The names of the foreign key field and the referenced field(in parent table) may be same or different, but must have the same data type.

Select one:

a. False

b. True 

Feedback

The correct answer is: True

Question 10

Correct

Marked out of 1

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 11

Correct

Marked out of 1

Flag question

Question text

Which of the following SQL commands is used to remove table "EMPLOYEE" present in the database? Choose most appropriate option.

Select one:

a. REMOVE TABLE EMPLOYEE;

b. DELETE TABLE EMPLOYEE;

c. TRUNCATE TABLE EMPLOYEE;

d. DROP TABLE EMPLOYEE; 

Feedback

The correct answer is: DROP TABLE EMPLOYEE;

Question 12

Correct

Marked out of 1

Flag question

Question text

Assume that table Project is created using the DDL statement given below and has no records. 

                   CREATE TABLE Project( projectId VARCHAR2(4) CONSTRAINT proj_pk PRIMARY KEY, projectName VARCHAR2(10) DEFAULT 'NA' CONSTRAINT proj_nn NOT NULL); 

Identify the INSERT statements which would successfully insert record into Project table. Choose two most appropriate options.

Select one or more:

a. INSERT INTO project(projectId) VALUES('P2'); 

b. INSERT INTO project(projectId,projectName) VALUES('P3', Null);

c. INSERT INTO project(projectName,projectId) VALUES('NA','P4' ); 

d. INSERT INTO project VALUES('P1'); 

Feedback

The correct answers are: INSERT INTO project(projectName,projectId) VALUES('NA','P4' );, INSERT INTO project(projectId) VALUES('P2');

Question 13

Incorrect

Marked out of 1

Flag question

Question text

Consider table Customer(cid NUMBER(4), cname VARCHAR2(10) ) is created in the database and has no records. Refer to the below statements.  

 COMMIT; 

INSERT INTO Customer VALUES(101,’John’); 

INSERT INTO Customer VALUES(102,’James’); 

DELETE FROM Customer WHERE cid=101; 

INSERT INTO Customer VALUES(103,’Mark’); 

ROLLBACK; 

COMMIT;   

How many records will be available in the customer table if the above statements are executed in sequential order.   Choose the most appropriate option.

Select one:

a. 1

b. 3 

c. 2

d. 0

Feedback

Your answer is incorrect.

The correct answer is: 0

Question 14

Correct

Marked out of 1

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. 0

c. 2

d. 1

Feedback

Your answer is correct.

The correct answer is: 3

Question 15

Incorrect

Marked out of 1

Flag question

Question text

Consider the following tables:

Vendor (VendorId, VendorName, PhoneNumber). Here VendorId is the primary key.

Item (ItemCode, UnitPrice, QuantityOnHand, VendorId) Here ItemCode is the primary key and VendorId is the foreign key referencing the VendorId in Vendor Table.

 

Which is the CORRECT SQL query to display ItemCode, UnitPrice, VendorName for all Items. It should also display the details of the Item which is not having any vendor?

Choose most appropriate option

Select one:

a. SELECT Item.ItemCode,Item.UnitPrice,Vendor.VendorName FROM Item LEFT OUTER JOIN Vendor ON Item.VendorId = Vendor.VendorId;

b. SELECT Item.ItemCode,Item.UnitPrice,Vendor.VendorName FROM Item, Vendor WHERE Item.VendorId = Vendor.VendorId; 

c. SELECT Item.ItemCode,Item.UnitPrice,Vendor.VendorName FROM Item INNER JOIN Vendor ON Item.VendorId = Vendor.VendorId;

d. SELECT Item.ItemCode,Item.UnitPrice,Vendor.VendorName FROM Item INNER JOIN Vendor ON Item.VendorId = Vendor.VendorId AND Item.VendorId IS NULL;

Feedback

Your answer is incorrect.

The correct answer is: SELECT Item.ItemCode,Item.UnitPrice,Vendor.VendorName FROM Item LEFT OUTER JOIN Vendor ON Item.VendorId = Vendor.VendorId;

Question 16

Incorrect

Marked out of 1

Flag question

Question text

What will be the output of the following Java code?

public class ApplicationTester 
 { 
   public static void main(String[] args)
   { 
     String s1 = "One"; 
     String s2 = "One";
     System.out.println((s1==s2) + " " + s1.equals(s2)); 
   } 
 }

Choose the most appropriate option.

Select one:

a. true true

b. false false

c. true false

d. false true 

Feedback

The correct answer is: true true

Question 17

Correct

Marked out of 1

Flag question

Question text

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

(1) Abstract method can have body

(2) Abstract class cannot be instantiated

(3) Abstract class can have constructor

Choose the most appropriate option.

Select one:

a. Both (1) and (3) are TRUE

b. Both (2) and (3) are TRUE 

c. Only (2) is TRUE

d. Both (1) and (2) are TRUE

Feedback

The correct answer is: Both (2) and (3) are TRUE

Question 18

Correct

Marked out of 1

Flag question

Question text

What will be the output of the following Java code?

 public class Rectangle 
{ 
  private int length; 
  private int width; 
  public static void main(String[] args) 
  { 
    Rectangle rectangle1 = new Rectangle(); 
    rectangle1.length=10; 
    rectangle1.width=5; 
    Rectangle rectangle2 = rectangle1; 
    System.out.println("Length : "+rectangle2.length); 
    System.out.println("Width : "+rectangle2.width);
  } 
}

Choose the most appropriate option.

Select one:

a. Length : 10 Width : 5 

b. Length: 5 Width: 10

c. Length : 0 Width : 0

d. Length : null Width : null

Feedback

The correct answer is: Length : 10 Width : 5

Question 19

Correct

Marked out of 1

Flag question

Question text

What will be the output of the following Java code?

public class ApplicationTester 
{ 
  public static void main(String[] args)
  { 
    int i=10; 
    while(++i<15)
    { 
      System.out.print(i + " "); 
    } 
  }
}

Choose the most appropriate option.

Select one:

a. 10 11 12 13 14

b. 14

c. 15

d. 11 12 13 14 

Feedback

The correct answer is: 11 12 13 14

Question 20

Correct

Marked out of 1

Flag question

Question text

What will be the output of the following Java code?

class StringSample 
{ 
  public StringSample(String string) 
  { 
    System.out.println("The string is " + string); 
  } 
} 
public class ConstructorTester1 
{ 
  public static void main(String[] args) 
  { 
    StringSample stringSample = new StringSample(); 
    StringSample stringSample1 = new StringSample("Test String"); 
  } 
}

Choose the most appropriate option.

Select one:

a. The string is Test String

b. The string is null

c. Compilation Error: The constructor StringSample() is undefined 

d. The string is null The string is Test String

Feedback

The correct answer is: Compilation Error: The constructor StringSample() is undefined

Question 21

Incorrect

Marked out of 1

Flag question

Question text

What will be the output of the following Java code?

public class StringTester 
{ 
public static void main(String[] args) 
{ 
  String player1 = new String ("virat kohli"); 
  String player2 = new String("GAYLE"); 
  player1.toUpperCase(); 
  String newPlayer=player1.substring(6); 
  newPlayer = newPlayer + player2.toLowerCase(); 
  System.out.println(newPlayer); 
} 
}

Choose the most appropriate option.

Select one:

a. kohligayle

b. kohliGAYLE

c. KOHLI gayle

d. KOHLIgayle 

Feedback

The correct answer is: kohligayle

Question 22

Correct

Marked out of 1

Flag question

Question text

Consider the Java code given below. How many times "1" will be printed when the code is executed?

 public class ApplicationTester 
{ 
  public static void main(String[] args)
  { 
    int i = -1; 
    while( ++i <= 1)
    { 
      System.out.println("1");
      i++; 
    } 
  }
}

Choose the most appropriate option.

Select one:

a. Nothing will be printed.

b. 3 times

c. 2 times

d. 1 time 

Feedback

The correct answer is: 1 time

Question 23

Correct

Marked out of 1

Flag question

Question text

What will be the output of the following Java code?

 class Event
{ 
  static int eventId; 
  public static void main(String[] args) 
  { 
    Event e1=new Event(); 
    e1.eventId=100; 
    Event e2=e1; e2.eventId=200;
    Event e3=new Event(); 
    System.out.println(e1.eventId+ " "+ e2.eventId + " "+ e3.eventId); 
  } 
}

Choose the most appropriate option.

Select one:

a. 200 200 200 

b. 100 200 0

c. 100 200 200

d. 100 100 100

Feedback

The correct answer is: 200 200 200

Question 24

Correct

Marked out of 1

Flag question

Question text

What will be the output of the following code:

public class Test 
 { 
   public static void main(String[] args)
   { 
     int number=20; 
     switch(number)
     { 
       case 10: System.out.println("10");
         break;
       case 20: System.out.println("20"); 
       case 30: System.out.println("30");
         break; 
       default:System.out.println("Not in 10, 20 or 30");
     } 
   } 
 }

Choose most appropriate option.

Select one:

a. invalid switch statement

b. 30

c. 20 30 

d. 20

Feedback

The correct answer is: 20 30

Question 25

Incorrect

Marked out of 1

Flag question

Question text

What will be the output of the following Java code?

public class IfTester
{ 
  public static void main(String[] args)
  { 
    int number1 = 10, number2; 
    if(number1 == 10) 
    {
      number2 = 20; 
    }
    if (number1 != 10) 
    { 
      number2 = 30; 
    } 
    System.out.println("Number2 :"+number2); 
  }
}

Choose the most appropriate option.

Select one:

a. Number2 :20 

b. Number2 :0

c. Number2 :30

d. Compilation Error: The local variable number2 may not have been initialized

Feedback

The correct answer is: Compilation Error: The local variable number2 may not have been initialized