Online Access Free 1z0-071 Practice Test

Examine the BRICKS table:

You write this query:
SELECT
FROM bricks b1 CROSS JOIN bricks b2
WHERE b1. Weight < b2. Weight:
How many rows will the query return?

• A.1
• B.4
• C.6
• D.16
• E.10
• F.0

Examine the description of the CUSTOMERS table:
Which three statements will do an implicit conversion?

• A.SELECT * FROM customers WHERE customer_id=0001;
• B.SELECT * FROM customers WHERE customer_id='0001';
• C.SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';
• D.SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';
• E.SELECT * FROM customers WHERE insert_date'01-JAN-19';
• F.SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';

Which statement fails to execute successfully?

• A.
• B.
• C.
• D.

Which three statements are true about multiple row subqueries?

• A.They cannot contain subquery.
• B.They can contain GROUP BY clauses.
• C.They can return multiple columns.
• D.They can contain HAVING clauses.
• E.Two or more values are always returned from the subquery.

Which three statements are true about sequences in a single instance Oracle database?

• A.A sequence's unallocated cached values are lost if the instance shuts down.
• B.A sequence can only be dropped by a DBA.
• C.A sequence number that was allocated can be rolled back if a transaction fails.
• D.Two or more tables cannot have keys generated from the same sequence.
• E.Sequences can always have gaps.
• F.A sequence can issue duplicate values.