…………… command is used to remove primary key from a table in SQL.

1. Update
2. Remove
3. Alter
4. Drop

Which of the following commands will delete the table from MYSQL database ?

1. DELETE TABLE
2. DROP TABLE
3. REMOVE TABLE
4. ALTER TABLE

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.