Set - 9

Question 16 :

Give two methods you could use to determine what DDL changes have been made.

Answer :

You could use Logminer or Streams


Question 17 :

What does coalescing a tablespace do?

Answer :

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.


Question 18 :

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

Answer :

A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.


Question 19 :

Name a tablespace automatically created when you create a database.

Answer :

The SYSTEM tablespace.


Question 20 :

When creating a user, what permissions must you grant to allow them to connect to the database?

Answer :

Grant the CONNECT to the user.