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

Oracle (3259)
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 3221

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

2228

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

10 80756

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

8 13223

What is the disadvantages of index?

TCS,

3 8670

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

Exilant,

3 10227

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 4512

How to remove duplicate rows from a table?.

3 8307

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 6553

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 12757

select names starts with a,b,c

Scope International,

8 14195

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

1 3257

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 6837

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

2545

how to do partition in sqlserver

TCS,

2480

Un-Answered Questions { Databases }

List some of the uses of ms access.

873

How many tables can a sql database have?

980

What is the use of set nocount on/off statement?

1097

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1162

What has replaced microsoft access?

940

List five most important parameter in 9i affecting performance?

570

How do I view a script in sql server?

1047

Explain optimistic and pessimistic concurrency?

996

What are stored procedures used for?

1003

What is an oracle wallet?

942

what is the diffrence between core dba and apps dba?

2573

What is the Maximum size for a table in PostgreSQL?

1528

What are the restraints imposed on the table design by a merge replication?

1039

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2109

What are the properties and different types of sub-queries?

1011

For More Un-Answered { Databases } Questions Click Here