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

What is case function?

1047

How many row comparison operators are used while working with a subquery?

1044

What are the 3 modes of parameter?

1170

Is it possible for a table to have more than one foreign key?

1042

Explain the difference between rename and alias?

1029

What do you mean by rowid?

993

Explain dml and ddl?

1015

What is the primary key?

965

How to select all records from the table?

1156

How to write a query to show the details of a student from students table whose

1011

List different type of expressions with the example.

943

Define join and name different types of joins?

1015

What do we need to check in database testing?

1032

How we can update the view?

1056

How do we use distinct statement? What is its use?

1040

Un-Answered Questions { Databases }

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1931

How to create a new view in oracle?

1089

how to do backup entire database? : Transact sql

1157

What is resultset concur_updatable?

1033

can we use lexical perameter in oracle plsql if yes how

2329

What is the scope of a local variable?

1082

Is it postgre or postgres?

830

What is open server in sybase?

829

State the criteria which a trusted publisher should meet before adding him?

868

Can sql servers linked to other servers?

1060

What is read uncmmited?

1075

how we use window authentication connection with sql server.?

1169

What is global database name?

1013

What is memory optimized table?

1057

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2252

For More Un-Answered { Databases } Questions Click Here