Assuming the statement involves creating a new table SALES1 from the existing SALES table:
B . SALES1 created with 55,000 rows: If the statement involved creating SALES1 by selecting all rows from SALES (such as with a CREATE TABLE AS SELECT operation), then all 55,000 rows would be copied if no WHERE clause limited the selection.
E . SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table: When creating a table using the CREATE TABLE AS SELECT syntax, any NOT NULL constraints on columns in the original table will also apply to the new table.
Incorrect options:
A: PRIMARY KEY and UNIQUE constraints are not automatically copied with a CREATE TABLE AS SELECT; they must be explicitly redefined.
C: The table is created with rows if the original SELECT statement (assumed here) selected rows.
D: The statement about creating a table with 1 row is incorrect based on the assumed full selection of the original table's rows.