Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.External table files can be used for other external tables in a different database
• B.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• C.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• D.They cannot be partitioned
• E.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• F.They support UPDATEs but not INSERTs and DELETEs

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

• A.Data block headers contain their own Data Block Address (DBA)
• B.A table row piece can be chained across several database blocks
• C.Multiple row pieces from the same row may be stored in different database blocks
• D.Multiple row pieces from the same row may be stored in the same block
• E.Data block free space is always contiguous in the middle of the block
• F.Index block free space is always contiguous in the middle of the block

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A.INTERSECT returns rows common to both sides of the compound query
• B.Column names in each SELECT in the compound query can be different
• C.INTERSECT ignores NULLs
• D.Reversing the order of the intersected tables can sometimes affect the output
• E.The number of columns in each SELECT in the compound query can be different

Comment: *

Name: *

Email: *

Verification: *

Which three failures do not require intervention for recovery? (Choose three.)

• A.transaction failure
• B.network interface card (NIC) failure
• C.user process failure
• D.statement failure
• E.media failure

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_incoms_level IS NOT NULL
  AND due_amount IS NOT NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND cust_credit_limit IS NOT NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND due_amount !=NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND cust_credit_level !=NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level <> NULL
  AND due_amount <> NULL;

Comment: *

Name: *

Email: *

Verification: *