1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
DB Administration Interview Questions
Questions Answers Views Company eMail

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

 1515

If CPU is very slow What can u do to speed up?

 1 3165

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

 1 3343

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

 1224

How many memory layers are in the shared pool?

 3 6360

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

IBM,

2 10127

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

 2023

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

 3298

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

 1963

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

 1547

How do you tell what your machine name is and what is its IP address?

 4 5722

How would you go about verifying the network name that the local_listener is currently using?

 2748

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

 3929

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

 2091

What is the recommended interval at which to run statspack snapshots, and why?

 1 2557

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

505

What is dcl? : sql server DBA

636

How to start SQL Server in minimal configuration mode?

6931

What is transparent data encryption? : sql server DBA

556

what do you understand by flashback feature of oracle?

547




How do you trace the traffic hitting a sql server? : sql server DBA

830

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1857

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1501

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1535

what is the use of recording information about current session?

553

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1970

what are the benefits of flashback feature?

581

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

580

how can you find out if a table can be redefined?

589

How would you best determine why your MVIEW couldn't FAST REFRESH?

1818

For More Un-Answered { DB Administration } Questions Click Here