a2zinterviews

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.
	Discuss 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.
	Discuss 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.
	Discuss 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.
	Discuss Your Name Your Email-ID Your Answer