With SQL, how do you select all the records from a table named "Persons", where the value of the column "FirstName" ends with an "a"?

1. SELECT * FROM Persons WHERE FirstName = 'a';
2. SELECT * FROM Persons WHERE FirstName LIKE 'a%';
3. SELECT * FROM Persons WHERE FirstName LIKE '%a';
4. SELECT * FROM Persons WHERE FirstName = '%a%';

Assertion (A): In hierarchical model, searching for a record is a time-consuming task.

Reasoning (R): Hierarchical model owns to the organization of information/data in a tree-like structure.

1. Both A and R are true and R is the correct explanation of A.
2. Both A and R are true but R is not the correct explanation of A.
3. A is true but R is false.
4. A is false but R is true.

Assertion (A): A database is the largest component for holding and storing data and may contain several tables.

Reasoning (R): Each table comprises multiple rows and records.

1. Both A and R are true and R is the correct explanation of A.
2. Both A and R are true but R is not the correct explanation of A.
3. A is true but R is false.
4. A is false but R is true.

Assertion (A): Referential integrity is a constraint that defines rules of holding data in parent and child table.

Reasoning (R): Referential integrity ensures that users don't accidently delete or change related data.

1. Both A and R are true and R is the correct explanation of A.
2. Both A and R are true but R is not the correct explanation of A.
3. A is true but R is false.
4. A is false but R is true.