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 is difference between logical standby database and physical standby database?

683

What is the easiest method to create a file on unix?

577

using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?

1 1043

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

575

What is explain plan and how is it used?

619

What is the purpose of the grep command?

1 2156

How do you set up tablespaces during an oracle installation?

619

You have taken a manual backup of a datafile using os. How rman will know about it?

563

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

617

How many control files should you have? Where should they be located?

597

What are four common errors found in an alert .log?

573

How do you generate file output from sql?

634

You see multiple extents in the temporary tablespace. Is this a problem?

600

What is the finger command?

597

What does >> do?

599

Un-Answered Questions { Databases }

What is the return type of mysqli_query?

884

Why do we partition data?

1054

What can you do with mysql?

1027

What is procedure function?

1082

Are databases stored on servers?

1054

What is bson and how can restore this file in mongodb?

Is sql low level language?

1039

How to include text values in sql statements?

1058

What is data model and types?

953

Explain can you move old files in the movechunk directory?

You want to use a perspective in an mdx query. How do you select the perspective?

244

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

1079

Explain fully functional dependency?

979

What is postgresql and pgadmin?

861

How to use in conditions in oracle?

1072

For More Un-Answered { Databases } Questions Click Here