Topic : User Management

How can you enable a trace for a session?


Answer :

Use the DBMS_SESSION.SET_SQL_TRACE or Use ALTER SESSION SET SQL_TRACE = TRUE;

Show Answer Discuss

Name two files used for network connection to a database.


Answer :

TNSNAMES.ORA and SQLNET.ORA

Show Answer Discuss

What are the types of database users?


Answer :

Oracle is a multi user database management system and has predominantly two types of users :
DBA (Database Administrator)
Normal User

Show Answer Discuss

Define Schema?


Answer :

A schema is a collection of objects associated with the database.

Show Answer Discuss

What is schema objects?


Answer :

Schema objects are abstractions or logical structures that refer to database objects or structures.
Schema objects consist of such things as clusters; indexes; packages; sequences; stored procedures; synonyms; tables; views; and so on.

Show Answer Discuss