Tag Archives: Dumps

Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements execute successfully?

Examine this description of the TRANSACTIONS table:Which two SQL statements execute successfully? (Choose two.)SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 A. ‘DUES AMOUNT’ FROM transactions; B. 100 “DUES AMOUNT” FROM transactions;SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM C. “DUES” FROM transactions;SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 D. transactions;SELECT… Read More »

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.) A. External table files can be used for other external tables in a different database B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table C. The ORACLE_DATAPUMP access driver can be used to… Read More »

Given: class Overloading { int x(double d) { System.out.println("one"); return 0; } String x(double d)

Given:class Overloading {int x(double d) {System.out.println(“one”);return 0;}String x(double d) {System.out.println(“two”);return null;}double x(double d) {System.out.println(“three”);return 0.0;}public static void main(String[] args) {new Overloading().x(4.0);}}What is the result? A. Three B. One C. Two D. Compilation fails. Correct Answer: D

Which three statements are true about inner and outer joins? (Choose three.)

Which three statements are true about inner and outer joins? (Choose three.) A. A full outer join returns matched and unmatched rows B. An inner join returns matched rows C. Outer joins can only be used between two tables per query D. A full outer join must use Oracle syntax E. Outer joins can be used when there… Read More »

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 »