displaying a date in a nondefault format

finding the number of characters in an expression

substituting a character string in a text expression with a specified string

combining more than two columns or expressions into a single column in the output

An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.

An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.

A DELETE FROM..... statement can remove rows based on only a single condition on a table.

An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a
table.

A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

SELECT cust_last_name AS “Name”, cust_credit_limit + 1000AS “New Credit Limit”FROM
customers;

SELECT cust_last_name AS Name, cust_credit_limit + 1000AS New Credit LimitFROM customers;

SELECT cust_last_name AS Name, cust_credit_limit + 1000“New Credit Limit”FROM customers;

SELECT INITCAP (cust_last_name) “Name”, cust_credit_limit + 1000INITCAP (“NEW CREDIT
LIMIT”)FROM customers;

An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.

An UPDATE... SET... statement can modify multiple rows based on multiple conditions
on a table.

A DELETE FROM..... statement can remove rows based on only a single condition on a
table.

An INSERT INTO... VALUES..... statement can add a single row based on multiple
conditions on a table.

A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

Select deptno. no LISTAGG(ename, ',') WITHIN GROUP (GROUP BY deptno) AS employee-list
FROM emp
ORDER BY emp

Select deptno. LISTAGG(ename, ',') WITHIN GROUP AS employee-list
FROM emp
GROUP BY emp

Select deptno. LISTAGG(ename, ',') WITHIN GROUP AS employee-list
FROM emp
ORDER BY ename;

Select deptno. no LISTAGG(ename, ',') WITHIN GROUP(ORDER BY ename) AS employee-list
FROM emp
ORDER BY emp

Line 5

Line 3

Line 7

Line 8

OODB supports multiple objects in the same database, whereas RDB supports only tables.

RDB supports only E.F. Codd’s rules, whereas OODB does not support them.

OODB incorporates methods with data structure definition, whereas RDB does not allow this.

RDB allows the definition of relationships between different tables, whereas OODB does not allow this.

The rollback generates an error.

No SQL statements are rolled back.

Only the DELETE statements are rolled back.

Only the second DELETE statement is rolled back.

Both the DELETE statements and the UPDATE statement are rolled back.