Oracle 1Z0-047 PDF Download: Most Reliable Latest Oracle 1Z0-047 Questions To Guarantee 100% Pass
1Z0-047 Questions & Answers Oracle Database SQL Expert https://www.leads4pass.com/1z0-047.html dumps Guaranteed to pass the exam
QUESTION 1
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command? (Choose three.)
A. ‘os’
B. local
C. -8:00′
D. dbtimezone Li
E. ‘Australia’
Correct Answer: BCD
QUESTION 2
EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?
A. UPDATE empdet SET ename = ‘Amit’ WHERE empno = 1234;
B. DELETE FROM empdet WHERE ename LIKE ‘J%’;
C. CREATE VIEW empvu ASSELECT* FROM empdept;
D. CREATE INDEX empdet_dx ON empdet(empno);
Correct Answer: C
QUESTION 3
Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.)
A. it can be used to concatenate two strings.