Mar
24
2014

What kind of activities can be parallelized?

dba-interview-1

Which are activities performed parallel operation? Ans: There are lots of operations executing with parallel option. Tablespace creation, Index creation and rebuilds, data loading, statistics gathering, backups and restoring process can be parallelized in Oracle. Even though online index rebuilding can be done parallel and partition table maintenance operations are done using parallel option. Remember: This is not tricky question but it should be addressed properly.

Jan
18
2014

How to compare schema from different databases?

fresher-interview-questions

I have 2 databases and there a SCOTT schema exists in both databases. I want to compare schema from both Oracle databases, could you advise me how to achieve this goal? Ans: For comparing schema from both databases, first you need to create database link to one of database. After that you can execute query against DBA_OBJECT using where condition of OWNER=’SCOTT’ and use minus select query from another database using database link. An example, […]

Dec
9
2013

Oracle DBA Interview Question – ORA-27102 Out of Memory Error

dba-interview-1

While I am trying to bring up my Oracle database that time I got “Out of Memory” ORA-27102? Or What is the solution to eliminate ORA-27102 out of memory error during database startup? Ans: Generally ORA-27102 out of memory error thrown with cause of improper shared memory setting. Kindly check SGA size with operating system kernel parameter SHMMAX. You should need to either decrease SGA size or increase SHMMAX kernel parameter of Unix or Linux […]

Aug
12
2013

Tricky Interview Question – About Constraint Disable

sql-interview

Could we insert duplicate value in unique or primary constraint of table? Ans: No. We cannot be able to insert duplicate value in unique or primary constraint data of table. But if we disable constraint then we can be able to insert duplicate value.    Remember:   This is tricky interview question because we cannot insert duplicate value in unique or primary key but when we disable constraint then it can done. If constraint contain […]

Aug
9
2013

Oracle DBA Interview Question – Real time scenario based

fresher-interview-questions

I have a table with 9 rows only in my production Oracle 10g database. But when I checked size of table, then I found 12 GB. How is it possible? Ans: It could be possible when you inserted so many rows in table and later on deleted those rows. High water mark didn’t reset. If you are inserting using APPEND hint every time then also it can be possible. Deleting rows would be checked using […]

Mar
19
2013

DBA interview Questions about View

dba-interview-1

What is View? Does view occupy space in database? Ans: This is very simple questions but actually it is tricky because generally people are forgetting about materialized view during interview question replying and actually question is asked for all kind of views. View is logical structure. Only definition of view is stored in metadata of database. Due to this reason, view doesn’t occupy space in database. But materialized view occupies space in database because materialized […]

Aug
6
2012

Dba Interview Questions of Parameter files

dba interview questions, oracle dba interview questions

Where I can find out init.ora of my Oracle database? Or What is the default location of parameters files of Oracle like init.ora or spfile.ora? Ans: In Windows server, we can find out parameter files in %ORACLE_HOME%\database folder and on Unix or Linux server we can find out in $ORACLE_HOME/dbs folder. Remember, default locations of parameter files like init.ora and spfile. Offcourse, these are default location of files means there is possibility to database server […]

Jul
27
2012

SQL Interview Question-2

sql-interview

Which factors are to be considered for creating index on table? How to target column for indexing? Ans: There are lots circumstances causing to create index on table like size of table and volume of data. If size of table is large and we need only few data for selecting or in report then we need to create index.  There are some basic reason of selecting column for indexing like cardinality and frequent usage in […]

Jul
26
2012

DBA Interview Question about re-organize schema

dba-interview-questions-1

How to re-organize schema which has more than 300 objects? Ans: Simple technique is export/import or datapump for re-organization of schema. We can take logical backup of schema using export or datapump. After taking export, recreate schema with same privileges and roles. After recreating schema, we can import data from export or datapump utility. Remember, re-organization of schema using export/import or datapump is very simple and easy method but for using this technique, you need […]

Jul
24
2012

Oracle DBA Interview Question-4

fresher-oracle-dba

How to re-organize schema which has more than 300 objects? Ans: Simple technique is export/import or datapump. We can take logical backup of schema using export or datapump. After taking export, recreate schema with same privileges and roles. After recreating schema, we can import data from export or datapump utility. Remember, re-organization of schema using export/import or datapump is very simple and easy method but for using this technique, you need to recreate schema. This […]

Pages:12»

Best Resources

DBA Interview Questions

DBA Interviews

Confusion During Interviews Tricky - Real Time Scenario questioned Get Success in Interview and Grab Job EASILY Get Success in Interview and Grab Job EASILY

TAG Cloud