1.
How will you enable the MIS_MANAGER role in Oracle?
2.
In Oracle, where is the free space primarily managed for a tablespace created with an automatic segment-space management?
3.
Your database contains a locally managed uniform sized table space with automatic segment space management, which contains only tables. Currently, the uniform size for the table space is 512 K. Because the tables have become so large, your configuration must change to improve performance. Now the tables must reside in a table space that is locally managed, with uniform size of 5 MB and automatic segment-space management. What must you do to meet the new requirements?
4.
Which of the following segments is used to improve query performance in Oracle?
5.
In Oracle, the temporary tablespaces should be locally managed and uniform size should be a multiple of the ________________________.
6.
Which one of the following is not a physical structure that constitutes the Oracle database?
7.
In Oracle, which of the following files restores the RESTORE command in RMAN?
8.
In Oracle, which of the following is the restriction on the block media recovery using RMAN?
9.
In Oracle, which of the following dynamic data dictionary views will you query to find out the names of the data files associated with a tablespace to take its online backup?
10.
Which of the following files need to be backed up to take cold backup of a database: a) Data files b) Log files c) Control files d) Archived redo log file