What results would the following SQL statement produce?
Select owner,table_name
From dba_tables
Where table_name = 'CUSTOMER';
A) A listing of all customers in the customer table
B) A listing of the owner of the customer table
C) A listing of the owner of the customer table as well as customers
D) An error message

Question

Quizplus · Accepted Answer

The SQL statement selects the "owner" and "table_name" columns from the "dba_tables" view where the "table_name" is equal to the string 'CUSTOMER'. This will result in a listing of owners of all tables named "CUSTOMER". It will not retrieve any customer data from the table.

What Results Would the Following SQL Statement Produce