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

How to invoke the data pump export utility?

1254

How to define an anonymous block?

1247

How to list all tables in your schema?

1120

How to use "in out" parameter properly?

1104

How to use windows user to connect to the server?

1045

How to execute a stored program unit?

1128

How to load data from external tables to regular tables?

1106

What happens to the current transaction if a ddl statement is executed?

1060

How to drop a tablespace?

1087

How to retrieve the count of updated rows?

1194

What happens to the indexes if a table is recovered?

1045

How to get execution path reports on query statements?

1045

How to add another datafile to a tablespace?

1091

How to assign values to variables?

1168

How to retrieve data from an cursor to a record?

1158

Un-Answered Questions { Databases }

what is the default port for mysql server? : Mysql dba

1105

How to get the number of affected rows?

1054

Why should you use or avoid select * statements?

1078

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2547

what is bit datatype? : Sql server database administration

963

What are named parameters?

1146

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

768

why not null is not allowed at table level

2809

State some criteria and their effects of a database?

966

What is difference between sql and rdbms?

1082

What is pg_catalog?

782

When would you use it?

1043

what is the command syntax for inserting a document?

What is a transact-sql statement batch in ms sql server?

1075

How do I keep my database up to date?

972

For More Un-Answered { Databases } Questions Click Here