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

When should an artificial (or derived) primary key be used?

607

Give one method for transferring a table from one schema to another?

616

How many control files should you have?

605

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

631

What happens if the constraint name is left out of a constraint clause?

557

How do you prevent output from coming to the screen?

540

What is dump destination? What are bdump, cdump and udump?

582

When configuring sqlnet on the server what files must be set up?

646

I have applied the following commands: now what will happen, will the database will give an error / it will work?

568

What are the requirements of simple database?

577

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

598

What command is used to type files to the screen?

606

How can you find out how many users are currently logged into the database?

620

How can you determine if an index needs to be dropped and rebuilt?

580

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

699

Un-Answered Questions { Databases }

Explain correlated query work?

1068

How much money does a dba make?

593

what are integrity rules?

1049

What are the column comparisons operators?

1252

What is vector point function?

1067

How many types of normalization are there?

979

What is the use of mysql_fetch_array () function in php?

954

Have you heard about sixth normal form?

1012

When do I need to use a semicolon vs a slash in oracle sql?

1108

How to apply cascading referential integrity in place of triggers?

1057

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4338

what is a traditional network library for sql servers? : Sql server database administration

975

How to connect to sybase database from linux?

1010

What will be query used to get the list of triggers in a database?

1019

Does facebook use graph database?

1046

For More Un-Answered { Databases } Questions Click Here