Oracle Certification Program Interview Questions

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

The correct answer is select * from EMP where nvl(EMPNO, '00000') = '59384';

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

The correct answer is Default tablespace for the user

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

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?

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

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

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

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

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit