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

Excellent job opening with one of our client in Hyderabad About Client : It is an American e-commerce company based in Seattle, Washington, a leading online retailer of products that inform, educate, entertain and inspire.

1 3313

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

2279

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 81147

How can I create a table from another table without copying any values from the old table?

8 13510

What is the disadvantages of index?

TCS,

3 8792

in table there r so many rows write a query which two rows r updated last two day befor?

Exilant,

3 10373

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 4623

How to remove duplicate rows from a table?.

3 8462

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

Cognizant,

1 6623

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

IBM, Metric Stream,

4 12961

select names starts with a,b,c

Scope International,

8 14455

1)how to Take Backup in sql server 2005 from Flash Drive

1 3332

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

Adea,

4 7023

How to convert a table data in XML format in sql server?

2598

how to do partition in sqlserver

TCS,

2547

Un-Answered Questions { Databases }

What is the limitation on the block size of pl/sql?

1045

Difference between uniqe index and uniqe constraint?

1050

Mention the differences between having and where clause.

1122

What is n tier architecture with example?

819

How are extents allocated to a segment?

1184

What is in place upgrade in sql server?

1097

How do I tune a sql query?

1044

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2609

What is pdo in php mysql?

997

Explain the role of building blocks like Nodes, Relationships, Properties and Labels in Neo4j?

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

612

What is database development process?

940

What is durability in DBMS?

957

master table and child table performances and comparisons in Oracle ?

2201

What are the five characteristics of good data?

978

For More Un-Answered { Databases } Questions Click Here