Database Security Interview Questions
- What are Roles?
- What is Auditing?
- What is Object Auditing?
- What is Privilege Auditing?
- What is default table space?
- What is Table space Quota?
- What is Statement Auditing?
- What is the function of Roles?
- What is a trace file and how is it created?
- What do you mean by Database Security?
- What is user Account in Oracle database?
- What is the use of ANALYZE command?
- How can you enable automatic archiving?
- What is user Account in Oracle database?
- What are the different Levels of Auditing?
- What is the function of Analyze command?
- What do you understand by data validation?
- What do you understand by object auditing?
- What do you know about table space Quota?
- What are roles? How can we implement roles?
- What are Table space Quota and default table space?
- Which of the stored procedures are used for security?
- How will you enforce security using stored procedures?
- How can we know whether a database is secured or not?
- What are the database administrator?s utilities available?
- Explain the parameters required in parameter file init.ora?
- What are the responsibilities of a Database Administrator?
- Explain the various system resources controlled by profile?
- What responsibilities does the Database Administrator have?
- What is Auditing? What are the different Levels of Auditing?
- What are the steps to creating a password authentication file?
- Which dictionary tables are there to monitor a database space?
- What are the dictionary tables used to monitor a database spaces?
- Explain the method of data security in LAN or Local Area Network?
- What are the system resources that can be controlled through Profile?
- How can we specify the Archived log file name format and destination?
- ?What are the roles and user accounts created automatically with the database?
- What are the minimum parameters should exist in the parameter file (init.ora)?
- Which roles and user accounts are built automatically along with the database?