Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-071

Oracle 1Z0-071 Exam (page: 12)
Oracle Database SQL
Updated on: 01-Sep-2025

Viewing Page 12 of 77
1Z0-071 PDF 380 Questions

Which two statements are true about sequences created in a single instance Oracle database? (Choose two.)

  1. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
  2. DELETE <sequencename> would remove a sequence from the database.
  3. The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
  4. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
  5. When a database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.

Answer(s): A,D


Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_2012.htm#SQLRF00817 https://docs.oracle.com/cd/A84870_01/doc/server.816/a76989/ch26.htm



View the exhibit and examine the structure of the CUSTOMERS table.


Which two tasks would require subqueries or joins to be executed in a single statement?

  1. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
  2. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
  3. listing of customers who do not have a credit limit and were born before 1980
  4. finding the number of customers, in each city, whose marital status is 'married'
  5. listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.

Answer(s): A,E



Which statement is true about transactions?

  1. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.
  2. Each Data Definition Language (DDL) statement executed forms a single transaction.
  3. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.
  4. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.

Answer(s): B


Reference:

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038



View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables.


You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.

Which CREATE VIEW statement would create the view successfully?

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Answer(s): C



Which statement is true about an inner join specified in the WHERE clause of a query?

  1. It must have primary-key and foreign-key constraints defined on the columns used in the join condition.
  2. It requires the column names to be the same in all tables used for the join conditions.
  3. It is applicable for equijoin and nonequijoin conditions.
  4. It is applicable for only equijoin conditions.

Answer(s): C



Viewing Page 12 of 77



Share your comments for Oracle 1Z0-071 exam with other users:

Saravana Kumar TS 12/8/2023 9:49:00 AM

question: 93 which statement is true regarding the result? sales contain 6 columns and values contain 7 columns so c is not right answer.
INDIA