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 to create a table index?

1155

How to assign data of the deleted row to variables?

1075

How to work with data objects interactively?

989

How to add a new column to an existing table with a default value?

1016

How to get a list of all tables in the database?

1 4279

How to set up autotrace for a user account?

1059

How to run the anonymous block again?

1132

How to see the table columns used in an index?

1024

How to drop an index?

962

What happens to the current transaction if the session is killed?

990

How to define an external table with a text file?

1070

How to get a list of all user accounts in the database?

1090

How to define a sub function?

1136

How to define a data field as not null?

1110

How to enter a new row into a table interactively?

1014

Un-Answered Questions { Databases }

How to drop an existing view in oracle?

947

How to rename a column in an existing table?

1035

How is query injection and how to handle it in mongodb?

What is dbms and its application?

1006

How do I start mysql in linux?

911

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1950

What is the difference between the sql*loader and import utilities? : aql loader

1044

What do you mean by checkpoints in dbms?

881

What is a system concept?

919

Which mysql function is used to concatenate string?

1490

what is storage manager?

931

How to create new databases with "create database" statements?

1025

What is de-normalization in sql database administration? Give examples?

987

What is morphia mongodb?

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1039

For More Un-Answered { Databases } Questions Click Here