Oracle 1Z0-051 Certification Sample Questions and Answers

1Z0-051 PDF, 1Z0-051 Dumps PDF Free Download, 1Z0-051 Dumps Free, 1Z0-051 Latest Dumps PDF, 1Z0-051 PDF Free DownloadThe Oracle 1Z0-051 Sample Question Set is designed to help you prepare for the Oracle Database 11g - SQL Fundamentals I (1Z0-051) certification exam. To become familiar with actual Oracle Certification exam environment, we suggest you to try Sample Oracle 1Z0-051 Certification Practice Exam.

This sample Oracle 1Z0-051 certification practice exam is designed for evaluation purposes only. If you really want to test your knowledge to identify your weak areas and familiarize with actual exam format, we suggest you to practice with Premium Oracle 1Z0-051 Certification Practice Exam for Oracle Database 11g - SQL Fundamentals I (1Z0-051) certification. Our team of Oracle Database experts have designed Questions-Answers for this premium practice exam by collecting inputs from recently certified candidates. Hence, We strongly recommend you to use Premium Oracle 1Z0-051 Certification Practice Exam to clear your actual Oracle 1Z0-051 Certification Exam with great score.

1Z0-051 Sample Questions:

01. Which of the following commands can be rolled back?
 
a) COMMIT
b) DELETE
c) INSERT
d) MERGE
e) TRUNCATE
f) UPDATE
 
02. Which of the following statements are syntactically correct? (Choose all that apply.)
 
a) SELECT JH.JOB_ID FROM JOB_HISTORY JH RIGHT OUTER JOIN JOBS J ON JH.JOB_ID=J.JOB_ID
b) SELECT JOB_ID FROM JOB_HISTORY JH RIGHT OUTER JOIN JOBS J ON (JH.JOB_ID=J.JOB_ID)
c) SELECT JOB_HISTORY.JOB_ID FROM JOB_HISTORY OUTER JOIN JOBS ON JOB_HISTORY.JOB_ID=JOBS.JOB_ID
d) None of the above
 
03. Which of these operators will remove duplicate rows from the final result? (Choose all that apply.)
 
a) INTERSECT
b) MINUS
c) UNION
d) UNION ALL
 
04. Which query creates a projection of the DEPARTMENT_NAME and LOCATION_ID columns from the DEPARTMENTS table? (Choose the best answer.)
 
a) SELECT DISTINCT DEPARTMENT_NAME, LOCATION_ID FROM DEPARTMENTS;
b) SELECT DEPARTMENT_NAME, LOCATION_ID FROM DEPARTMENTS;
c) SELECT DEPT_NAME, LOC_ID FROM DEPT;
d) SELECT DEPARTMENT_NAME AS “LOCATION_ID” FROM DEPARTMENTS;
 
05. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
 
a) SELECT TO_CHAR(1890.55,'$0G000D00')
FROM DUAL;
b) SELECT TO_CHAR(1890.55,'$9,999V99')
FROM DUAL;
c) SELECT TO_CHAR(1890.55,'$99,999D99')
FROM DUAL;
d) SELECT TO_CHAR(1890.55,'$99G999D00')
FROM DUAL;
e) SELECT TO_CHAR(1890.55,'$99G999D99') FROM DUAL;
 
06. You issue the following query:
 
SQL> SELECT AVG(MAX(qty))
FROM ord_items
GROUP BY item_no
HAVING AVG(MAX(qty))>50;
 
Which statement is true regarding the outcome of this query?
 
a) It executes successfully and gives the correct output.
b) It gives an error because the HAVING clause is not valid.
c) It executes successfully but does not give the correct output.
d) It gives an error because the GROUP BY expression is not valid.
 
07. You want to display the date for the first Monday of the next month and issue the following command:
 
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'), 'dd "is the first Monday for"fmmonth rrrr') FROM DUAL;
 
What is the outcome?
 
a) It executes successfully and returns the correct result.
b) It executes successfully but does not return the correct result.
c) It generates an error because TO_CHAR should be replaced with TO_DATE.
d) It generates an error because rrrr should be replaced by rr in the format string.
e) It generates an error because fm and double quotation marks should not be used in the format string.
 
08. You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'. Which WHERE clause could be used in the SELECT statement to get the required output?
 
a) WHERE prod_id LIKE '%_D123%' ESCAPE '_'
b) WHERE prod_id LIKE '%\_D123%' ESCAPE '\'
c) WHERE prod_id LIKE '%_D123%' ESCAPE '%_'
d) WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'
 
09. Which line of this statement will cause it to fail?
 
1. select ename, hired from current_staff
2. order by ename
3. minus
4. select ename, hired from current staff
5. where deptno=10
6. order by ename;
 
(Choose the best answer.)
 
a) select ename, hired from current_staff
b) order by ename
c) minus
d) select ename, hired from current staff
e) where deptno=10
f) order by ename;
 
10. Which of these is a defining characteristic of a complex view, rather than a simple view? (Choose one or more correct answers.)
 
a) select ename, hired from current_staff
b) order by ename
c) minus
d) select ename, hired from current staff
e) where deptno=10
f) order by ename;

Solutions:

QUESTION: 01

Answer: b, c, d, f

QUESTION: 02

Answer: a

QUESTION: 03

Answer: a, b, c

QUESTION: 04

Answer: b

QUESTION: 05

Answer: a, d, e

QUESTION: 06

Answer: b

QUESTION: 07

Answer: a

QUESTION: 08

Answer: b

QUESTION: 09

Answer: b

QUESTION: 10

Answer: b

 

Rating: 4.6 / 5 (20 votes)