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

Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

wat is mean by normalization?......programing defination i need...(i know basic defination)

Wipro,

4 8922

definition of cluster and non-clustered index?

CSS,

1 3125

how to get the index id?

Cognizant, TCS,

1 5728

What is normalization? dec 2009

Cognizant,

3 8174

hi, i am new to database cau give me link where can i get about databse..

2226

If we use where clause in the left outer join then how the query would behave/act?

1 4204

write sql program to get the detail of student in a class?

2 10296

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

Cognizant, Infosys,

10 18766

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????

1 1992

how u can find the n row from a table?

Tech Mahindra,

19 30282

What is Primary Key?

Ramco,

4 10548

Difference between join and a subquery?

Base Automation, NMDC,

8 45416

Difference between sql and mysql?

1 2145

Its possible to use auto increment in oracle or not? If no means why?

1 4353

What does TKPROF stand for?

5 14416

Un-Answered Questions { Databases }

What are different types of constraints?

981

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?

1899

what is the command syntax for inserting a document?

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8210

Do we need to rebuild index after truncate?

1112

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

What is current version of mysql?

1057

Suppose database is running slow, what will you do?

2580

What is sql server query analyzer?

1111

What is the current version of sql?

1080

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2335

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?

1899

Design database draw er diagram for a certain scenario ?

4635

what is collation? : Sql dba

1211

How can I check that whether automatic statistic update is enabled or not?

1101

For More Un-Answered { Databases } Questions Click Here