Free Oracle 1Z0-071 Exam Dumps and 1Z0-071 Exam Questions

Question No: 41

MultipleChoice

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

Options

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.

Question No: 42

MultipleChoice

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?

Options

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.

Question No: 43

MultipleChoice

Examine these statements which execute successfully:

Both statements display departments ordered by their average salaries.

Which two are true?

Options

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.

Question No: 44

MultipleChoice

Which two are true about multitable insert statements?

Options

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.

Question No: 45

MultipleChoice

Examine this data in the EMPLOYEES table:

Which statement will execute successfully?

Options

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;

Question No: 46

MultipleChoice

You execute these commands:

CREATE TABLE customers (customer_id INTEGER, customer_name VARCHAR2 (20) )

TNSERT INTO customers VALUES (1, 'Customer 1 ' ) ;

SAVEPOTNT post_insert;

INSERT INTO customers VALUES (2, 'Customer 2');

SELECT COUNT(*) FROM customers;

Which two, used independently, can replace so the query returns 1?

Options

AROLLBACK TO SAVEPOINT post_insert;

BROLLBACK TO post_insert;

CCOMMIT TO SAVEPOINT post_insert;

Dcommit;

EROLLBACK,'

Question No: 47

MultipleChoice

BOOK_SEQ is an existing sequence in your schema.

Which two CREATE TABLE commands are valid?

A)

B)

C)

D)

E)

Options

AOption A

BOption B

COption C

DOption D

EOption E

Question No: 48

MultipleChoice

Examine these statements which execute successfully:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYY HH24 :MT:SS;'

ALTER SESSION SET TIME-ZONE = '-5:00;:

Examine the result:

If LOCALTIMESTAMP was selected at the same time, what would it return?

Options

A11-JUL-2019 6.00.00.00000000 AM

B11-JUL-2019 11.00.00.00000000 AM

C11-JUL_2019 6.00.00.00000000 AM -05:00

D11-JUL_2019 11.00.00.00000000 AM -05:00

Question No: 49

MultipleChoice

Examine this query and its output:

Examine this query with an incomplete was WHERE clause:

Which two are true about operators that can be used In the WHERE clause?

Options

AUsing not in or <> any will give the same result.

BUsing in will display all the product names,

CUsing not in or <> all will give the same result.

DUsing <> any will display all the product names except the product named Fork.

EUsing <> any will display all the product names.

Question No: 50

MultipleChoice

Examine this query:

SELECT 2

FROM DUAL D1

CROSS JOIN DUA d2

CROSSS JOIN DUAL D3

WHERE 2 =3;

What is the result?

Options

ANo rows

BAn error

C3 rows

D8 row

E1 row

F6 rows