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

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

1001

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?

1049

What is the starting oracle error number?

1053

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

994

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

994

How would you pass hints to the sql processor?

981

Explain two easy sql optimizations.

1009

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

981

Why is sql*loader direct path so fast?

1103

Name three sql operations that perform a sort.

1013

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

596

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

589

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

564

Explain procedure to change characterset of a database.

632

What is oracle archived redo log?

593

Un-Answered Questions { Databases }

how can a database be repaired? : Sql server administration

971

What is in place upgrade in sql server?

1045

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1103

How do I create a database in sybase central?

914

Can coalesce return null?

1014

Explain the difference between triggers and constraints?

975

What is dynamic proxy?

1005

What is the maximum size of column in sql server?

893

Why do we use functions?

913

What does clipper stand for?

1003

What is keys and its types?

1075

Sql server reporting services vs. Crystal reports.

131

Is declare cursor executable?

993

Difference between varchar and varchar2 data types?

1184

Which version of sql do I have?

1056

For More Un-Answered { Databases } Questions Click Here