Customers (cNo, cName, cSurname, cCity, cPhone, cDOB, saleRepId) saleRepId: references Salespersons(sNo) Salespersons (sNo, sName, sSurname, sCity, sDepartment, sSalary, sPhone, sHiredate) Which of the following queries displays salespersons working in departments 20, 30 or 50 in alphabetical order by surname?

Select one:

a.SELECT * from Salespersons WHERE sDepartment in (20,30,50) ORDER BY sSurname desc;

b.SELECT * from Salespersons WHERE sDepartment = 20,30,50 ORDER BY sSurname asc;

c.SELECT * from Salespersons WHERE sDepartment between 20 and 50 GROUP BY sSurname asc;

d.SELECT * from Salespersons WHERE sDepartment in (20,30,50) ORDER BY sSurname asc;

Which of the following operators is used with a multiple-row subquery?

Select one:

a.IN

b.All of the options

c.ANY

d.ALL

To restore the values of a table, you must use the ___________ command.

Select one:

a.COMMIT

b.RESTORE

c.REVOKE

d.ROLLBACK

What is the attribute that could be obtained using other attributes in the Entity-Relationship Diagram?

Select one:

a.Multi-Valued Attribute

b.Composite Attribute

c.Single-Valued Attribute

d.Derived / Calculates Attribute

In the relational model, for which relationship set a new table should be created?

Select one:

a.Many-to-Many Relationships

b.One-to-One Relationship

c.One-to-Many Relationship

d.Recursive Relationship

__________ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Select one:

a.Durability

b.Isolation

c.Atomicity

d.Consistency