Examine the data in the CUST_NAME column of the CUSTOMERS table.

You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:

Which two queries give the required output?

• A.SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') "CUST NAME"FROM customersWHERE INSTR(cust_name, ' ',1,2)<>0;
• B.SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, ' '), '*') "CUST NAME"FROM customersWHERE INSTR(cust_name, ' ',1,2)<>0;
• C.SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') "CUST NAME"FROM customersWHERE INSTR(cust_name, ' ',-1,2)<>0;
• D.SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, ' '), '*') "CUST NAME"FROM customersWHERE INSTR(cust_name, ' ',1,-2)<>0;

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding external tables?

• A.The CREATE TABLE AS SELECT statement can be used to upload data into a normal table in the database from an external table.
• B.The data and metadata for an external table are stored outside the database.
• C.The default REJECT LIMIT for external tables is UNLIMITED.
• D.ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure proposed for the TRANSACTIONStable:

Which two statements are true regarding the creation and storage of data in the above table structure?
(Choose two.)

• A.The CUST_STATUScolumn would store exactly one character.
• B.The CUST_STATUScolumn would give an error.
• C.The TRANS_VALIDITYcolumn would have a maximum size of one character.
• D.The TRANS_VALIDITYcolumn would give an error.
• E.The TRANS_DATEcolumn would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.
• F.The CUST_CREDIT_LIMITcolumn would be able to store decimal values.

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to create the DEPARTMENT_DETAILS and the COURSE-DETAILS tables:
SQL> CREATE TABLE DEPARTMfiNT_DETAILS
DEPARTMENT_ID NUMBER PRIMARY KEY ,
DEPARTMEHT_NAME VARCHAR2(50) ,
HOD VARCHAP2(50));
SQL> CREATE TABLE COURSE-DETAILS
(COURSE ID NUMBER PRIMARY KEY ,
COURS_NAME VARCHAR2 (50) ,
DEPARTMEHT_ID NUMBER REFERENCES DEPARTMENT_DETAIL
You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

• A.SELECT d.department id. ccours_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id);
• B.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department___id).- (DEPARTMENT_ID) ;
• C.SELECT d.departranc_id, c.cours<<_id FROM cource_deatils c LEFT OUTER JOIN departmnt_details d ON (c.dapartmsnt_id=d.departtnent_id);
• D.SELECT d.department_id, c. course_id FROM dapartment_details d RIGHT OUTER JOIN course_dotails c ON (c.depattnient_id=d.department_id) ;

Comment: *

Name: *

Email: *

Verification: *

See the Exhibit and examine the structure of the PROMOTIONS table:

Using the PROMOTIONS table,
you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

• A.It generates an error because multiple conditions cannot be specified for the WHEN clause.
• B.It executes successfully and gives the required result.
• C.It generates an error because CASE cannot be used with group functions.
• D.It generates an error because NULL cannot be specified as a return value.

Comment: *

Name: *

Email: *

Verification: *