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

Explain the use of consistent option in exp command.

1 1185

Explain the use of indexes option in imp command.

1 1320

what is the use of system.effective.date variable in oracle?

1 1190

Explain the types of exception?

1 1224

When do you get a .pll extension in oracle? Explain its importance

1 1125

What are the various types of snapshots ?

1 1104

Explain the use of ignore option in imp command.

1 1114

What is the purpose of save points in oracle database?

1 1261

Difference between open_form and call_form in oracle.

1 1254

Explain an exception and its types?

1 1173

What are the different types of record groups in oracle? Explain each of them

1 1108

Explain the use of record length option in exp command.

1 1155

What is control file used for?

1 1365

Explain the use of inctype option in exp command.

1 1112

what are actual and formal parameters?

1 1196

Un-Answered Questions { Databases }

How to select all columns of all rows from a table in oracle?

1126

How can you append an identity column to a temporary table?

1069

Can sql servers link to other servers like oracle?

915

Were you involved in any data conversion, which one?

How can I check that whether automatic statistic update is enabled or not?

1110

Equi join and non equi join is possible with sql server?

1132

what are the advantages of sql ? : Sql dba

1141

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2211

How to start an oracle instance?

1103

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

How to convert character strings into numeric values?

1189

What is the latest version of postgresql?

951

What are the two main functions of queries in databases?

1530

What kind of problems occurs if we do not implement proper locking strategy?

1499

How to write a left outer join with the where clause in oracle?

1151

For More Un-Answered { Databases } Questions Click Here