A-C

Question 1

Adds a column in an existing table

Answer 1

Add

Question 2

Adds a constraint after a table is already created

Answer 2

Add Constraint

Question 3

Returns true of all of the sub query values meet the condition

Answer 3

All

Question 4

Adds deletes or modify columns in a table, or changes the data type of a column in a table

Answer 4

Alter

Question 5

Changes the data type of a column in a table

Answer 5

Alter Column

Question 6

Adds deletes or modifies columns in a table

Answer 6

Alter Table

Question 7

Only includes rows where both conditions are met

Answer 7

And

Question 8

Returns true if any of the sub query values meet the condition

Answer 8

Any

Question 9

Renames a column in a table with an Alia’s

Answer 9

As

Question 10

Sorts the result set in ascending order

Answer 10

Asc

Question 11

Creates a backup of an existing database

Answer 11

Backup Database

Question 12

Selects values within a given range

Answer 12

Between

Question 13

Creates different output based on condition

Answer 13

Case

Question 14

A constraint that that limits the value that can be placed in a column

Answer 14

Check

Question 15

Changes the data type of a column or deletes a column in a table

Answer 15

Column

Question 16

Adds or deletes a constraint

Answer 16

Constraint

Question 17

Creates a database index view table or procedure

Answer 17

Create

Question 18

Creates a new SQL database

Answer 18

Create Database

Question 19

Creates an index on a table (allows duplicate values)

Answer 19

Create Index

Question 20

Updates a View

Answer 20

Create or Replace View

Question 21

Creates a new table in the database

Answer 21

Create Table

Question 22

Creates a Stored Procedure

Answer 22

Create Procedure

Question 23

Creates a unique index on a table (no duplicate values)

Answer 23

Create Unique Index

Question 24

Creates a view based on the result set of a Select statement

Answer 24

Create View