DB Administration Interview Questions
Questions Answers Views Company eMail

what is incremental checkpoint?

CTS,

1 8632

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 6896

what are the differences of where and if in SAS?

1919

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 12349

what is ora 600?

1 4246

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

4088

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

3 6338

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.

2337

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

2136

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

2433

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

2001

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 3845

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

Satyam,

2 5086

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,

1939

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,

1864


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2245


how can you implement fine-grained auditing?

860


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2072


What happens on checkpoint? : sql server DBA

821


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

1809


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1739


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

3006


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

856


what is the diffrence between core dba and apps dba?

2342


What is the default fill factor value? : sql server DBA

862


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

805


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1769


what is a crs resource?

895


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

2340


what is the role of dip user in our database?

2253