Interview question based on skill :
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?
Correct Answer is : TRUNCATE
2. Which character function can be used to return a specified portion of a character string?
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?
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?
Correct Answer is : Default tablespace for the user
5. Which character is used to continue a statement in SQL*Plus?
Correct Answer is : -
