A. The name of each column in the first SELECT list must match the name of the corresponding column in each subsequent SELECT list.

B. Each SELECT statement in the query can have an ORDER BY clause.

C. There must be an equal number of columns in each SELECT list.

D. The FOR UPDATE clause cannot be specified.

E. None of the set operators can be used when selecting CLOB columns.

A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

B. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

C. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E. A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

F. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

A. MERGE INTO employees e
USING new employees ne
WHERE e.employee_id = ne.employee_ id
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job_id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name, ne.job_id,ne.salary) ;

B. MERGE INTO employees e
USING new_employees n
WHERE e.employee_id = ne.employee_id
WHEN FOUND THEN
UPDATE SET e.name=ne.name,e.job_id =ne.job_id, e.salary=ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_ id,ne.name,ne.job id,ne.salary) ;

C. MERGE INTO employees e
USING new_employees n
ON (e.employee_id = ne.employee_id)
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name,ne.job_id,ne.salary);

D. MERGE INTO employees e
USING new employees ne
ON (e.employee_id = ne.employee_id)
WHEN FOUND THEN
UPDATE SET e.name =ne.name, e.job_id=ne.job_id, e.salary =ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_id,ne.name,ne.job_id,ne.salary) ;

A. The Oracle join syntax performs better than the SQL: 1999 compliant ANSI join syntax.

B. The join syntax used makes no difference to performance.

C. The between condition always performs less well than using the >= and <= conditions.

D. Table aliases can improve performance.

E. The between condition always performs better than using the >= and <= conditions.

A. MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
UPDATE SET n.price= p.cost*.01
DELETE WHERE (p.cost<200);

B. MERGE INTO new_prices n
USING products p
ON (p.prod_id =n.prod_id)
WHEN NOT MATCHED THEN
INSERT (n.prod _id, n.price) VALUES (p.prod_id, cost*.01)
WHERE (p.cost<200);

C. MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
DELETE WHERE (p.cost<200)

D. MERGE INTO new_prices n
USING (SELECT * FROM products) p
WHEN MATCHED THEN
UPDATE SET n.price= p.cost* 01
WHEN NOT MATCHED THEN
INSERT(n.prod_id, n.price) VALUES(p.prod_id, cost*.01)
WHERE(p.cost<200);

A. LAST_DAY return the date of the last day the previous month only.

B. ADD_MONTHS adds a number of calendar months to a date.

C. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.

D. CEIL requires an argument which is a numeric data type.

E. ADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.

F. LAST_DAY returns the date of the last day of the current ,month onlyu.

G. CEIL returns the largest integer less than or equal to a specified number.

A. WHERE (INITCAP(cust_last_name) LIKE 'A%' OR ITITCAP(cust_last_name) LIKE 'B%') AND cust_credit_limit < 1000

B. WHERE (UPPER(cust_last_name) LIKE 'A%' OR UPPER(cust_last_name) LIKE 'B%') AND ROUND(cust_credit_limit) < 1000;

C. WHERE UPPER(cust_last_name) BETWEEN UPPER('A%' AND 'B%') AND ROUND(cust_credit_limit) < 1000;

D. WHERE (UPPER(cust_last_name) like INITCAP ('A') OR UPPER(cust_last_name) like INITCAP('B')) AND ROUND(cust_credit_limit) < ROUND(1000) ;

E. WHERE UPPER(cust_last_name) IN ('A%', 'B%') AND cust_credit_limit < 1000:

A. Access flat files via a database, which are stored in an operating system directory.

B. Truncate a table in another schema.

C. Execute a procedure in another schema.

D. Query any table in a database.

E. Log in to a database.

F. Use the WITH GRANT OPTION clause.

A. SELECT "Hello! We're ready "FROM |DUAL;

B. SELECT q'[Hello! We're ready]'FROM DUAL;

C. SELECT q'! Hello! We're ready! 'FROM DUAL;

D. SELECT 'Hello! We're ready' FROM DUAL;

E. SELECT 'Hello! we\ re ready' ESCAPE'N'FROMDUAL:

A. an error

B. 3 rows

C. 1 row

D. 8 rows

E. 0 rows

F. 6 rows

A. A Flashback TABLE statement can be used to retrieve the deleted data.

B. It always retains the space used by the removed rows

C. It retains the indexes defined on the table.

D. It drops any triggers defined on the table.

E. It retains the integrity constraints defined on the table.

F. A ROLLBACK statement can be used to retrieve the deleted data.

A. An ORDER BY clause can perform a linguistic sort

B. An ORDR BY clause will always precede a HAVI NG clause if both are used in the same top-level

C. By default an ORDERBY clause sorts rows in ascending order

D. An ORDER BY clause always sorts NULL values last.

E. An ORDER BY clause can perform a binary sort