Tag Archives: type

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You

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 these requirements: * Bus and Boat are Vehicle type classes. * The start() and stop() methods perform

Given these requirements:* Bus and Boat are Vehicle type classes.* The start() and stop() methods perform common operations across the Vehicle class type.* The ride() method performs a unique operations for each type of Vehicle.Which set of actions meets the requirements with optimized code? A. 1. Create an abstract class Vehicle by defining start() and stop() methods, and… Read More »

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. Examine these

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 »

Which two statements are true for a two-dimensional array of primitive data type?

Which two statements are true for a two-dimensional array of primitive data type? A. It cannot contain elements of different types. B. The length of each dimension must be the same. C. At the declaration time, the number of elements of the array in each dimension must be specified. D. All methods of the class object may be… Read More »

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these

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 »