Skip to main content

Get's Answer

We provides solutions for different resources over internet.

Search This Blog

Home
Google Cloud Platform
Coding
Codechef

Mock 3 Slot3 - Quiz - 21st July Quiz Quiz

By Astrio Jather July 22, 2021

Mock 3 Slot3

Quiz - 21st July

Important Questions

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

DH21_ASE B3 Mock 3 Slot3 - Quiz - 21st July Quiz Quiz Started on Wednesday, 21 July 2021, 5:01 PM State Finished Completed on Wednesday, 21 July 2021, 5:57 PM Time taken 55 mins 32 secs Question 1 Correct Marked out of 1 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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 Not flaggedFlag 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) Accenture Pre Learning module 2021 2022

Get link
Facebook
X
Pinterest
Email
Other Apps

Labels

Accenture PreLearning HTML Java Mock Test RDBMS XML and JSON

Labels: Accenture PreLearning HTML Java Mock Test RDBMS XML and JSON

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Subscribe to Get's Answer by Email

Subscribe to my email newsletter & receive updates right in your inbox.

Contributors

Anonymous
Astrio Jather

Archive

December 20211
October 202133
September 202112
August 202111
July 202133
June 202124
May 20214
February 20213
December 20204
October 202023

Labels

AA Question
AAA Question
Accenture
Accenture PreLearning
Algo
C++
CodeChef
CodingDare
HTML
Java

Mock Test
New Approach
OOPs
Pre & Post Quiz
RDBMS
Software Enginerring
Unix
XML and JSON

Show more Show less

Report Abuse

Powered by Blogger