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 can we Update a table with out using UPDATE command?

1 6085

What is user stored procedure & it purpose?

Wipro,

4 8636

wHAT IS THE difference between foreign key and reference key

1 4423

How do we rollback the table data in SQL Server

3 17219

write a qurey for finding the length of the sting.

Infosys, TCS,

6 15250

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

1 2206

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

IBM,

5 32794

What is the differnce between Order by and Group by

1 4481

where do you use Isolations?give me some exmpale?

1 5370

In which year relase the 7.0& 2000 & 2005?

1 3891

wht r the base tables & primary key for BOM& WIP modules

Satyam,

1 6023

what is exact difference between drop and truncate table.

3 7460

Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...

Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,

10 15858

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

Covansys,

1 6308

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 7998

Un-Answered Questions { Databases }

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

8226

What is current version of mysql?

1072

How do I remove duplicates in two columns?

1179

Can we use distinct and group by together?

1133

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?

1901

how to escape special characters in sql statements? : Sql dba

1111

what is bcp? When does it used? : Sql dba

1053

Can we rollback truncate?

1072

How to connect php with different port numbers?

1181

Are you familiar with user exits in reports?

Have you created fact table and dimension tables?

709

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1129

Is it possible to have clustered index on separate drive from original table location?

1036

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2349

What are the source of constraints?

1006

For More Un-Answered { Databases } Questions Click Here