Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)?

• A.Relating data from a table with data from the same table is implemented with a self join.
• B.An inner join relates rows within the same table.
• C.Rows from unrelated tables cannot be joined.
• D.Implementing a relationship between two tables might require joining additional tables.
• E.Every relationship between the two tables must be implemented in a Join condition.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding external tables?

• A.The CREATE TABLE AS SELECTstatement can be used to upload data into regular 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 LIMITfor external tables is UNLIMITED.
• D.ORACLE_LOADERand ORACLE_DATAPUMPhave exactly the same functionality when used with an external table.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit = 1000 or cust_credit_limit = 2000 or
cust_credit_limit = 3000
Which statement is true regarding the above two queries?

• A.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
• B.There would be no change in performance.
• C.Performance would degrade in query 2.
• D.Performance would improve in query 2.

Comment: *

Name: *

Email: *

Verification: *

Which two are true?

• A.CONCAT joins two or more character strings together.
• B.FLOOR returns the largest integer less than or equal to a specified number.
• C.CONCAT joins two character strings together.
• D.INSTR finds the offset within a string of a single character only.
• E.INSTR finds the offset within a character string, starting from position 0.
• F.FLOOR returns the largest positive integer less than or equal to a specified number.

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.MINUS
• B.UNION
• C.INTERSECT
• D.UNION ALL

Comment: *

Name: *

Email: *

Verification: *