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

Explian rowid, rownum? What are the psoducolumns we have?

1045

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?

1108

What is the starting oracle error number?

1098

What is the starting oracle error number? What is meant by forward declaration in functions?

1041

In pl/sql, what is bulk binding, and when/how would it help performance?

1035

How would you pass hints to the sql processor?

1041

Explain two easy sql optimizations.

1075

How do I write a cron which will run a sql query and mail the results to agroup?

1031

Why is sql*loader direct path so fast?

1141

Name three sql operations that perform a sort.

1064

What is the use of the drop option in the alter table command?

629

How do you use automatic pga memory management with oracle 9i and above?

627

Which function is used to find the largest integer less than or equal to aspecific value?

592

Explain procedure to change characterset of a database.

676

What is oracle archived redo log?

628

Un-Answered Questions { Databases }

How do I run multiple versions of sybase on the same server?

930

How to define output parameters in stored procedures?

1083

When I delete any data from a table, does the sql server reduce the size of that table?

1062

what is 'mysqlcheck'? : Sql dba

1064

Name the different types of indexes in sql and define them.

1222

explain the difference between myisam static and myisam dynamic. : Sql dba

992

Can you create an index on an array field in mongodb? If yes, what happens in this case?

How to compare the top two records using sql?

1414

Can a composite key be null?

1034

How to view the tablespaces in the current database?

1026

What is use of except clause? How does it differ from not in clause?

1068

What types of languages use to work with mongodb?

How we can get the current date in mysql?

998

What is the default postgres database?

906

What is transact-sql language?

1135

For More Un-Answered { Databases } Questions Click Here