RDS Quiz

_______ selects tuples that satisfy the given condition from a relation.

• selection

• projection

• union

• intersection

____ join does not use any comparison operator.

• conditional

• natural

• theta

• equi

---

____ is the syntax used to display the structure of table.

• show tables

• describe table

• define table

• select * from table

complete the following query to delete a record from table.

delete ___ student ____ sname____'priya';

• from,where,=

• *,where,>=

• in,like,=

• *,where,<=

Identify the correct query to add nee column in table using alter command.

• alter table student add column sage int;

• alter table student add sage;

• alter table student add sage int;

• alter table student add sage int

---

____ command is used to backup the database in Mysql.

• mysql

• mysqldump

• mysqlbin

• mysqlstore

---

____query is used to find the total of product quantity in product table.

• select MIN(pquantity) from product;

• select MAX(pquantity) from product;

• select SUM(pquantity) from productl

• select AVG(pquantity) from product;

____ query will display the year from the given date.

• select date("2025-03-02 04:55:11");

• select month("2025-03-02 04:55:11");

• select year("2025-03-02 04:55:11");

• select day("2025-03-02 04:55:11");

---

---

_____query will display current date with time.

• select now();

• select curtime();

• select datetimenow();

• select timenow();

____ function is used to join two strings.

• combine

• concat

• instr

• length