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. Where does the data in a temporary table get written to disk?
(Choose the best answer.)
a) It is never written to disk
b) To the user’s temporary tablespace
c) To the temporary tablespace of the user in whose schema the table resides
d) To a disk local to the session’s user process
 
02. How can you change the primary key value of a row?
(Choose the best answer.)
a) You cannot change the primary key value.
b) Change it with a simple UPDATE statement.
c) The row must be removed with a DELETE and reentered with an INSERT.
d) This is only possible if the row is first locked with a SELECT FOR UPDATE.
 
03. 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;
 
04. 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
 
05. You issue the following SQL command: 
SQL> CREATE TABLE emp
(empno NUMBER PRIMARY KEY,
ename VARCHAR2(25)  NOT NULL,
dob   TIMESTAMP DEFAULT SYSDATE,
hire_date  DATE CONSTRAINT h_dt_chk CHECK (hire_date <= SYSDATE)); 
What would be the outcome?
a) It executes successfully and creates the table
b) It generates an error because SYSDATE cannot be used with the CHECK constraint
c) It generates an error because column size has not been specified for the EMPNO column
d) It generates an error because the default value SYSDATE cannot be used with the TIMESTAMP data type
 
06. Which two statements are true regarding the USING clause in table joins?
(Choose two.)
a) It can be used to join a maximum of three tables.
b) It can be used to restrict the number of columns used in a NATURAL join.
c) It can be used to access data from tables through equijoins as well as nonequijoins.
d) It can be used to join tables that have columns with the same name and compatible data types.
 
07. Evaluate the following SQL statement:
SQL>SELECTTO_CHAR(1230,'00,999.99') FROM DUAL; 
What would be the outcome?
a) 1,230
b) 01,230
c) 1,230.00
d) 01,230.00
 
08. Which two statements are true regarding a transaction?
(Choose two)
a) If a data manipulation statement fails in the middle of a transaction, only that statement is rolled back
b) If a data manipulation statement fails in the middle of a transaction, the entire transaction is rolled back
c) A transaction is committed when a user exits the session normally without issuing an explicit COMMIT command
d) A transaction is rolled back when a user exits the session normally without issuing an explicit COMMIT command
 
09. Which statement is true regarding single-row functions?
a) They cannot be nested
b) They can accept only one argument
c) They act on each row returned and return only one result per row
d) They act on each row returned and can return multiple results per row
 
10. 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 '\_'

Solutions:

QUESTION: 01

Answer: b

QUESTION: 02

Answer: b

QUESTION: 03

Answer: a, d, e

QUESTION: 04

Answer: a

QUESTION: 05

Answer: b

QUESTION: 06

Answer: b, d

QUESTION: 07

Answer: d

QUESTION: 08

Answer: a

QUESTION: 09

Answer: c

QUESTION: 10

Answer: b

Rating: 4.8 / 5 (40 votes)