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 3156

What are the uses of Database Trigger ?

1647

What is Database Trigger ?

1 2932

Can the default values be assigned to actual parameters?

1 2646

Can a primary key contain more than one columns?

2 3671

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

1 3346

Differentiate between TRUNCATE and DELETE?

2 2945

What is difference between a formal and an actual parameter?

1 2627

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

1 2622

What are different Oracle database objects?

1 2596

What is difference between SUBSTR and INSTR?

1 2946

Display the number value in Words?

1 3035

What is difference between SQL and SQL*PLUS?

1 2870

What are various joins used while writing SUBQUERIES?

2 3925

What a SELECT FOR UPDATE cursor represent.?

1 2855

Un-Answered Questions { Databases }

What are vdl and sdl?

1096

How do clustered indexes store data?

1065

How do I stop a mysql service?

966

What does a dba stand for?

532

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

546

How do you add a column to a table?

1013

What is psql command?

897

What are the types of stored procedures?

766

What are the key configuration files for sql server reporting services ?

165

What is the role of database server in database management system?

844

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

966

What is concurrency in oracle?

965

What are the different types of cursor?

1051

What is the difference between data source and database?

1028

What is difference between unique and primary key?

871

For More Un-Answered { Databases } Questions Click Here