live chatMcAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Pass4Test 10%OFF Discount Code

Oracle Database SQL - 1z1-071 Exam Questions

QUESTION NO: 1
Which two statements are true? (Choose two.)
Correct Answer: C,D
QUESTION NO: 2
You own table DEPARTMENTS, referenced by views, indexes, and synonyms.
Examine this command which executes successfully:
DROP TABLE departments PURGE;
Which three statements are true? (Choose three.)
Correct Answer: B,E,F
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 3
Which two statements execute successfully? (Choose two.)
Correct Answer: A,D
QUESTION NO: 4
Which three statements are true regarding the data types?
Correct Answer: B,C,E
QUESTION NO: 5
You need to list the employees in DEPARTMENT_ID20 days in a single row, ordered by HIRE_DATE.
Examine the sample output:

Which query will provide the required output?
Correct Answer: C
QUESTION NO: 6
Which two statements are true about dropping views? (Choose two.)
Correct Answer: B,E
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 7
View the Exhibit and examine the description of the ORDERS table.

Which two WHERE clause conditions demonstrate the correct usage of conversion functions?
(Choose two.)
Correct Answer: C,D
QUESTION NO: 8
Examine the description of the EMPLOYEEStable:

Examine this query:

Which line produces an error?
Correct Answer: C
QUESTION NO: 9
Which statement is true about the INTERSECT operator used in compound queries?
Correct Answer: B
QUESTION NO: 10
Which statements are correct regarding indexes? (Choose all that apply.)
Correct Answer: A,B,C
QUESTION NO: 11
Which three are true about scalar subquery expressions? (Choose three.)
Correct Answer: C,D,E
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 12
In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained a query? (Choose two.)
Correct Answer: A,C
QUESTION NO: 13
View the exhibit and examine the structure of the PROMOTIONS table.

You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?
Correct Answer: D