View the Exhibit and examine the structure and data in the INVOICE table. Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.) A. inv_amt =’0255982′ : requires explicit conversion B. inv_date >…

View the Exhibit and examine the structure of the EMPLOYEES table. Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table: ENAME HIREDATE ---------------------------------- SMITH 17-DEC-80 ALLEN 20-FEB-81 WARD 22-FEB-81 You want to generate a list of…

Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME --------------------- Lex De Haan Renske Ladwig Jose Manuel Urman Jason Mallin You want to extract only those customer names that have three names and display the * symbol…

Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME ------------------------ Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikkilineni Julia Nayer You need to display customers’ second names where the second name starts with "Mc" or…

View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values ‘Anderson’ and ‘Ausson’. You issue the following query: SQL> SELECT LOWER(REPLACE(TRIM(‘son’ FROM cust_last_name),’An’,’O’)) FROM CUSTOMERS WHERE LOWER(cust_last_name) LIKE ‘a%n’;…

In the CUSTOMERS table, the CUST_CITY column contains the value ‘Paris’ for the CUST_FIRST_NAME ‘ABIGAIL’. Evaluate the following query: What would be the outcome? A. Abigail PA B. Abigail Pa C. Abigail IS D. an error message

Which statements are true regarding single row functions? (Choose all that apply.) A. MOD : returns the quotient of a division B. TRUNC : can be used with NUMBER and DATE values C. CONCAT : can be used to combine…

Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.) A. finding the remainder of a division B. adding a number to a date for a resultant date value C. comparing two expressions to…

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table. Evaluate the following two queries: SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code" FROM promotions ORDER BY code; SQL>SELECT DISTINCT promo_category promo_cost "code" FROM promotions ORDER BY…

View the Exhibit and examine the structure of the PRODUCTS table. You want to display only those product names with their list prices where the list price is at least double the minimum price. The report should start with the…