A.2 rows

B.an error

C.1 row

D.0 rows

A.CONCAT: can be used to combine any number of values

B.TRUNC: can be used with NUMBER and DATE values

C.MOD: returns the quotient of a division operation

D.FLOOR: returns the smallest integer greater than or equal to a specified number

E.CEIL: can be used for positive and negative numbers

A.SELECT COUNT (*)
FROM employees e
JOIN (SELECT salary FROM employees WHERE employee_ id= 110) a
ON e. salary< a. salary;

B.SELECT COUNT (* )
FROM employees e
WHERE e. salary < (SELECT a. salary FROM employees a WHERE e. employee_ id = 110);

C.SELECT COUNT (*)
FROM employees
JOIN employees a
ON e. salary< a. salary
WHERE a. employee_ id= 110;

D.SELECT COUNT (* )
FROM employees
WHERE salary < (SELECT salary FROM employees WHERE employee.id =
110) ;

A.For large tables TRUNCATE is faster than DELETE.

B.You can never TRUNCATE a table if foreign key constraints will be violated.

C.For tables with multiple indexes and triggers is faster than TRUNCATE.

D.You can never tows from a table if foreign key constraints will be violated.

A.INSERT can be granted only on tables and sequences.

B.SELECT can be granted on tables, views, and sequences.

C.REFERENCES can be grantrd only on tables.

D.ALTER can be granted only on tables and sequences.

E.DELETE can be granted on tables, views, and sequences.