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

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1058

How to connect to oracle using service name instead of sid?

1042

When do I need to use a semicolon vs a slash in oracle sql?

1114

How do I escape a reserved word in oracle?

1226

How to best split csv strings in oracle 9i?

1066

What is different types of joins?

1049

How to fetch the row which has the max value for a column?

1015

How to get last row id?

1024

How to put more than 1000 values into an oracle in clause?

1058

Difference between inner join vs where ?

1060

How to store only time; not date and time?

1052

What is the minimum client footprint required to connect c# to an oracle database?

1121

Is there a combination of "like" and "in" in sql?

1095

How can I introduce multiple conditions in like operator?

1020

How to load a large xml file?

1073

Un-Answered Questions { Databases }

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2642

How to start your 10g xe server from command line?

1084

Define self join?

1040

Does youtube use a database?

1017

What is a tinyint?

971

How to update values in a table with update statements in ms sql server?

1028

What are different types of triggers?

1127

What is bcnf in the dbms?

955

What is pessimistic concurrency control? : Transact sql

1107

An index is reaching a limitation on the number of pages it has, can you explain why this limitation exists and what work you would do to get around it?

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1103

What does an oracle dba do?

618

How would you fix a munged log in sybase ?

982

Can you get second highest salary from the table?

979

what is the difference between a having clause and a where clause? : Sql dba

1114

For More Un-Answered { Databases } Questions Click Here