Oracle Certification Program Interview Questions

Oracle Certification Program interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which command will delete all data from a table and will not write to the rollback segment?

A. DROP

B. DELETE

C. CASCADE

D. TRUNCATE

Correct Answer is : TRUNCATE

2. Which character function can be used to return a specified portion of a character string?

A. INSTR

B. SUBSTRING

C. SUBSTR

D. POS

Correct Answer is : SUBSTR

3. The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

A. select * from EMP where nvl(EMPNO, '00000') = '59384';

B. select * from EMP where EMPNO = '59384';

C. select EMPNO, LASTNAME from EMP where EMPNO = '59384';

D. select 1 from EMP where EMPNO = '59834';

Correct Answer is : select * from EMP where nvl(EMPNO, '00000') = '59384';

4. When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

A. System tablespace

B. Users tablespace

C. Default tablespace for the user

D. Default tablespace for the user

Correct Answer is : Default tablespace for the user

5. Which character is used to continue a statement in SQL*Plus?

A. *

B. /

C. -

D. #ERROR!

Correct Answer is : -

Oracle Certification Program interview questions