Name of the candidate: Abdullayev Ulug’bek

GRANT: Gives a user access to the database

REVOKE: Removes a user's access to the database

4. Transaction control language (TCL)
Transaction control language (TCL) manages the transactions within a database. Transactions group a set of related tasks into a single, executable task. All the tasks must succeed in order for the transaction to work. Here's a list of TCL statements:

• 
  COMMIT: Carries out a transaction
  
• 
  ROLLBACK: Restores a transaction if any tasks fail to execute
  
• 
  S**AVEPOINT**: Sets a point in a transaction to save
  

Question 4
Elucidate any two search options used in SQL with suitable example.

The most basic form of the SQL SELECT statement must be include SELECT, FROM clauses. In addition, if we want to filter the result set of the query, we should use the WHERE clause.

1	SELECT column1, column2 FROM table

The above query template specifies a very basic SQL SELECT statement. As you can see, column names are placed after the SELECT clause and these columns are separated with a comma sign with (,). After the FROM clause, we add the table name in which we want to populate the data into the result set. In addition, the following query template illustrates the usage of the WHERE clause in the SELECT query.

1	SELECT column1, column2 FROM table WHERE column1='value'

With the WHERE clause, we can filter the result set of the select statement. Filtering patterns are used after the WHERE clause. Now, we will make some SQL examples of the SQL SELECT statement and reinforce these theoretical notions.

Now, we will practice other SQL examples which are related to the SELECT statement. In this example first example, we will retrieve all columns of the table. If we want to return all columns of the table, we can use a (*) asterisk sign instead of writing whole columns of the table. Through the following query, we can return all columns of the table.

1	SELECT * FROM Fruits

In this section, we will take a glance at simple clause usage of the WHERE clause. If we want to filter the result set of the SQL SELECT statement, we have to use the WHERE clause. For example, we want to filter the fruits whose colors are red. In order to filter results of the query, at first we add the column name which we want to filter and then specify the filtering condition. In the below SQL example, we will filter the red fruits of the Fruits table.

1	SELECT * FROM Fruits WHERE Fruit_Color='Red'