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 can we find out the current date and time in oracle?

1134

What is a nested table and how is it different from a normal table?

1115

How is it different from a normal table?

1084

How does the on-delete-cascade statement work?

1165

What is meant by joins? List out the types of joins.

1110

What do you understand by database schema and what does it hold?

1310

What do you mean by merge in oracle and how can we merge two tables?

1098

What is a trigger and what are its types?

1333

List out the types of joins.

1243

What are the parameters that we can pass through a stored procedure?

1121

What is a nested table?

1113

How view is different from a table?

1092

What do you understand by a database object?

1109

What is meant by raw datatype?

1121

When do we use group by clause in a sql query?

1101

Un-Answered Questions { Databases }

What is microsoft access used for in real life?

896

How do sql triggers work?

1096

How to select some specific rows from a table in ms sql server?

1059

Is sql between inclusive?

1201

What is record in ms access?

918

How do I run a query in mysql?

997

What are the basic functions for master, msdb, model, tempdb databases?

1098

How to create a stored procedure with a statement block in ms sql server?

1133

What is the difference between a database and a spreadsheet?

1008

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2906

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2059

What is a user exit program in oracle reports?

1083

How would concatenate strings in mysql?

1102

Should I store images in database?

1089

What is scalar user-defined function?

1192

For More Un-Answered { Databases } Questions Click Here