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

Where the procedures are stored in database?

844

Explain about the implementation of stored procedures?

878

Does storing of data in stored procedures increase the access time? Explain?

1119

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

718

How can we call stored procedures inside store procedures?

826

State about the security aspects of stored procedures?

976

Explain the benefits of running stored procedure on a database engine?

938

How one call ddl statement using stored procedures in oracle?

799

State the different extensions for stored procedures?

806

How many types of stored procedure?

848

What is the difference between "is" and "as" while creating procedure?

810

What is the difference between stored procedures and stored functions in oracle?

931

How you can import data from other sources into access database?

986

Explain how we can do multi-join query in ms access?

855

Between different data’s, what are the types of relationship can be formed?

1022

Un-Answered Questions { Databases }

Explain the various tools used in etl?

What is CDC and explain complete CDC process flow?

592

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

970

What is the usage of "i-am-a-dummy" flag in mysql?

1136

What is the difference between a function and a trigger?

1082

How can we find out the current date and time in oracle?

1088

How to test null values?

1106

What is the data pump export utility?

1081

What is meant by decimal (5,2)?

1029

What is difference between inner join and full join?

1067

which types of join is used in sql widely? : Sql dba

982

How does mysql store dates?

939

Difference between 10g & 11g in odi?

776

What is meant by referential integrity?

1010

How many ways we can retrieve the date in result set of mysql using php?

1119

For More Un-Answered { Databases } Questions Click Here