Good DBA Questions

1. Explain by one sentences, role, references, privilege on a table and profile?

2. What can trigger a snapshot to old error?

3. What are the DB files, how oracle discover them?

4. Where do you look for the trace file?

5. The following question about implementation. The answer is not a number but the way you do it.

You have got a raw partition. The size is 800M

dd if=/dev/rdsk/c.t.d.s. of=/dev/null bs=1024
819200 block.

You create one file table space what is it's maximum size available for the rollback and what is the maximum size for rollback? Explain how the extents for rollback segments are allocated?

9. How to backup a database and made a recovery of a table?

10. How do you chose your db_block_size ?

11. A database has been created with the default parameters how do you increase the DB_BLOCK_SIZE and the DB_FILE?

12. How can you move the tablespace ROLLBACK from one disk to an other, given this information?

select segment_name , tablespace_name , status , owner from
dba_rollback_segs ;

SYSTEM SYSTEM ONLINE SYS
RBS1 ROLLBACK ONLINE PUBLIC
RBS2 ROLLBACK ONLINE PUBLIC

select tablespace_name , file_name from dba_data_files where
tablespace_name = 'ROLLBACK' ;

ROLLBACK /dev/rdsk/c0t0d0s0

New location is /dev/rdsk/c1t1d0s0

13. Estimate the size of the table? The answer is not a number but a list of steps you will use to derive this number.

create table emp ( emp_id number not null ,
name varchar2(50) not null ,
surname varchar2(50) not null,
social_number varchar2(10) ) ;

emp will contains 1000 static rows.


14. Same question but the table already exists and has one extents of 1Gbytes ?

15. How to shutdown a database in Oracle version 8i and 9i?