Topic : User Management

What is a user process trace file?


Answer :

- It is an optional file which is produced by user session.
- It is generated only if the value of SQL_TRACE parameter is set to true for a session.
- SQL_TRACE parameter can be set at database; instance; or session level.
- If it set at insta

Show Answer Discuss

Give the two types of tables involved in producing a star schema and the type of data they hold.


Answer :

Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Show Answer Discuss

When a user process fails; what background process cleans up after it?


Answer :

PMON

Show Answer Discuss

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


Answer :

Grant the CONNECT to the user.

Show Answer Discuss

How would you determine who has added a row to a table?


Answer :

Turn on fine grain auditing for the table.

Show Answer Discuss