L-W

Question 1

Returns all rows from the left table and matching rows from the right table

Answer 1

Left Join

Question 2

Searches for a specific pattern in a column

Answer 2

Like

Question 3

Specifies the number of records to return in the result set

Answer 3

Limit

Question 4

Only includes rows where a condition is not true

Answer 4

Not

Question 5

A constraint that enforces a column to not accept NULL values

Answer 5

Not Null

Question 6

Includes rows where either condition is true

Answer 6

Or

Question 7

Sorts the result set in ascending or descending order

Answer 7

Order By

Question 8

Returns all rows when there is a match in either left table or right table

Answer 8

Outer Join

Question 9

A constraint that uniquely identifies each record in a database table

Answer 9

Primary Key

Question 10

A stored procedure

Answer 10

Procedure

Question 11

Returns all rows from the right table and the matching rows from the left table

Answer 11

Right Join

Question 12

Specifies the number of records to return in the result set

Answer 12

Rownum

Question 13

Selects data from a database

Answer 13

Select

Question 14

Selects only distinct (different) values

Answer 14

Select Distinct

Question 15

Copies data from one table into a new table

Answer 15

Select Into

Question 16

Specifies the number of records to return in the result set

Answer 16

Select Top

Question 17

Specifies which columns and values that should be updated is a table

Answer 17

Set

Question 18

Creates a table or adds deletes or modifies columns in a table or deletes a table or data inside a table

Answer 18

Table

Question 19

Specifies the number of records to return in the result set

Answer 19

Top

Question 20

Deletes the data inside a table but not the table itself

Answer 20

Truncate Table

Question 21

Combines the result set of two or more Select statements (only distinct values)

Answer 21

Union

Question 22

Combines the result set of two or more Select statements (allows duplicate values)

Answer 22

Union All

Question 23

A constraint that ensures that all values in a column are unique

Answer 23

Unique

Question 24

Updates existing rows in a table

Answer 24

Update

Question 25

Specifies the value of an Insert Into statement

Answer 25

Values

Question 26

Creates updates or deletes a view

Answer 26

View

Question 27

Filter a result set to include only records that fulfill a specified condition

Answer 27

Where