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 is selecting the owner and table_name from the dba_tables where the table_name is 'CUSTOMER'. This means that the query will return a listing of the owner of the table with the name 'CUSTOMER', not the actual customers within that table.

What Results Would the Following SQL Statement Produce? Select Owner