- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Database Security Interview Questions & Answers - Learning Mode

Database Security Interview Questions & Answers - Learning Mode

Securing a database allows organizations to protect the corporate data from threats from external sources. Database security is a serious issue, and if not implemented correctly, the consequences can.

Try Database Security Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Database Security Interview Questions & Answers - Learning Mode
Try Database Security Interview Questions & Answers - Exam Mode
Question: What is Privilege Auditing ?

Answer: Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects. Source:
Question: What are the minimum parameters should exist in the parameter file (init.ora) ?

Answer: DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control file while database creation. DB_DOMAIN - It is string that specifies the network domain where the database is created. The global database name is identified by setting these parameters
(DB_NAME & DB_DOMAIN) CONTORL FILES - List of control filenames of the database. If name is not mentioned then default name will be used. DB_BLOCK_BUFFERS - Source:
Question: What are the dictionary tables used to monitor a database spaces ?

Question: What is Statement Auditing ?

Answer: Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects. Source:
Question: What are the steps to creating a password authentication file?

Answer: The steps are :

* Then dbs$orapwd file=orapw$ORACLE_SID password=sys force=y
* Then startup force;
* Then grant sysdba to user(any user in the database);
* Then conn user/user
* Then conn user/user as sysdba
* Then show user Source:
Question: What are Roles ?

Answer: Roles are named groups of related privileges that are granted to users or other roles. Source:
Question: How can we specify the Archived log file name format and destination?

Answer: By setting the following values in init.ora file.
LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S - Log sequence number and is zero left paded, %s - Log sequence number not padded. %T - Thread number lef-zero-paded and %t - Thread number not padded). The file name created is arch 0001 are if %S is used. LOG_ARCHIVE_DEST = path. Source:
Question: What is a profile ?

Answer: Each database user is assigned a Profile that specifies limitations on various system resources available to the user. Source:
Question: What are the responsibilities of a Database Administrator ?

Answer: Installing and upgrading the Oracle Server and application tools.
Allocating system storage and planning future storage requirements for the database system. Managing primary database structures (tablespaces) Managing primary objects (table,views,indexes)
Enrolling users and maintaining system security. Ensuring compliance with Oralce license agreement Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database. Planning for backup and Source:
Question: How can you enable automatic archiving ?

Answer: Shut the database
Backup the database
Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.
Start up the database. Source:
Question: Explain Statement Auditing, Privilege Auditing, And Object Auditing.

Answer: There are three levels of auditing:

Statement level: Statements found in stmt_audit_option_map are audited.

Object level: objects like tables, views, sequences, packages, stored procedures, stored functions are sudited.

Privilege level: All system privileges that are found in system_privilege_map are audited. Source:
Question: What is a trace file and how is it created?

Answer: The files that are created when an oracle background process encounters an exception are Trace files.

Processes like dbwr, lgwr, pmon, smon create them.

Trace files are also created by ORA-00600 error or due to some diagnostic dump events. Source:
Question: What are the roles and user accounts created automatically with the database?

Answer: DBA - role Contains all database system privileges.
SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary are store in this schema and are manipulated only by ORACLE.
SYSTEM user account - It has all the system privileges for the database and additional tables and views that display administrative information and internal tables and views used by oracle tools are created using this username. Source:
Question: What are the system resources that can be controlled through Profile ?

Answer: 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. Source:
Question: if we have database,then how can we tell the data in the "database is secured" . 2)what is ment by "data validation"?

Answer: If we want to say that our Database is secured then we must confirm first that our Data is validate.There are various methods of validating the Data:1. Accept only known valid Data.2. Reject known Bad Data.3. Sanitize Bad data. We cannot emphasize strongly enough that "Accept Only Known Valid Data" is the best strategy. We do, however, recognize that this isn't always feasible for political, financial or technical reasons, and so we describe the other strategies as well.All three methods mus Source:
Question: What are Tablespace Quota and default tablespace?

Answer: A tablespace is a logical storage unit within an Oracle database because it is not visible in the file system of the machine, the database resides on.

The Tablespace quotas are used to assign users with limited size on tablespaces.

Default tablespaces are used for users who are not configured with default tablespaces. Source:
Question: What is user Account in Oracle database?

Answer: A user account is a schema which is used to store database objects, applications, and components, and to determine a user's database privileges. Source:
Question: What is user Account in Oracle database?

Answer: An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. Source:
Question: Explain the security features in Oracle.

Answer: Data abstraction has been achieved in Oracle by separating the client and the server side logic. Therefore the client applications cannot manipulate the data. The triggers perform content based auditing and selectively disable application updates.

Access control can be achieved in Oracle by allowing the users to manipulate the data by using only their definer?s permitted previledges. Source:
Question: What is Tablespace Quota ?

Answer: The collective amount of disk space available to the objects in a schema on a particular tablespace. Source:

1 2 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.015625 Seconds