GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle security Interview Questions


Oracle security Interview Questions

Questions: 30
Comments: 24
 Showing Questions 11-20 of 30 Questions
<< Previous 1 [2] 3 Next >>
 Sponsored Links

 
 Oracle security Interview Questions
Sorting Options :  

 DBA_FREE_SPACEDBA_SEGMENTSDBA_DATA_FILES. 

 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 
Latest Answer: adding to the list* involved in database design * applying patch sets * writing scripts to automate the routine DBA tasks* configuring oracle net such as listeners and tnsnames* data loading and unloading using exp/imp and sqlloader* providing help to ...

 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 
Latest Answer: &DBSNMPSupports Oracle SNMP (Simple Network Management Protocol). The Oracle Intelligent Agent requires a database logon for each SID that it manages. By default this account is called "DBSNMP" CheersRavi Prakashhttp://ravidba-oracle.blogspot.com/ ...

 SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL  *  Loader  -  It loads data from standard operating system files (Flat files) into ORACLE database 
Latest Answer: SQL Plus, SQL Loader, EXP, IMP ...

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 

 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  

 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 

      Shut the database     Backup the database     Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.     Start 
Latest Answer: 1. it possible to enable archive log mode while creating the database using DBCA.2. By mentioning the required parameters like LOG_ARCHIVE_DEST, LOG_ARCHIVE_FORMAT, LOG_ARCHIVE_START in init.ora file before creating the database manually using script.3. ...

 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  

 REDUCED  GRANTING  OF PRIVILEGES - Rather than explicitly granting the same set  of  privileges  to  many users a database administrator  can grant the privileges  

View page << Previous 1 [2] 3 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape