Oracle 1Z0-071 Quiz 7 Topic 1 Questions 31-35

Question: 1

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS?

AThe name off each column in the first Select list must match the name of the corresponding column In each subsequent select list.

BThe must be an equal number of columns In each select list.

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

DEach select statement In the query can have an order by clause.

EThe FOR update clause cannot be specified.

Show Answer

Question: 2

Examine this list of queries:

1. SELECT ROUND (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;

2. SELECT ROUND (15, 193, 1)) ''Results'' FROM DUAL;

3. SELECT (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;

4. SELECT ROUND (ROUND (15. 193, 1)) ''Results'' FROM DUAL;

Which two statements are true?

A1 and 4 give different results.

B2 and 3 give the same result.

C2 returns the value 20.

D1 and 4 give the same result.

E3 returns an error.

Show Answer

Question: 3

Examine these statements which execute successfully:

q3_1Z0-071

Both statements display departments ordered by their average salaries.

Which two are true?

ABoth statements will display departments with no employees.

BOnly the first statement will display departments with no employees.

COnly the first statement will execute successfully if you add E.AVG_SAL to the select list.

DOnly the second statement will execute successfully if you add E.AVG_SAL to the select list.

EBoth statements will execute successfully If you add E.AVG_SAL. to the select list.

FOnly the second statement will display departments with no employees.

Show Answer

Question: 4

Which two are true about multitable insert statements?

AThe conditional insert all statement inserts rows into a single table by aggregating source rows.

BThe unconditional insert all statement must have the same number of columns In both the source and target tables.

CThe conditional insert first statement always Inserts a row Into a single table.

DThey always use subqueries.

EThey can transform a row from a source table Into multiple rows In a target table.

Show Answer

Question: 5

Examine this data in the EMPLOYEES table:

q5_1Z0-071

Which statement will execute successfully?

ASELECT dept_id, LENGTH (last: name) , SUM(salary) FROM employees GROUP BV dept_id;

BSELECT dept_id, STDDEV(last_name), SUM( salary) FROM employees GROUP BV dept_id;

CSELECT dept_id, MAX (last_name) . SUM(salary) FROM employees GROUP BY dept_id;

DSELECT dept_id( INSTR(last_name, 'A'), SUM (salary) FROM employees GROUP BY dept_id;

Show Answer

Oracle 1Z0-071 Quiz:7 Topic:1 Questions:31-35