Oracle security Interview Questions

What are the responsibilities of a database administrator ?

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

What  are  the  minimum  parameters should exist in the parameter file (init.Ora) ?

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

What are 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...

What are the different levels of auditing ?

Statement auditing, privilege auditing and object auditing.

What is user account in Oracle database?

 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.

How will you enforce security using stored procedures?

 don't grant user access directly to tables within the application. instead grant the ability to access the procedures that access the tables. when procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

What are the dictionary tables used to monitor a database spaces ?

 dba_free_spacedba_segmentsdba_data_files.

What is a trace file and how is it created ?

 each server and background process can write an associated trace file. When an   internal  error  is  detected  by  a  process or user process, it dumps information  about  the error to its trace. This can be used for tuning the database.

What are roles? How can we implement roles ?

 roles  are  the easiest way to grant and manage common privileges needed by different groups of database users. creating roles and assigning provides to roles. assign each role to group of users. This will simplify the job of assigning privileges to individual users.

How can we specify the archived log file name format and destination?

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

What is the use of  analyze command  ?

 to perform one of these function on an index,table, or cluster:      -  to collect statistics about object used by the optimizer and store them in the data dictionary.     -  to delete statistics about the object used by object from the data dictionary.     - to validate the structure of the object.    ...

How do you set password for listener.Ora ?

Read Best Answer

Editorial / Best Answer

Answered by: prakashpichika

View all questions by prakashpichika   View all answers by prakashpichika

Member Since Jun-2006 | Answered On : Oct 3rd, 2006

oracle@localhost> lsnrctl

LSNRCTL> set current_listener LISTENER

Current Listener is LISTENER

LSNRCTL> set save_config_on_stop on

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

LISTENER parameter "save_config_on_stop" set to ON

The command completed successfully

LSNRCTL> change_password

Old password:

New password:

Reenter new password:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

Password changed for LISTENER

The command completed successfully

LSNRCTL> set password

Password:

The command completed successfully

LSNRCTL> stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

The command completed successfully

LSNRCTL> exit

Cheers

Answered by: Mohammed Abdul Afroze on: Oct 4th, 2007

To set the password for the listener.ora are as follows;

lsnrctl>lsnrctl password

Answered by: prakashpichika on: Oct 3rd, 2006

oracle@localhost> lsnrctlLSNRCTL> set current_listener LISTENERCurrent Listener is LISTENERLSNRCTL> set save_config_on_stop onConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))LISTENER ...

Improve Answer