Tag Archives: statement

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.) A. The number, but not names, of columns must be identical for all SELECT statements in the query. B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by… Read More »

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.) A. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause B. Only… Read More »

Given: (Exhibit) Which statement is equivalent to line 1?

Given:Which statement is equivalent to line 1? A. double totalSalary = list.stream().map(e > e.getSalary() * ratio).reduce (bo).ifPresent (p > p.doubleValue()); B. double totalSalary = list.stream().mapToDouble(e > e.getSalary() * ratio).sum; C. double totalSalary = list.stream().map(Employee::getSalary * ratio).reduce (bo).orElse(0.0); D. double totalSalary = list.stream().mapToDouble(e > e.getSalary() * ratio).reduce(starts, bo); Correct Answer: C

Given: (Exhibit) Which statement is equivalent to line 1?

Given:Which statement is equivalent to line 1? A. double totalSalary = list.stream().map(e -> e.getSalary() * ratio).reduce (bo).ifPresent (p -> p.doubleValue()); B. double totalSalary = list.stream().mapToDouble(e -> e.getSalary() * ratio).sum; C. double totalSalary = list.stream().map(Employee::getSalary * ratio).reduce (bo).orElse(0.0); D. double totalSalary = list.stream().mapToDouble(e -> e.getSalary() * ratio).reduce(starts, bo); Correct Answer: C

Given the content of three files: (Exhibit) Which statement is true?

Given the content of three files:Which statement is true? A. The A.Java and B.java files compile successfully. B. Only the A.Java file compiles successfully. C. Only the C.java file compiles successfully. D. The A.Java and C.java files compile successfully. E. Only the B.java file compiles successfully. F. The B.java and C.java files compile successfully. Correct Answer: B

Given: (Exhibit) You want to use the myResource class in a try-with-resources statement. Which change

Given:You want to use the myResource class in a try-with-resources statement. Which change will accomplish this? A. Implement AutoCloseable and override the close method. B. Extend AutoCloseable and override the autoClose method. C. Extend AutoCloseable and override the close method. D. Implement AutoCloseable and override the autoClose method. Correct Answer: A