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 can it possibble to see the report output in excel sheet in oracle applications

Oracle, Wipro,

4 9994

what is sql*loader parameters and where we will use it.

Accenture,

1 7353

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

HCL,

4 16494

how to connect sybase to sql server 2005?.

ABC,

1 5642

what is bulk bind

TCS,

4 15005

what is mean by forward declaration and where we'll use it.

TCS,

4 25174

what is the order of pre-defined exceptions.

TCS,

6 16784

Can a table have two primary keys?

HCL, MetaCube,

44 97161

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

Hexaware,

4 12170

how to select a field with firstletter as capital and remaining are small letters

11 19120

what is the syntax of update command?

Semantic Space,

3 6572

which clause we are not used in where clause?

Semantic Space,

3 7726

waht is referencial integrity?

Semantic Space,

2 7578

How to write stored procedure to update the data in 10 tables

4 14053

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 35047

Un-Answered Questions { Databases }

Why indexing is needed?

1001

How to move a multi-file database?

1053

What you can do to delete a table without the delete trigger firing?

986

How do we display rows from the table without duplicates?

988

What is database architecture?

715

what are the different ways to return the rowcount of a table?

1012

Now days, what makes mongodb best?

How to use "if" statements on multiple conditions?

1189

How to download oracle database 10g xe?

1031

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1202

How to call a stored function in oracle?

1034

What is an access?

826

Are sql database names case sensitive?

1019

Explain oracle’s server parameter file.

1010

Why do we use databases?

891

For More Un-Answered { Databases } Questions Click Here