1Z0-071 Exam Questions and Answers | Exam-Dumps.net (Page: 9)

QUESTION: 41

Examine the structure of the INVOICE table.

Which two SQL statements would execute successfully?

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

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 42

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

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

Answer(s): B,D,E

Reveal Solution Next Question

QUESTION: 43

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?

SELECT COUNT (DISTINCT list_price)
FROM product_information
WHERE list_price is NULL
SELECT COUNT (NVL(list_price, 0))
FROM product_information
WHERE list_price is NULL
SELECT COUNT (list_price)
FROM product_information
WHERE list_price i= NULL
SELECT COUNT (list_price)
FROM product_information
WHERE list_price is NULL

Answer(s): B

Reveal Solution Next Question

QUESTION: 44

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

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

Answer(s): A,B,C

Reveal Solution Next Question

QUESTION: 45

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?

PUBLIC should be replaced with specific usernames.
ALL should be replaced with a list of specific privileges.
WITH GRANT OPTION should be added to the statement.
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

Reveal Solution Next Question

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

QUESTION: 41

QUESTION: 42

QUESTION: 43

QUESTION: 44

QUESTION: 45

Reference:

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