QUESTION 1

Match the scenario to the appropriate MySQL task.

1-	GRANT ALL ON *.* TO Ricardo;	a.	Ricardo may change and view rows in any table in the production database but may not add or delete a row.
2-	GRANT ALL ON *.* to ricardo WITH GRANT option;	b.	Ricardo may add and delete rows to any table in the production database but may not change an existing row.
3-	GRANT SELECT, INSERT, DELETE ON production.* to Ricardo.	c.	Ricardo has access to, and may modify, all databases and tables on the server and may extend his privileges to other users.
4-	GRANT SELECT, UPDATE on production.* to Ricardo;	d.	Ricardo has access to, and may modify, all databases and tables on the server.
5-	GRANT ALL on production.customers to Ricardo.	e.	Ricardo has access to and may modify all rows, columns, and table objects contained in the customers table of the production database.

QUESTION 2

Match the function to its purpose.

1-	RTRIM(4)	a.	Remove 4 trailing spaces.
2-	LTRIM(4)	b.	Return the first 4 characters.
3-	RIGHT(4)	c.	Return 4 the last 4 characters.
4-	LEFT(4)	d.	Remove 4 leading spaces.

QUESTION 3

Match the description of the privileges to the correct GRANT statement.

1-	GRANT ALL ON *.* TO Ricardo;	a.	Ricardo may change and view rows in any table in the production database but may not add or delete a row.
2-	GRANT ALL ON *.* to ricardo WITH GRANT option;	b.	Ricardo may add and delete rows to any table in the production database but may not change an existing row.
3-	GRANT SELECT, INSERT, DELETE ON production.* to Ricardo.	c.	Ricardo has access to, and may modify, all databases and tables on the server and may extend his privileges to other users.
4-	GRANT SELECT, UPDATE on production.* to Ricardo;	d.	Ricardo has access to, and may modify, all databases and tables on the server.
5-	GRANT ALL on production.customers to Ricardo.	e.	Ricardo has access to and may modify all rows, columns, and table objects contained in the customers table of the production database.

QUESTION 4

Match the term to a definition.

1-	One or more columns that uniquely define each row in a table.	a.	INDEX
2-	A column in one table that refers to the primary key of another table.	b.	PRIMARY KEY
3-	A means of a defining to a data base management system the specific location of a row.	c.	REFERENTIAL INTEGRITY
4-	When enforced, prevents the creation of any rows that would cause an invalid relationship between two tables.	d.	FOREIGN KEY