Question

Which is a new DDL statement?

(a) DROP ROLES

(b) CREATE APPLICATION ROLE

(c) CREATE USERS

(d) None of the mentioned

This question was posed to me by my college professor while I was bunking the class.

I would like to ask this question from Data Definition Language in division Creating the Physical Database Schema of SQL Server

Answer 1

The correct answer is (b) CREATE APPLICATION ROLE

To explain: Application role creation changes the properties of an application role.