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

What are advantages fo Stored Procedures?

1 3234

What are the uses of Database Trigger ?

1719

What is Database Trigger ?

1 3017

Can the default values be assigned to actual parameters?

1 2707

Can a primary key contain more than one columns?

2 3754

What is an UTL_FILE.What are different procedures and functions associated with it?

1 3399

Differentiate between TRUNCATE and DELETE?

2 3047

What is difference between a formal and an actual parameter?

1 2680

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2662

What are different Oracle database objects?

1 2669

What is difference between SUBSTR and INSTR?

1 3032

Display the number value in Words?

1 3093

What is difference between SQL and SQL*PLUS?

1 2948

What are various joins used while writing SUBQUERIES?

2 4016

What a SELECT FOR UPDATE cursor represent.?

1 2910

Un-Answered Questions { Databases }

How to access the deleted record of an event?

1040

How many databases can sql express handle?

984

What is table level locking in mysql?

919

What is syntax of for loop in r?

What are the different types of (all page) locks in sybase?

816

How to create a Master database in SQL server ?

1088

What is the difference between a database and a spreadsheet?

959

Teradata: How can we know the indexed column in a table?

1891

Explain for what purpose you can use neo4j databases?

How to assign null values to variables or columns?

974

How do I debug a stored procedure in sql server?

1106

How do I make my sql query run faster?

941

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1048

How many types of triggers in sql server?

1030

How to locate and take substrings with charindex() and substring() functions?

1016

For More Un-Answered { Databases } Questions Click Here