Oracle DBA Interview Questions for Experienced Professionals - 3

Question: 11

What is freelist?

Freelist is a bitmap kind of structure in the header of every segment in which every bit maps to a block in the segment.

This list can be used to determine which blocks are available to insert new rows.

Question: 12

Can you change SHARED_POOL_SIZE online?

Yes, you can change SHARED_POOL_SIZE online by using the following statement:

SQL> alter system set SHARED_POOL_SIZE = 200M scope =spfile and restart.

Question: 13

How can you rename a redo log file?

Perform the following steps to rename a redo log file

Shutdown the database

Copy the reo log file to new location with the operating system command

Startup the database in the smount mode

Open the database

Make a backup copy of the control file

Use the Alter database rename file<old file> to <new file>; statement.

Question: 14

How do you add a datafile to a tablespace?

You can add a datafile to a tablespace by using the ALTER TABLESPACE ADD DATAFILE SIZE; statement.

Question: 15

What view would you use to look at the size of a database?

The DBA_DATA_FILES view can be used to look at the size of a datafile.