Oracle Database: SQL Fundamentals Part lll

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

Write your full Name ? *

Whats your Moblie Number ? *

Q241: *

1 point

ORDER BY prod_list_price DESC, prod_name;

ORDER BY (2*prod_min_price)DESC, prod_name;

ORDER BY prod_name, (2*prod_min_price)DESC;

ORDER BY prod_name DESC, prod_list_price DESC;

ORDER BY prod_list_price DESC, prod_name DESC;

Q242: View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table. *

1 point

Only the first query executes successfully.

Only the second query executes successfully.

Both queries execute successfully but give different results.

Both queries execute successfully and give the same result.

Q243: Which tasks can be performed using SQL functions that are built into the Oracle database? (Choose three.) *

1 point

finding the remainder of a division

adding a number to a date for a resultant date value

comparing two expressions to check whether they are equal

checking whether a specified character exists in a given string

removing trailing, leading, and embedded characters from a character string

Required

Q244: Which statements are true regarding single-row functions? (Choose all that apply.) *

1 point

MOD: returns the quotient of a division

TRUNC : can be used with NUMBER and DATE values

CONCAT : can be used to combine any number of values

SYSDATE : returns the database server current date and time

INSTR : can be used to find only the first occurrence of a character in a string

TRIM : can be used to remove all the occurrences of a character from a string

Required

Q245: *

1 point

Abigail PA

Abigail Pa

Abigail IS

an error message

Q246: *

1 point

'Oder' and 'Aus'

an error because the TRIM function specified is not valid

an error because the LOWER function specified is not valid

an error because the REPLACE function specified is not valid

Q247: *

1 point

SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc';

SELECT SUBSTR(cust_name,INSTR(cust_name,' ')+1) FROM customers WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%';

SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP ('MC%');

SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%');

Q248: *

1 point

SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',1,2)<>0;

SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',-1,2)<>0;

SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)- INSTR(cust_name,''),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',-1,-2)<>0;

SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)- INSTR(cust_name,' '),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',1,2)<>0 ;

Q249: View the Exhibit and examine the structure of the EMPLOYEES table. *

1 point