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

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

IBM, TCS,

2 8957

What is the difference between RBBMS & DBMS?

4 9306

How to get last system shutdown time in Sql server when restarted system?

1 9167

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

Hewitt,

9 12148

How will you collect the date from current date to last older 6 days date in sql server 2005

4 6403

how we can store the value like that 001,003,023 etc in sql server 2005

7 9614

Selet all the data from table where last name is n of employee

2 5424

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 4382

How to find the latest updated value in a table without sending any parameters to that query

2 5696

write a query find which rows of a table is updated on 2 days before?

TCS,

3 9240

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

TCS,

4 12249

how to improve the speed of SQL database server and how to avoid dead lock?

TCS,

1 6204

the process of adding a cpu in sql server is called..?

TCS,

2 5576

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2565

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 3136

Un-Answered Questions { Databases }

What are the different oracle database objects?

1152

How exception is different from error?

1068

What is nested transaction?

1143

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2107

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1076

How to skip remaining statements in a loop block using continue statements?

1045

What are the characteristics of data in the database?

1057

Is sql a oracle?

1022

Explain relational algebra?

985

What are the main functions of a database management system?

993

How to disable a login name in ms sql server?

1178

How to include character strings in sql statements?

1049

Versions of softwares change everyday. In what format should I save my database so that different versions of ms access cab open it?

890

What is a data manipulation language?

1078

How do I open microsoft access on my computer?

893

For More Un-Answered { Databases } Questions Click Here