Oracle dba Interview Questions at Infotech Enterprises(Cyient)

Interview Questions :

use of temporary tbs
.................................................................................................................................
alert log file location
......................................................................................................................................
any 3 background process
...............................................................................................................................
exp and datapump diff
..........................................................................................................................
how to tranfer data from one user to other user using exp and datapump
.........................................................................................................................
profiles
................................................................................................................................
how u schedule backups
............................................................................................................................
how to restart listener ?
.......................................................................................................................
how u find which instance is running or not ?
...................................................................................................................
daily activites
...............................................................................................................
cold backup in which mode ?
hot backup in which mode ?
.,..................................................................................................................
diff btn delete and truncate
...................................................................................................................
triggers
......................................................................
primary , unique and foreign key diff
............................................................................................
convert to dos prompt from sql promt
......................................................................................................................
constraints

Read More

Oracle dba Interview Questions at Yodlee Infotech

Explain Oracle 11g Architecture

Oracle Background Process

What happens when you put the database in begin backup mode ?

What is sequence

How many constraints are there ?

Which type of index you used ?

Which backup strategy you are using ?

What is Rman Incremental strategy ?

Explain Dataguard

How can u run datapump job faster ?

How will u  transfer objects using expdp from one user to other user ?

Recently did u face any issue ?

Any thing proud to say about you ?

What are the datapump parameters you used ?

Can you stop and start a datapump job ?

Can u export 11g database schema and import into 10g database ?

Do You RAC ?

What is TAF in RAC ?

Read More

Oracle dba Interview at Mphasis Company

Attended F2F Interview at Mphasis Company

as Payroll Company Sharp Gaze Tech Services Pvt Ltd www.sharpgts.com 

1. Draw and Explain Oracle 11g Architecture

Datapump Questions

2.  How will expdp the Scott's table emp ?

3. How will transfer objects using expdp from one user to other user ?

4.what is use of consistent=y parameter in export ?

5. What is RMAN ? 

Linux Questions

6. How will u display the amount of available disk space for filesystems

7. How will u check linux version in os level

8. What is Java Pool and Large Pool

9. How many max execution plans it will store in Library Cache

Read More

Oracle dba Interview at HP Company

Attended F2F Interview at Client  Hp Company

By Payroll Company www.netconnectglobal.com

2+ experience

1ow many databases you are managing

2.how many servers you managing

3.Size of your database

4.On which project you are working ?

5.Explain Oracle Architecture

6.What SMON and PMON do ?

7.What is the use of  Checkpoint ?

8.What does Control File Contains ?

9.How select Statement works

10.How Update Statement works

11.which process writes from datafiles to dbbc ?

12.which writer writes from dbbc to datafiles ?

13.11g new features

14.use of logswitch and scn

15.what u do if u lost all control files 

16.Suddenly one of datafile db01.dbf became unnamed00001.dbf then what u do ?

17.Additional Parameters for standby database ?

18.What are Modes in Dataguard and Explain it 

19.How will you recover if u lost user datafile ?

20.Use of Undo Tablespace

21.Difference Between Normal Export and Datapump Export ?

22.How do u stop and start a Datapump Job ?


Please send Documents to kumarbobby143@gmail.com if you attended any Interview

So,I can upload it in this blog , it will be useful to us and others

Thank Yoy

Read More

Oracle dba Interview at Sharp Gaze Tech Company

Attended Telephonic Interview at Sharp Gaze Tech Services Pvt Ltd

3+ experience

1.what is meant by sga

2.what are logical files

3.diff b/w rman in 10g and 11g

4.How can make import faster ?

5.how to apply missing archive logs to standby db

6.How to check block corruption logically

7.check i/o files in os level

8.archive logs missing at 8am and how to take complete backup at 9pm

9.diff b/w locks and latches

10.patching in rac

11.scan in rac

12.11g new features

Please send Documents to kumarbobby143@gmail.com if you attended any Interview

So,I can upload it in this blog , it will be useful to us and others

Thank Yoy

Join facebook

Read More

Oracle Dba Interview at Yash Technologies

1.My database was terminated while in BACKUP MODE, do I need to recover?

If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the database. The DBA is then required to recover the database and apply all archived logs to the database. However, from Oracle 7.2, one can simply take the individual datafiles out of backup mode and restart the database.

ALTER DATABASE DATAFILE '/path/filename' END BACKUP;

One can select from V$BACKUP to see which datafiles are in backup mode. This normally saves a significant amount of database down time. See script end_backup2.sql in the Scripts section of this site.
From Oracle9i onwards, the following command can be used to take all of the datafiles out of hotbackup mode:

ALTER DATABASE END BACKUP;
This command must be issued when the database is mounted, but not yet opened.

2.ORA-00257:

archiver error. Connect internal only, until freed.
Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.
Action: Check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.

3.Can we perform DML operation on Materialized view?

A.Yes
B.No

Answer: b

4.What are the dictionary tables used to monitor a database spaces ?

DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES.

5.Distributed database
.......................................................................................................................
6.rollback segment
.................................................................................................................................
7.hit ratio.
..................................................................................................
8.deadlocks
..............................................................................................................
9.when system tablespace created
,.................................................................................................................
10.coalesce tablespace space what does?
..............................................................................................................................
11.solve SNAPSHOP TOO OLD ?
.....................................................................................................................
12.Which of the following statements about listeners is correct?

A. A listener can connect you to one instance only.
B. A listener can connect you to one service only.
C. Multiple listeners can share one network interface card.
D. An instance will only accept connections from the listener specified on the local_listener parameter.

Answer: c
................................................................................................................................
13.create backup control file ?
..................................................................................................................
14.How does a DBA specify multiple control files?

A. With the ADD CONTROLFILE command.
B. By using the files in the STARTUP command.
C. With the MULTIPLEX control file command.
D. By listing the files in the CONTROL_FILES parameter.

Answer: d
..............................................................................................................
15.Which task can a DBA perform using the export/import facility?

A.Examine log files.
B.Recreate the control file.
C.Transport tablespaces between databases.
D.Make a logical backup of the rollback segment tablespace.

Answer: c
.....................................................................................................................................
16.You are using hot backup without being in archivelog mode, can you recover in the event of a failure?

A. Yes
B. No

Answer: b and how ?
/............................................................................................................................
17.When performing an open database backup, which statement is NOT true?

A. The database is fully accessible to all users.
B. The database must be operating in ARCHIVELOG mode.
C. The database can be open but only in READ ONLY mode.
D. The database tablespaces should be in BEGIN BACKUP mode.

Answer: c
........................................................................................................................
18.What command would you use to create a backup control file?

Answer: Alter database backup control file to trace.
...........................................................................................................................
19.What are the steps involved in Database Startup?

Answer: Start an instance, Mount the Database and Open the Database.
..............................................................................................................
 20.What are the steps involved in Database Shutdown?

Answer: Close the Database, Dismount the Database and Shutdown the Instance.
...........................................................................................................................
21.What is Archived Redo Log?

Answer: Archived Redo Log consists of Redo Log files that have archived before being
reused.
............................................................................................................................
22.Explain the difference between a data block, an extent and a segment.

Answer: A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database
object.
............................................................................................................................
23.Partition-Level Export


Please send Documents to kumarbobby143@gmail.com if you attended any Interview

So,I can upload it in this blog , it will be useful to us and others

Thank Yoy

Read More