Kevin is the owner of the schema sales, Steve wanted to create new table in sales schema called regional_sales so Kevin grants the create table permissions to Steve. Steve creates the new table called regional_sales in sales schema, who is the owner of the table regional_sales

Kevin is the owner of the schema sales, Steve wanted to create new table in sales schema called regional_sales so Kevin grants the create table permissions to Steve. Steve creates the new table called regional_sales in sales schema, who is the owner of the table regional_sales
A . Kevin is the owner of sales schema, all the tables in the schema will be owned by Kevin
B. Steve is the owner of the table
C. By default ownership is assigned DBO
D. By default ownership is assigned to DEFAULT_OWNER
E. Kevin and Smith both are owners of table

Answer: B

Explanation:

A user who creates the object becomes its owner, does not matter who is the owner of the

parent object.