Data Manipulation Language

Question 1

What does SELECT INTO do?

Answer 1

Creates a new table based on the result set of a SELECT statement

Question 2

What does the INTO keyword do?

Answer 2

Identifies the name of the table to create

Question 3

Where do you place the INTO keyword?

Answer 3

The INTO keyword is placed after the last column name in the SELECT clause and before the FROM clause

Question 4

How long do temp tables last?

Answer 4

Temp tables are temporary tables that only last for the duration of your SQL Server session

Question 5

What’s the syntax for a local temp table vs a global temp table

Answer 5

Local temp tables are prefixed with a hash tag (#), global temp tables are prefixed with two hashtags (##)

Question 6

What does the INSERT statement do?

Answer 6

The INSERT statement is used to add one or more rows of
data into an existing table. The data can come from

Question 7

Where does the INSERT statement pull data from?

Answer 7

From an external source such as a text file or
Excel spreadsheet

Question 8

What is a ways to enter data into SQL?

Answer 8

Enter data manually using the INSERT VALUES clause

INSERT INTO Employee (EmployeeID, LastName, FirstName, Email)
VALUES (101, ‘Doe’, ‘John’, ‘john.doe@example.com’);

Question 9

What is INSERT INTO … SELECT use for?

Answer 9

it is used for inserting rows based on the result of a query from another table.

INSERT INTO Customer_temp (CustomerID, LastName, FirstName, Email)
SELECT EmployeeID + 200, LastName, FirstName, Email
FROM Employee
WHERE HireDate > ‘2020-01-01’;

Question 10

How do you remove tables from a database?

Answer 10

Drop Table

Question 11

How do you modify existing records in a table?

Answer 11

UPDATE statement

Question 12

Which two keywords use the WHERE clause to filter results?

Answer 12

The UPDATE and DELETE keywords