SQL 1

________ is a standard language for accessing and manipulating databases.

SQL stands for ______

RDBMS stands ________

Write the correct SQL statement to create a new database called testDB.

Write the correct SQL statement to delete a database named testDB:

________________;

Write the correct SQL statement to create a new table called Persons.

____________ (

PersonID int,

LastName varchar(255),

FirstName varchar(255),

Address varchar(255),

City varchar(255) );

Write the correct SQL statement to create a differential back up of the database "testDB":

BACKUP DATABASE testDB
TO DISK = 'D:\backups\testDB.bak'
__________;

Write the correct SQL statement to create a database called "testDB":

CREATE DATABASE _____;

Write the correct SQL statement to remove all the records of the "CUSTOMERS" table, not the table itself:

_________ CUSTOMERS;

Complete the SQL statement to create a new table called "TestTables":

CREATE TABLE ________ __
SELECT customername, contactname
FROM customers;