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

Is natural join and inner join same?

946

Why stored procedure is faster than query?

1090

What's the procedure?

940

Why stored procedure is better than query?

962

What is pivot query?

1092

Why is stored procedure faster than query?

978

What is the example of procedure?

947

What is the difference between a procedure and a function?

1133

Which is faster view or stored procedure?

969

Which is better trigger or stored procedure?

974

Why stored procedures are faster than query?

1043

What is the difference between view and stored procedure?

976

What is scalar function?

1062

What is the process of debugging?

1088

What is scalar and vector?

1018

Un-Answered Questions { Databases }

Can a foreign key be null?

1113

Explain about the implementation of business logic in stored procedures?

754

How does partition assignment relate to transactions in sybase?

895

How do I find mysql location?

980

Is it possible to create startup or shutdown trigger for on-schema?

1050

What is mysql used for?

972

How do I delete a row in mysql?

983

Which join is like inner join?

1050

What is a trace file?

1090

What is the difference between bind and lexical parameter?

1091

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1952

What is mean by candidate key?

1027

Can the query output be sorted by multiple columns in oracle?

1007

What is save point in oracle database?

1325

What are the properties of a primary key in DBMS?

974

For More Un-Answered { Databases } Questions Click Here