Database Management Interview Preparation Guide
Optimize your Database Management interview preparation with our curated set of 15 questions. Each question is designed to test and expand your Database Management expertise. Suitable for all experience levels, these questions will help you prepare thoroughly. Download the free PDF to have all 15 questions at your fingertips. This resource is designed to boost your confidence and ensure youre interview-ready.15 Database Management Questions and Answers:
1 :: What is datapump?
1. you can deattach or reattch datapump job.
2. you can parallelise datapump job [PARALLEL=4]
3. without export can do import using NETWORK_LINK parameter
4. can calculate export dump file size using ESIMATE_ONLY
5. expdp utility used which is caled by dbms_datapump procudure
6. remapping capabilities during import
[REMAP_DATAFILE,EMAP_SCHEMA,REMAP_TABLESPACE,REUSE_DATAFILES]
2. you can parallelise datapump job [PARALLEL=4]
3. without export can do import using NETWORK_LINK parameter
4. can calculate export dump file size using ESIMATE_ONLY
5. expdp utility used which is caled by dbms_datapump procudure
6. remapping capabilities during import
[REMAP_DATAFILE,EMAP_SCHEMA,REMAP_TABLESPACE,REUSE_DATAFILES]
2 :: How to displaying the eno, ename in a table from row
2 to row 5?
select *
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5
------------------
we can also use row_number function
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5
------------------
we can also use row_number function
3 :: Which acid property will effect when we use commit in trigger?
it shows run time error.....
choosing pragma autonomous_transaction to overcome this problem
choosing pragma autonomous_transaction to overcome this problem
4 :: What is candidate key and primary key, explain different between these two?
candidate key: when we reduce unnecessary columns from a
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
5 :: Can we update table which is created from view?
yes we can update view
6 :: How to access the default tables of 9i?
first connect to sysdba user then write
sql>grant resource to scott;
sql>grant resource to scott;
7 :: What is sufficient to normalize a database up to 3NF?
dependent on application. Most transactional based
databases require this to avoid duplication etc. However,
OLAP, these type of databases (typically those used in data
warehouses etc.) are not necesarrily normalised as they are
built for performance of querying the data contained within.
databases require this to avoid duplication etc. However,
OLAP, these type of databases (typically those used in data
warehouses etc.) are not necesarrily normalised as they are
built for performance of querying the data contained within.
8 :: What is the difference between oracle CPU and PSU?
Patch Set Updates (PSUs) are proactive cumulative patches containing recommended bug fixes that are released on a regular and predictable schedule. PSUs are on the same quarterly schedule as the Critical Patch Updates (CPU), specifically the Tuesday closest to the 17th of January, April, July, and October.
9 :: What is the difference between delete and truncate?
Truncate is a DDL command, which has autocommit hence
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
10 :: What is ORACLE CLINICAL?
Oracle Clinical or O*C is a database management system
designed by Oracle to provide data management, data entry
and data validation functionalities to Clinical Trials
process.
designed by Oracle to provide data management, data entry
and data validation functionalities to Clinical Trials
process.