The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.Which query can be used? A. SELECT… Read More »
Given:and:Which code, when inserted on line 10, prints the number of unique localities from the roster list? A. .map(e > e.getLocality()).collect(Collectors.toSet()).count(); B. map(e > e.getLocality()).count(); C. .map(Employee::getLocality).distinct().count(); D. .filter(Employee::getLocality).distinct().count(); Correct Answer: D
Given:Examine these requirements:* Eliminate code duplication.* Keep constant the number of methods other classes may implement from this interface.Which method can be added to meet these requirements? A. Option A B. Option C C. Option D D. Option B Correct Answer: D
Given:and:Which code, when inserted on line 10, prints the number of unique localities from the roster list? A. .map(Employee::getLocality).distinct().count(); B. .filter(Employee::getLocality).distinct().count(); C. .map(e -> e.getLocality()).collect(Collectors.toSet()).count(); D. map(e -> e.getLocality()).count(); Correct Answer: B
Given:and:Which code, when inserted on line 10, prints the number of unique localities from the roster list? A. map(e > e.getLocality()).count(); B. .filter(Employee::getLocality).distinct().count(); C. .map(Employee::getLocality).distinct().count(); D. .map(e > e.getLocality()).collect(Collectors.toSet()).count(); Correct Answer: B
You need to calculate the number of days from 1st January 2019 until today.Dates are stored in the default format of DD-MON-RR.Which two queries give the required output? (Choose two.) A. SELECT ROUND(SYSDATE ?’01-JAN-2019′) FROM DUAL; B. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY’) ?`01/JANUARY/2019′ FROM DUAL; C. SELECT SYSDATE ?TO_DATE(’01-JANUARY-2019′) FROM DUAL; D. SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY’) ?’01-JAN-2019′ FROM DUAL; E. SELECT… Read More »
Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.Examine these SQL statements:Statement 1:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_items;Statement 2:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_itemsGROUP BY order_id;Which two statements are true? A. Statement 2 returns only one row of output. B. Statement 2 may return multiple rows of output. C. Both the statements give the same… Read More »
Given the Customer table structure:* ID Number Primary Key* NAME Text NullableGiven code fragment:Which statement inserted on line 14 sets NAME column to a NULL value? A. Stmt.setNull(2 string, class); B. Stmt.setNull(2, java.lang, string); C. Stmt.setNull(2, java,sql. Types, VARCHAR); D. Stmt.setNull(2, null); Correct Answer: C
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.Examine these SQL statements:Statement 1:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_items;Statement 2:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_itemsGROUP BY order_id;Which two statements are true? A. Statement 1 returns only one row of output. B. Statement 2 returns only one row of output. C. Both statements will return… Read More »
You need to calculate the number of days from 1st January 2019 until today.Dates are stored in the default format of DD-MON-RR.Which two queries give the required output? (Choose two.) A. SELECT ROUND(SYSDATE – TO_DATE(’01/JANUARY/2019′)) FROM DUAL; B. SELECT ROUND(SYSDATE – ’01-JAN-2019′) FROM DUAL; C. SELECT SYSDATE – TO_DATE(’01-JANUARY-2019′) FROM DUAL; D. SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ’01/JANUARY/2019′ FROM… Read More »