Manipulating Relational Databases

What does SQL stand for?

• Sequal Query Language

• Structured Quotes Language

• Structured Query Language

• Sequential Query Language

Which of the following is NOT a command for modifying data in a database?

• INSERT

• UPDATE

• ADD

• DELETE

SQL can be used to retrieve data from the database. It completes this action through the use of the ______ command.

• ADD

• INTO

• SELECT

• CHECK

What command do we use to give access privileges to a user?

• CREATE

• UPDATE

• INSERT

• GRANT

The database would be more secure if every user was given user admin access.

• True

• False

The commands to check database integrity and backup data are often unique to each different database management system.

• True

• False

With the following command:

1. UPDATE Employees

2. SET LastName = 'Thompson', City= 'Swindon'

3. WHERE EmpID = 1;

What is the purpose of line 3?

• Identifies the database you wish to update.

• Identifies the table you wish to update.

• Identifies the field you wish to update.

• Identifies the record you wish to update.

What does the following command do?

DELETE FROM Employees

WHERE EmpID = 1;

• Deletes the Employees Table.

• Deletes the record where EmpID is 1.

• Deletes the number 1 from the EmpID field.

• Deletes the EmpID field.

With the following command:

1. CREATE USER 'daniel'@'localhost'

2. IDENTIFIED BY 'my_password';

What is the purpose of line 2?

• Sets the user's username.

• Sets the user's password.

• Sets the user's privileges.

• Sets the user's database.

All databases require you to understand SQL.

• True

• False