QUESTION: 275

Which two statements are true about a self-join?

It can be a left outer join.
It must be a full outer join.
It can be an inner join.
It must be an equijoin.
The join key column must have an index.

Answer(s): C,E

Reference:

https://www.oracletutorial.com/oracle-basics/oracle-self-join/

Show Answer Next Question

QUESTION: 274

Examine the description of the BOOKS_TRANSACTIONS table:

Examine this partial SQL statement:

SELECT * FROM books_transactions

Which two WHERE conditions give the same result?

WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ OR member_id IN (‘A101’, ‘A102’));
WHERE (borrowed_date = SYSDATE AND transaction_type = ‘RM’) OR member_id IN (‘A101’, ‘A102’);
WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ AND (member_id = A101’ OR member_id = ‘A102’));
WHERE borrowed_date = SYSDATE AND transaction_type = ‘RM’ OR member_id IN (‘A101’, ‘A102’);
WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ AND member_id = ‘A101’ OR member_id = ‘A102’);

Answer(s): B,C

Show Answer Next Question

The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER (8, 2).

Evaluate this SQL statement:

SELECT TO_CHAR(unit_price, ‘$9,999’) FROM product_information;

Which two statements are true about the output?

A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.
A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.
A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######.
A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.
A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.

Answer(s): C,E

Show Answer Next Question

QUESTION: 238

Which three statements are true about GLOBAL TEMPORARY TABLES?

A GLOBAL TEMPORARY TABLE can have multiple indexes.
A GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.
A trigger can be created on a GLOBAL TEMPORARY TABLE.
A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
A GLOBAL TEMPORARY TABLE can have only one index.
Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

Answer(s): C,D,F

Reference:

https://books.google.com.pk/books?id=oP88fSdbQJIC&pg=PA11&lpg=PA11&dq=oracle+database+GLOBAL+TEMPORARY+TABLES+Data+Manipulation+Language+(DML)+on+GLOBAL+TEMPORARY+TABLES+generates+no+REDO&source=bl&ots=F7EL8Y0ST9&sig=ACfU3U1KuLlqyyJFxqAG1LRT4OxprsVZdg&hl=en&sa=X&ved=2ahUKEwi0xdPU94vlAhWp34UKHUYpBtAQ6AEwAHoECAkQAQ#v=onepage&q=oracle%20database%20GLOBAL%20TEMPORARY%20TABLES%20Data%20Manipulation%20Language%20(DML)%20on%20GLOBAL%20TEMPORARY%20TABLES%20generates%20no%20REDO&f=false

Show Answer Next Question

QUESTION: 272

Examine this query:

SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3;

What is returned upon execution?

8 rows
1 row
6 rows
3 rows
0 rows
an error

Answer(s): B

Show Answer Next Question

Free Oracle 1Z0-071 Exam Questions (page: 8)

QUESTION: 275

Reference:

QUESTION: 274

QUESTION: 273

QUESTION: 238

Reference:

QUESTION: 272

1Z0-071 Exam Discussions & Posts