Which of the following statements would create a user login role named southwest with the password set as “111AB”?
A.)
CREATE ROLE southwest PASSWORD '111AB';
B.)
CREATE ROLE southwest PASSWORD '111AB' LOGIN;
C.)
CREATE ROLE 'southwest' PASSWORD '111AB';
D.)
CREATE ROLE 'southwest' LOGIN PASSWORD 111AB;