Which two statements are true about outer Joins?

• A.An outer join is used to retrieve only the rows that do not meet the join condition.
• B.The IN operator cannot be used in a condition that Involves an outer join.
• C.The outer join operator (+) is used next to the column of the table without the matching rows.
• D.A condition representing an outer join cannot be linked to another condition using the or logical operator.
• E.The outer join operator (+) can be used on both sides of the join condition in an outer join.

Comment: *

Name: *

Email: *

Verification: *

n 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 IS
• B.Abigail PA
• C.An error message
• D.Abigail Pa

Comment: *

Name: *

Email: *

Verification: *

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

• 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.A table can have only one primary key and one foreign key.
• C.Only the primary key can be defined at the column and table level.
• D.The foreign key columns and parent table primary key columns must have the same names.
• 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.Primary key and foreign key constraints can be defined at both the column and table level.
• G.A table can have only one primary key but multiple foreign keys.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?

• A.UNION ALL
• B.MINUS
• C.UNION
• D.INTERSECT

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

• A.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• B.A TIMESTAMP data type column contains information about year, month, and day
• C.The CURRENT_TIMESTAMP function returns data without time zone information
• D.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
• E.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Comment: *

Name: *

Email: *

Verification: *