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 get help at the sql prompt?

1068

What is sql in oracle?

1017

How run sql*plus commands that are stored in a local file?

996

What are the types pl/sql code blocks?

1083

What do you think about pl/sql?

961

Can ddl statements be used in pl/sql?

1086

How to create an array in pl/sql?

1027

How to start oracle sql developer?

996

How to set up sql*plus output format in oracle?

983

How to load data with sql*loader?

1017

What is a sql*loader control file?

1182

What is pl/sql language case sensitive?

1075

How to create your own reports in sql developer?

987

How to avoid using cursors?

1050

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

902

Un-Answered Questions { Databases }

How to experiment a data lock in oracle?

1010

How many types of dba are there?

528

Is mysql the same as sql server?

926

Explain go command in sql server?

978

When should the default values for oracle initialization parameters be used as is?

623

What are filegroups in sql server?

1022

What is max connections in mysql?

885

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1000

What is mean by candidate key?

958

What are different between mongodb and sql server databases?

What are translations and its use? : sql server analysis services, ssas

1006

What is a table called in database?

927

Define full outer join?

901

What is user-defined function?

923

What is the security model used in sql server 2005?

945

For More Un-Answered { Databases } Questions Click Here