The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)

• A.qty_sold = `0554982' uses implicit conversion
• B.invoice_date = '15-march-2019' : uses implicit conversion
• C.CONCAT (qty_sold, invoice_date) : requires explicit conversion
• D.invoie_date > '01-02-2019' : uses implicit conversion
• E.qty_sold BETWEEN `101' AND '110' : uses implicit conversion

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It gives an error because the ALL keyword is not valid
• B.It executes successfully and gives the required result
• C.It gives an error because the GROUP BY clause is not valid
• D.It executes successfully but does not give the required result

Comment: *

Name: *

Email: *

Verification: *

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• B.Primary key and foreign key constraints can be defined at both the column and table level
• C.The foreign key columns and parent table primary key columns must have the same names
• D.A table can have only one primary key but multiple foreign keys
• E.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• F.A table can have only one primary key and foreign key
• G.Only the primary key can be defined at the column and table level

Comment: *

Name: *

Email: *

Verification: *

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

• A.as SCOTT in DALLAS_DB
• B.as SCOTT in BOSTON_DB
• C.as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D.as SYS in both the databases
• E.as SCOTT in both the databases

Comment: *

Name: *

Email: *

Verification: *

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A.sending each connection input request to the appropriate shared server input queue
• B.writing inbound request to the common request queue from all shared server connections
• C.broadcasting shared server session responses back to requesters on all connections
• D.sending shared server session responses back to requesters on the appropriate connection
• E.receiving inbound requests from processes using shared server connections
• F.checking for outbound shared server responses on the common outbound response queue

Comment: *

Name: *

Email: *

Verification: *