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

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

IBM, TCS,

2 8832

What is the difference between RBBMS & DBMS?

4 9097

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

1 9049

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

Hewitt,

9 11790

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

4 6253

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

7 9351

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

2 5322

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 4311

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

2 5596

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

TCS,

3 9115

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 12048

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

TCS,

1 6125

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

TCS,

2 5447

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

2510

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 3057

Un-Answered Questions { Databases }

You need to multiply all values of a single column. How would you do that?

887

What is a sql profiler?

1025

Explain phantom deadlock?

1234

How is sql used in oracle?

1005

How does join work in sql?

1012

Explain, why is rdbms better than dbms?

991

What is command parameter in ssrs?

161

Why transaction is important?

975

What are primary key and foreign key and how they work?

977

What is a postgres server?

924

Why is partition used in sql?

1123

What are trace flags and mention a few common trace flags used with sql server?

1087

What will be the maximum number of indexes per table?

962

How do you optimize a stored procedure query?

998

What are parameterized reports? What are cascading parameters in ssrs reports?

156

For More Un-Answered { Databases } Questions Click Here