CoolInterview.com - 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
COOLINTERVIEW.COM ORACLE INTERVIEW QUESTIONS DATABASE SECURITY INTERVIEW QUESTIONS 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 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: CoolInterview.com
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: CoolInterview.com
Question: What are the dictionary tables used to monitor a database spaces ?

Answer: DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES. Source: CoolInterview.com
Question: What is Statement Auditing ?

Answer: Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects. Source: CoolInterview.com
Question: What are Roles ?

Answer: Roles are named groups of related privileges that are granted to users or other roles. Source: CoolInterview.com
Question: What are the steps to creating a password authentication file?

Answer: The steps are :

* First set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file
* 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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: How we can secure our data in local area Network

Answer: No answer available currently.
Question: What are the use of Roles ?

Answer: 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 th Source: CoolInterview.com

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.03125 Seconds