Questions of Test: Oracle DBA Test

More >>

1

How does one prevent tablespace fragmentation?

2

How does one coalesce free space?

3

Where can one find the high water mark for a table?

4

How are extents allocated to a segment? 

5

Can one rename a database user (schema)?

6

How does one see the uptime for a database? 

7

Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? 

8

How do I find used/free space in a TEMPORARY tablespace?

9

How can one see who is using a temporary segment?

10

 How does one get the view definition of fixed views/tables? 

More >>