1
								2			3			4
								5											6
					7												8
								9					10			11
			12
										13					14
														15
															16
	17	18
19						20

Across 2. This tool enable you to create a database from oracle supplied template or create your own database and template. 4. The default size when creating a tablespace is _______________. 5. _____________ architecture in oracle consist of client, _______________ server, and database server. 9. __________ INDEX supplier_idx ON supplier (supplier_name);.Complete the statement to create an index. 11. In background process _______________ writes the contents of buffers to datafile. 12. __________ INDEX index_name will delete an index. 13. A segment that requires an extent larger than available extent,combines contigous reclaimed extents to form a larger one. The segment refers to a segment allocated by data _______________ . 15. Physical structure in Oracle Database Architecture includes _____________ file, control file and online redo log file. 16. In background process_______________ performs recovery, if necessary, at instance startup. 17. Prerequisite steps to create __________ in Oracle database are using SYSDBA/SYSOPER privilege, specify spfile-name after instance startup, and change parameter using ALTER system. 19. In Oracle , _______________ consist of shared pool, large pool, database buffer cache and Java pool. 20. A ________ log is made up of redo entries (also called redo records), which record all changes made to data.

Down 1. In background process_______________ is responsible for redo log buffer management which writing the redo log buffer to a redo log file on disk. 3. The total memory size set by the user to be used in instance. The database exchnge between SGA and PGA to meet demands. The statement refers to _____________ memory management. 6. In background process_______________ performs recovery when a user process fails. 7. The smallest unit in oracle logical structure is Data _____________. 8. _______________ guides you through an Oracle database upgrade and configures the database for the new release. 10. The hierarchy of logical storage structure in Oracle is arranged as Data Block->___________ ->Segment->Tablespace. 14. ___________ in data block is referred collectively to data block header, table directory and row directory. 18. A memory buffer that contains data and control information for a server process is refers to ___________________________ .