Exercise Chapter 3 DFP4053 : MANAGING TABLES, INDEXES AND CONSTRAINTS

This is to test understanding about MANAGING TABLES, INDEXES AND CONSTRAINTS

1	2

3		4
			5

6				7	8


		9

Across

1. This is an auxiliary tablespace to the SYSTEM tablespace.

5. A __________ log is made up of redo entries, which are also called redo records.

6. A _________________ file tracks the physical components of the database. It is the root file that the database uses to find all the other files used by the database.

9. This tablespace contains the sample schemas that are included with Oracle Database.

Down

2. A ____________contains a specific type of database object.

3. A data _________________ is the smallest unit of I/O to database storage.

4. _____________writes redo records from the memory buffer to a redo log group until the log files in that group reach their storage size limit, or until you request a log switch operation.

5. ____________ segments were database structures used to track undo information for the database in earlier releases of Oracle Database.

7. This tablespace stores temporary data generated when processing SQL statements.

8. An ____________is a contiguous set of data blocks within a segment.

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!