Friday , June 23 2017
Home / Oracle DBA Interview Questions

Oracle DBA Interview Questions

ORACLE DATABASE SQL STATEMENT EXECUTION

Oracle DBA Interview Questions with answers.

Tasks of a Database Administrator

The following tasks present a prioritized approach for designing, implementing, andmaintaining an Oracle Database:

Task 1: Evaluate the Database Server Hardware

Task 2: Install the Oracle Database Software

Task 3: Plan the Database

Task 4: Create and Open the Database

Task 5: Back Up the Database

Task 6: Enroll System Users

Task 7: Implement the Database Design

Task 8: Back Up the Fully Functional Database

Task 9: Tune Database Performance

Task 10: Download and Install Patches

Task 11: Roll Out to Additional Hosts

ORACLE MISCELLANEOUS INTERVIEW QUESTIONS

MISCELLANEOUS What are your daily activities? Checking the alertlog file, backup status, performing any refreshes, resolving tickets and handling application team requests etc What is your typical day? Or What is the biggest problem you faced till now? Explain any one problem you faced during practise or any error you …

Read More »

ORACLE DATABASE RMAN INTERVIEW QUESTIONS

RMAN INTERVIEW QUESTIONS What are the advantages of RMAN? Validation of the backup Parallelism Block level backup Incremental backup Recovery catalog etc Explain how RMAN performs the backup? When RMAN is initiated, it will start reading datafile headers for used block information. It will get that from bitmap blocks With …

Read More »

ORACLE NETWORKING INTERVIEW QUESTIONS

NETWORKING INTERVIEW QUESTIONS What is the importance of SQLNET.ORA file? It helps in choosing the type of connection to be established from client to server What is the difference between TNSNAMES.ORA and SQLNET.ORA file? Tnsnames.ora will specify the entries on to which database to connect where as sqlnet.ora will tell …

Read More »

USER MANAGEMENT INTERVIEW QUESTIONS

USER MANAGEMENT INTERVIEW QUESTIONS What is the difference between a user and schema? A user will not have any of his own objects and will always access others objects. Schema is a collection of objects After creating user, what are the privileges you would assign? We will give CONNECT role …

Read More »

ORACLE TABLESPACE INTERVIEW QUESTIONS

TABLESPACE MANAGEMENT What is the difference between dictionary managed tablespace and locally managed tablespace? In dictionary managed tablespace, free block information is maintained in data dictionary cache there by increases IO. In locally managed tablespace, the same information is maintained in datafile header itself there by reducing the IO. Hence …

Read More »