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

Repair mdf file

2 3680

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1749

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1930

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

Miracle Software,

1844

This message is received in response to the query SELECT * FROM JA_Party. I would like to know what am I doing wrong. ERROR: relation "ja_party" does not exist LINE 1: SELECT * FROM JA_Party ^ ********** Error ********** ERROR: relation "ja_party" does not exist SQL state: 42P01 Character: 15

1 2687

What are the common bugs found while migrating to MySQL db to Postgre?

1 3019

What is inverted file ?

1402

What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the current query being processed?

1 2832

How is the statistics in PostgreSQL updated?

1 3620

What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

1287

What is the Maximum size for a table in PostgreSQL?

1526

PostgreSql Disadvantages

AFDD,

1919

What are the character types that are available in postgresql?

1398

What does GEQO stands for in PostgreSQL?

1390

What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

1462

Un-Answered Questions { Databases }

What is a clob in sql?

1019

What are different types of resources?

1010

Explain the concepts of a primary key and foreign key.

883

How to retrieve error messages using odbc_errormsg()?

1058

What do you understand by index hunting?

1133

What are the purpose of Normalisation?

1050

Does mysql use sql?

889

What are the ways on commenting in a pl/sql code?

1133

Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

2214

What is the maximum number of records in mysql table?

919

How to load data with sql*loader?

1048

You want to implement the many-to-many relationship while designing tables. How would you do it?

997

Write an sql query for deleting duplicate rows?

995

What is blind sql injection?

1071

What do we mean by record group in oracle forms?

1073

For More Un-Answered { Databases } Questions Click Here