Welcome to www.programmer2programmer.net tips for IT Interview Questions of Oracle Database Security


programmer2programmer.net

 Tips
 Microsoft Certification
 Final Year Project Idea
 Connection Strings
 Password Recovery
 SQL Injection
 Encryption & Decryption
  
 LIVE Academic Project
 Project #1 - VB6, Access
  Project #2 - VB.Net, SQL
 Project #3 - ASP, Access
 Project #4 - ASP.NET, C#
 Project #5 - VB6, SQL
 Project #6 - Stegano
 Project #7 - C
 Project #8 - C++
 Project #9 - JAVA, MySQL
 Project #10- PHP, MySQL
 Project #11- JSP, Oracle
 Project #12- C# Face Exp
 Project #13- Mobile Bank
 Download MBA Project
 MBA Project Topic
 Project Viva Question
  2017 New Projects
 Project Synopsis Download
  
 University Question Paper, Assignment and Projects
 SMU - Question Paper
 SMU - Assignment
 SMU - Synopsis Projects
 SCDL - Assignment
 IGNOU - Synopsis Projects
 Welingkar - Projects
 Project Report Formats
  
 Interview Question Answer
 General & HR Round
 Visual Basic 6
 VB.Net & C#
 ASP.Net
 SQL Server
  Oracle and DBA
 My SQL
  

100% Tested
Ready Academic IT Projects

BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU
readymadeproject.com

 Interview questions and Answers for Oracle Database Security

Home Personal Member Forum Source Project Tips Contact

Interview Question > Oracle
 Oracle Database Security Interview Questions and Answers

Interview questions and answers for Oracle Database Security Interview Questions and Answers

Oracle Database Security Interview Questions and Answers includes, use of Roles, default tablespace, Tablespace Quota, profile, Auditing, different Levels of Auditing, Statement Auditing, Privilege Auditing, Object Auditing, prevent unauthorized use of privileges, APPLICATION AWARENESS, SELECTIVE AVAILABILITY OF PRIVILEGES, DYNAMIC PRIVILEGE MANAGEMENT, REDUCED GRANTING OF PRIVILEGES.

Interview Question, Answer
1.  Programming General
2.  Web General
3.  Database General
4.  Visual Basic 6
5.  ASP
6.  Visual Basic .NET and C#
7.  ASP .NET
8.  ORACLE
9.  MS SqlServer
10. MySql
11. COM, DCOM
1. What are Roles?
Roles are named groups of related privileges that are granted to users or other roles.
 
2. What is the use of Roles?
REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to each member of the group.

DYNAMIC PRIVILEGE MANAGEMENT - When the privileges of a group must change, only the privileges of the role need to be modified. The security domains of all users granted the group's role automatically reflect the changes made to the role.

SELECTIVE AVAILABILITY OF PRIVILEGES - The roles granted to a user can be selectively enable (available for use) or disabled (not available for use). This allows specific control of a user's privileges in any given situation.

APPLICATION AWARENESS - A database application can be designed to automatically enable and disable selective roles when a user attempts to use the application.
 
3. How to prevent unauthorized use of privileges granted to a Role?
By creating a Role with a password.
 
4. What is default tablespace ?
The Tablespace to contain schema objects created without specifying a tablespace name.
 
5. What is Tablespace Quota?
The collective amount of disk space available to the objects in a schema on a particular tablespace.
 
6. What is a profile?
Each database user is assigned a Profile that specifies limitations on various system resources available to the user.
 
7. What are the system resources that can be controlled through Profile ?
The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the amount of logical I/O available to the user's session the amout of logical I/O available to a single call to ORACLE made by a SQL statement the allowed amount of idle time for the user's session the allowed amount of connect time for the user's session.
 
8. What is Auditing?
Monitoring of user access to aid in the investigation of database use.
 
9. What are the different Levels of Auditing?
Statement Auditing, Privilege Auditing and Object Auditing.
 
10. What is Statement Auditing?
  Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.
 
11. What is Privilege Auditing?
  Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
 
12. What is Object Auditing?
Object auditing is the auditing of accesses to specific schema objects without regard to user.
 

Next  Oracle Database Operation Backup and Recovery Interview Questions and Answers           Go back to Interview Question Main

(C) Atanu Maity, 2006-2007