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

Oracle 1Z0-071 Exam (page: 6)
Oracle Database SQL
Updated on: 28-Nov-2025

Viewing Page 6 of 49
1Z0-071 PDF 380 Questions

Examine the structure of the INVOICE table.


Which two SQL statements would execute successfully?

  1. SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')
    FROM invoice;
  2. SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available')
    FROM invoice;
  3. SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate)
    FROM invoice;
  4. SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available')
    FROM invoice;

Answer(s): A,C



Which three statements are true about the ALTER TABLE....DROP COLUMN.... command?

  1. A column can be dropped only if it does not contain any data.
  2. A column can be dropped only if another column exists in the table.
  3. A dropped column can be rolled back.
  4. The column in a composite PRIMARY KEY with the CASCADE option can be dropped.
  5. A parent key column in the table cannot be dropped.

Answer(s): B,D,E



View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

  1. SELECT COUNT (DISTINCT list_price)
    FROM product_information
    WHERE list_price is NULL
  2. SELECT COUNT (NVL(list_price, 0))
    FROM product_information
    WHERE list_price is NULL
  3. SELECT COUNT (list_price)
    FROM product_information
    WHERE list_price i= NULL
  4. SELECT COUNT (list_price)
    FROM product_information
    WHERE list_price is NULL

Answer(s): B



Which three tasks can be performed using SQL functions built into Oracle Database?

  1. displaying a date in a nondefault format
  2. finding the number of characters in an expression
  3. substituting a character string in a text expression with a specified string
  4. combining more than two columns or expressions into a single column in the output

Answer(s): A,B,C



The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:

GRANT ALL
ON orders, order_items
TO PUBLIC;

What must be done to fix the statement?

  1. PUBLIC should be replaced with specific usernames.
  2. ALL should be replaced with a list of specific privileges.
  3. WITH GRANT OPTION should be added to the statement.
  4. Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.

Answer(s): D


Reference:

http://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljgrant.html



You are designing the structure of a table in which two columns have the specifications:

COMPONENT_ID – must be able to contain a maximum of 12 alphanumeric characters and must uniquely identify the row

EXECUTION_DATETIME – contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components.
Which two options define the data types that satisfy these requirements most efficiently? (Choose two.)

  1. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.
  2. The EXECUTION_DATETIME must be of TIMESTAMP data type.
  3. The EXECUTION_DATETIME must be of DATE data type.
  4. The COMPONENT_ID must be of ROWID data type.
  5. The COMPONENT_ID must be of VARCHAR2 data type.
  6. The COMPONENT_ID column must be of CHAR data type.

Answer(s): C,F



You want to display the date for the first Monday of the next month and issue the following command:


What is the outcome?

  1. In generates an error because rrrr should be replaced by rr in the format string.
  2. It executes successfully but does not return the correct result.
  3. It executes successfully and returns the correct result.
  4. In generates an error because TO_CHAR should be replaced with TO_DATE.
  5. In generates an error because fm and double quotation marks should not be used in the format string.

Answer(s): C



Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)

  1. You can use column alias in the GROUP BY clause.
  2. Using the WHERE clause after the GROUP BY clause excludes the rows after creating groups.
  3. The GROUP BY clause is mandatory if you are using an aggregate function in the SELECT clause.
  4. Using the WHERE clause before the GROUP BY clause excludes the rows before creating groups.
  5. If the SELECT clause has an aggregate function, then those individual columns without an aggregate function in the SELECT clause should be included in the GROUP BY cause.

Answer(s): D,E



Viewing Page 6 of 49



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