DB Administration Interview Questions
Questions Answers Views Company eMail

what is incremental checkpoint?

CTS,

1 8575

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

CTS,

2 6842

what are the differences of where and if in SAS?

1906

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 12321

what is ora 600?

1 4218

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4067

How to make a replica of existing oracle server to another server?

3 6275

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2319

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

2113

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2419

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1974

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 3811

How can we know the exact updation date of a particular database?

Satyam,

2 5028

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

Oracle,

1919

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

EDS,

1850


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2430


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

841


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

1717


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

796


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

919


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

756


what is the use of recording information about current session?

801


What are the steps you will take to improve performance of a poor performing query?

2640


how can you schedule a job in database?

828


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

833


what is grd?

853


What is dcl? : sql server DBA

906


How would you extract DDL of a table without using a GUI tool?

2248


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

2113


What purpose does the model database server? : sql server DBA

844