- What are the benefits of distributed options in databases
- When will the data in the snapshot log be used
- What is snapshot log
- What are the options available to refresh snapshots
- How can you Enforce Referential Integrity in snapshots
- What dynamic data replication
- Differentiate simple and complex, snapshots
- What is the various types of snapshots
- What are snapshots
- How can we reduce the network traffic
- What is the use of ANALYZE command
- How can we specify the Archived log file name format and destination
- How can you enable automatic archiving
- What are switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG
- What are roles? How can we implement roles
- What is a trace file and how is it created
- What are the minimum parameters should exist in the parameter file
- What are the database administrator?s utilities available
- What are the roles and user accounts created automatically with the database
- What are the responsibilities of a Database Administrator
- What is the dictionary tables used to monitor a database spaces
- How will you enforce security using stored procedures
- What is user Account in Oracle database
- What is a profile
- What is Table space Quota
- What is default table space
- How to prevent unauthorized use of privileges granted to a Role
- What are the different Levels of Auditing
- What is Auditing
- What are the system resources that can be controlled through Profile
- What is Privilege Auditing
- What is Object Auditing
- What is the use of Roles
- What is Statement Auditing