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

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 3867

If we shrink the Databse and Files, how much size is decreased?

TCS,

1 3859

What will you do If the low Performance occurs?

2 4360

Explain Capacity planning to create a database? and how to monitor it?

1 4275

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 2840

In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?

2203

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 8425

how we can use a database with php.

HCL, IT Solution,

2 4338

How retrieve field names from the table in SQL through JAVA code?

1 1975

what is the maximum size of a row in sql server 2000 and 2005

2 5025

what is bit data type? and what are the information that can be stored inside a bit column?

2 4557

what are default? Is there a column to which a default cant be bound?

1 3453

what purpose does OPENXML clause have in sql server stored procedure?

1 5707

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 3853

can we create relastionship bet 2 tables in ms-access

2 6290

Un-Answered Questions { Databases }

How to connect php with different port numbers?

1177

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1291

What is temporary table in sql server? Why we use temp table?

1008

How to rebuild the master database?

1158

What is oracle latest version?

1169

how to start mysql server? : Sql dba

1258

What is the difference between upgrade and migration in sql server?

1175

What is your daily office routine?

2340

Suppose database is running slow, what will you do?

2590

How do I find query history in sql server?

1018

Why use identity in sql server?

1189

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?

1905

How raid can influence database performance?

1110

Can sql servers link to other servers like oracle?

910

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

For More Un-Answered { Databases } Questions Click Here