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

Can multiple cursors being opened at the same time?

1060

How to invoke the data pump import utility?

1163

How to pass a cursor variable to a procedure?

1109

How to view the data files in the current database?

1098

How to turn on or off recycle bin for the session?

1109

What are the logical operations?

1125

How to list all indexes in your schema?

1093

What is the data pump export utility?

1081

How to create a new table in your schema?

1081

What happens to the data files if a tablespace is dropped?

1059

How to see free space of each tablespace?

1035

How to use "out" parameter properly?

1082

Can you drop an index associated with a unique or primary key constraint?

1019

What are data pump export and import modes?

1068

How to generate query output in html format?

1118

Un-Answered Questions { Databases }

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1750

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

2312

How do I switch users in mysql?

970

how may join possible between (requisition with purchase order)

2250

Would you like to easily automate your MS Access database through menu driven selections?

833

What is the difference between clustered and non-clustered index in sql?

1015

How do I run a sql script?

1147

how to increment dates by 1 in mysql? : Sql dba

978

What is Relational Calculus?

888

What are the operating modes in which database mirroring runs? : sql server DBA

1188

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

914

How do you change the name of a column?

802

What is the latest version of neo4j?

How to Check if table exists in sql server?

1136

Explain about the case statement present in stored procedure?

888

For More Un-Answered { Databases } Questions Click Here