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

View Answer

Answer: B

Explanation:

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

parent object.