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

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 3666

how to pass values from one table to another by using Bulk collect?

Oracle, Wipro,

3 11131

what are the components of database architecture?

Wipro,

6 13395

Is index a datbase objects in sql server?

2 5048

What is Dedicated Administrator Connection in sql server 2005?

2 5601

why SQL server is more used to store database rather than Access

2 4746

how to find the second highest salary in a given table????

5 8951

How many types of Joins in SQL Server 2005?

CarrizalSoft Technologies, HCL,

9 12332

What is Inner Join?

2 5293

What is Outter Join?

1 4093

How many types of Outer Joins?What are they?

1 3863

What is Left Outer Join?

2 4608

What is Right Outer Join?

2 4682

What is Full Outer Join?

3 6262

What is Cross Join

3 6732

Un-Answered Questions { Databases }

Can we do dml on views?

1027

How do I find query history in sql server?

1018

What is current version of mysql?

1063

Who proposed the relational model?

1027

Is primary key clustered index?

1008

How can I check that whether automatic statistic update is enabled or not?

1108

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

1121

What kind of problems occurs if we do not implement proper locking strategy?

1490

Why should you use or avoid select * statements?

1103

Do we need to rebuild index after truncate?

1126

If a cursor is open, how can we find in a pl/sql block?

1234

What is the current mysql version?

1086

Explain “row_number()” in sql server with an example?

1066

what is the command syntax for inserting a document?

Why we use the openxml clause?

1064

For More Un-Answered { Databases } Questions Click Here