Database Management Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Management Interview Questions

Questions Answers Views Company eMail

What are the different file extensions that are created by Oracle ?

2 14310

Is it possible to Disable the Parameter form while running the report ?

1 6707

What are the SQL clauses supported in the link property sheet ?

1 3626

What are the types of Calculated columns available ?

1 3778

What are the different Sequence of events takes place while starting a Database ?

KPSC Karnataka Public Service Corporation,

1 5591

When the SYSTEM TABLESPACE can be made off-line ?

2 5586

From which command ENQUEUE_RESOURCES parameter information is derived from ?

1 5071

How the SMON process is used to write into LOG files ?

HCL,

2 8131

what is the use of EXP command ?

2 8903

Can the SNAPSHOTS be refreshed automatically ?

1 4114

Can the User set Archive file name formats ?

1 6066

Which parameters are optional in init.ora parameter file?

2211

What is the use of NOARCHIEVELOG parameter in Database?

1 5454

Are Constraints exported through Export command?

1 4766

How the status of the Rollback segment can be viewed ?

1 4706

Post New Database Management Questions

Un-Answered Questions { Database Management }

What is 2nf in the dbms?

964

Define view, sequence and index in DBMS.

934

What do you mean by entity type extension?

1057

Explain the architecture of reporting services?

985

What is a Federated Query ?

1002

Is database a data structure?

870

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1847

Mention how deadlock can be resolved?

963

What are the lock types?

952

What are the various Database states.

968

Define denormalization.

1173

Define database lock?

915

What are the two main functions of queries in databases?

1441

What is the advantage of database management system?

915

What are the steps to follow when preparing to create a table?

890

For More Un-Answered { Database Management } Questions Click Here