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?

946

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?

993

What is the starting oracle error number?

999

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

940

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

938

How would you pass hints to the sql processor?

922

Explain two easy sql optimizations.

963

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

915

Why is sql*loader direct path so fast?

1054

Name three sql operations that perform a sort.

959

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

549

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

528

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

522

Explain procedure to change characterset of a database.

562

What is oracle archived redo log?

539

Un-Answered Questions { Databases }

What is a left join?

890

Can two different columns be merged into single column? Show practically?

1015

How to create a new table in a given schema?

1115

Why is mysql popular?

834

What are the main differences between the two?

844

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1144

Discuss row chaining, how does it happen?

520

How many columns can a table have?

856

What are the types of Knowledge Modules?

534

What are the drivers in MySQL?

1370

What are a query and state the different types of queries and their uses?

943

Is t sql a programming language?

1007

how to select unique records from a table? : Sql dba

1058

Can group functions be mixed with non-group selection fields in ms sql server?

892

Is primary key an index?

947

For More Un-Answered { Databases } Questions Click Here