Oracle DBA Interview Question and Answers

17. What does coalescing a tablespace do?
 
  • Coalescing is used to combine fragmented space into larger extents.
  • It is valid for dictionary managed tablespace and defragments space by coming neighboring free extends into larger single extents.
 
Your Name Your Email-ID
Your Answer
18. Can you pivot the results of a query?
  You can use hierarchical query with the sys_connect_by_path function in Oracle 9i and above to pivot the result.
 
Your Name Your Email-ID
Your Answer
19. How would you determine the time zone under which a database was operating?
  You can determine the time zone under which a database was operating by using the select DBTIMEZONE from dual; statement.
 
Your Name Your Email-ID
Your Answer
20. Can you import objects from Oracle version 7.3 to 9i?
  Yes, you can use the exp or imp utilities to import the objects from Oracle version 7.3 to 9i.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 5 of 10