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 3602

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

1721

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

1870

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,

1808

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 2613

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

1 2928

What is inverted file ?

1345

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

1 2751

How is the statistics in PostgreSQL updated?

1 3525

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

1249

What is the Maximum size for a table in PostgreSQL?

1485

PostgreSql Disadvantages

AFDD,

1873

What are the character types that are available in postgresql?

1356

What does GEQO stands for in PostgreSQL?

1355

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

1423

Un-Answered Questions { Databases }

What is procedure and function in sql?

949

What is parameter substitution in sql?

993

Can we use where clause with group by?

871

What will you get by the cursor attribute sql%rowcount?

985

How can you control the amount of free space in your index pages? : sql server DBA

1267

How to connect to a remote server?

1075

What do I need to start working with sql studio? : sql server management studio

1067

How to rename an index in oracle?

1080

Why indexing is used in database?

889

What is the difference between nested table and varray?

969

Can we return Data from 4(more than 1) tables in stored procedure?

1019

What is oracle update statement with inner join ?

1008

What is the difference between a primary key and a unique key?

1014

What happens if you set the sga too low in oracle?

1076

What are keys in sql?

960

For More Un-Answered { Databases } Questions Click Here