Database Management Interview Questions
Questions Answers Views Company eMail

What are the steps involved in Database Startup ?

247Customer,

2 3205

What are the steps involved in Database Shutdown ?

1 3216

What is Restricted Mode of Instance Startup ?

1 2601




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

1 4678

What is Full Backup ?

3 3078

Can Full Backup be performed when the database is open ?

1 2716

What is Partial Backup ?

2 4838

What is On-line Redo Log?

2 2725




What is Mirrored on-line Redo Log ?

2 2322

What is Archived Redo Log ?

3 2426

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

2 4755

What is Log Switch ?

2 3846

What are the steps involved in Instance Recovery ?

ibcs primax,

1 4774

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

Indian Web Technology,

959

What are the different methods of backing up oracle database ?

1 2171


Post New Database Management Questions






Un-Answered Questions { Database Management }

what is the age limit for groups1 examination

1054


Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

874


There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

1031


I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

1468


Explain the classification of Database Management System?

3052






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? 1. What are environment variable, job parameters? 2. What is the relationship between the tables in oracle? 3. How can u create the sequence? 4. What are the client components? 5. Tell me about the Data stage administrator? 6. Tell me about the Data stage Manager? 7. What is joining? 8. What is difference between grep command and fgrep command? 9. What is run time column propagation? 10. How to open the file? 11. How do you cleanse the data in your project? 1. Using which stage raw binary converted into dataset? 2. Which stage is used to read the data into external application? 3. Can we convert dataset into raw binary 4. XML path? 5. When we use the hash partition in aggregator stage? 6. How many reject links in transformer stage? 7. Data stage debugger available in which jobs? 8. Tell me two parts of data set? 9. What is the function used for null handling in modify stage? 10. Default execution mode for exception handler? 11. Maximum exception handler allowed in sequence?

2353


I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

1157


Explain the Normalized Relations?

1634


what do u mean by canvases and alerts?

958


Suppose database is running slow, what will you do?

1337


IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

1147


hello to all i want code for like this site "Submit Question" page.please give answers thanks.

812


Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

1774


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

684


What do you mean by Checkbox ?

1334