Database Management Interview Questions
Questions Answers Views Company eMail

What are the steps involved in Database Startup ?

2 2358

What are the steps involved in Database Shutdown ?

1 2741

What is Restricted Mode of Instance Startup ?

1 2080

What are the different modes of mounting a Database with the Parallel Server ?

1 4045

What is Full Backup ?

3 2600

Can Full Backup be performed when the database is open ?

1 2324

What is Partial Backup ?

2 4310

What is On-line Redo Log?

2 2168

What is Mirrored on-line Redo Log ?

2 1852

What is Archived Redo Log ?

3 1985

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

2 4171

What is Log Switch ?

2 3171

What are the steps involved in Instance Recovery ?

ibcs primax,

1 4002

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

Indian Web Technology,


What are the different methods of backing up oracle database ?

1 1778

Post New Database Management Questions

Un-Answered Questions { Database Management }

how to solve cardinality in dbms...many to many ralationships


What are the package used in DBMS ?


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?


i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........


Suppose database is running slow, what will you do?


1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????


Explain the classification of Database Management System?


explain about the critical recovery scenario you had experienced


Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.


All questions related to Control m monitoring tool


what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?


Can anybody give me link for BOXI R3.1 Key please


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping


for what purpose we use MDM(master data management)tell me plz.


i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.