FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

ORACLE DBA INTERVIEW QUESTIONS & ANSWERS

Follow Us
 
1. What are the role of DBA?
  DBA has the authority to create new users, remove existing users or modify any of the environment variables or privileges assigned to other users.
  • Manage database storage
  • Administer users and security
  • Manage schema objects
  • Monitor and manage database performance
  • Perform backup and recovery
  • Schedule and automate jobs
  Posted by Shahabuddin. (Jun 07, 2014)
 

DBA have authority to monitor all the users....and create and remove the users...

  Posted by Santosh. (Dec 26, 2013)
 

DBA has all authority e.g create user, remove user, create tablespace, modify, performanc, privilegs, backup and recovery.

  Posted by Rashmi. (Jun 12, 2013)
 

DBA have access to the database objects but not on the database.so, DBA can manage the database objects. Perform backup recovery.

Your Name Your Email-ID
Your Answer
 
2. What are different Oracle database objects?
 
  • TABLES
  • VIEWS
  • INDEXES
  • SYNONYMS
  • SEQUENCES
  • TABLESPACES
Your Name Your Email-ID
Your Answer
 
3. What are the benefits of ORDBMS?
  The objects as such can be stored in the database. The language of the DBMS can be integrated with an object- oriented programming language. The language may even be exactly the same as that used in the application, which does not force the programmer to have two representations of his objects.
Your Name Your Email-ID
Your Answer
 
4. What is control files?
  Control files contain a list of all the database files and the Redo log files and the current log sequence number.
  Posted by Arun Prasad. (Sep 30, 2014)
 

1.Control Files has Name & location of database files & Redo log file.
2. Current log sequence number.
3. DB creation time and checkpoint

  Posted by Narendra. (Jun 07, 2014)
 

Control files contain begin and end backup information - also contain checkpoint information and current sequence number.

  Posted by Krishnareddy. (Mar 03, 2014)
 

Control file is a small binary file, we should not edit, oracle scans the content of controlfile in the mount state for physical location of datafile and redologfile and log sequence number.

  Posted by Humaish Zaman Yusufi. (Jan 22, 2014)
 

Control file is meta data of the database.

  Posted by William. (Dec 06, 2013)
 

Control files contain the physical of the database.It contains the database name, creation time, location of data files and log files etc.

  Posted by Sanju. (Nov 26, 2013)
 

Control file is very crucial file of oracle database, which content location of redo log files and database files.

  Posted by Dattu. (Nov 20, 2013)
 

Control files are very important to start the database, without control we can’t start the database.

  Posted by Dinesh Sati. (Oct 05, 2013)
 

Control file is the heart of oracle database. Which is contain location of data file redo log file and also time-stamp creation of database.

  Posted by Rashmi. (Jun 12, 2013)
 

Control file contain Information about complete structure of your database. Location of the datafiles and redo files. timestamp of database creation. ect.

Your Name Your Email-ID
Your Answer
 
 
5. What is an Oracle index?
  An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
Your Name Your Email-ID
Your Answer