Module assessment

1.

Which permissions are needed to be able to create a table using Transact-SQL?

The ALTER TABLE, and CREATE SCHEMA permissions.

The UPDATE TABLE, and MODIFY SCHEMA permissions.

The CREATE TABLE, and ALTER SCHEMA permissions.

2.

Which of the following features is required for a CTE query?

The query must have a WITH … AS clause.

The query must include a GROUP BY clause.

The query must include a CREATE FUNCTION statement.

3.

Someone wants to create a global temporary table, what will they need to do?

Add a single # in front of the table name in the CREATE TABLE statement.

Add ## in front of the table name in the CREATE TABLE statement.

Add a Global# in front of the table name in the CREATE TABLE statement.

Feedback