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

Database Management Interview Questions

Questions Answers Views Company eMail

Explain the key constraints and constraints on Null Values with examples?

2 4457

What are ACID properties?

Amazon, Cap Gemini,

11 28425

Write about Transaction Management in Oracle 9i?

2126

I want to export the data date to date from oracle database then what can i do?

2606

HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.

1 3089

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 4029

What are the partitions types available in Oracle10g. How it will do? Simple example?

Tech Mahindra,

1 10429

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1899

Where the data file for system Tablespace is located? What is its name, initial size and maxsize?

1 3473

Hi, i m studying in FYBCOM,i wanted to make a career in database,but i dont know anything about database. so i want to know which database is useful and the authorised institute io database in mumbai with website and email for my better carrier. thanks,

1 3294

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

4179

how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?

Satyam,

1 4275

Explain how RDBMS software deals with deadlocks.

1 4585

i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

NIC,

1881

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).

Satyam,

5 8468

Post New Database Management Questions

Un-Answered Questions { Database Management }

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1905

What are procedures in database?

1063

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

1936

What is big data in database?

889

how to restore particular schema from rman full backup?

1758

How do you create a database?

921

What is database management system(dbms) and why it is used?

1017

Explain the difference between two and three-tier architectures.

941

What is the type of image in database?

867

What is the role of database server in database management system?

880

Define identity and uniqueidentifier property of column?

1068

Is this statement true or false? All databases must be in third normal form?

993

What is a checkpoint in dbms?

1124

How to prevent firebird.log file from filling up the disk partition?

929

What do you understand by data independence? What are its two types?

1058

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