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 9946

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

Accenture,

1 7334

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

HCL,

4 16440

how to connect sybase to sql server 2005?.

ABC,

1 5615

what is bulk bind

TCS,

4 14962

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

TCS,

4 25111

what is the order of pre-defined exceptions.

TCS,

6 16714

Can a table have two primary keys?

HCL, MetaCube,

44 96752

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 12134

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

11 19017

what is the syntax of update command?

Semantic Space,

3 6535

which clause we are not used in where clause?

Semantic Space,

3 7683

waht is referencial integrity?

Semantic Space,

2 7537

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

4 13998

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

Semantic Space,

11 34970

Un-Answered Questions { Databases }

What is crud?

How to prevent concurrent access to my data?

1032

Can we call dml statement in function?

1054

What does create schema do?

784

Write a SQL queries on Self Join and Inner Join.

1042

What is mutating table error?

1178

Is mongodb better than other sql databases? If yes then how?

How to list all field names in the result set using mssql_field_name()?

914

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1981

What is the command for quitting from sybase?

929

What authentication modes does sql server support? : sql server DBA

1215

What is maximum size of text datatype in postgres?

845

Explain sql data types?

1094

What are the parts of ms access?

860

What is storage engine in mongodb?

For More Un-Answered { Databases } Questions Click Here