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 3682

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

1750

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

1932

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 3022

What is inverted file ?

1403

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

1 2834

How is the statistics in PostgreSQL updated?

1 3624

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

1288

What is the Maximum size for a table in PostgreSQL?

1527

PostgreSql Disadvantages

AFDD,

1921

What are the character types that are available in postgresql?

1399

What does GEQO stands for in PostgreSQL?

1391

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

1464

Un-Answered Questions { Databases }

What is the difference between sql, mysql and sql server?

1102

Who created postgresql?

762

How to add more data to the testing table in ms sql server?

1088

What is data type in sql?

962

What are pl/sql cursors?

1049

How to start the command-line sql*plus?

1053

How to manage transaction isolation level?

1006

What is “i_am_a_dump” flag in mysql?

1067

What is postgresql and pgadmin?

840

How to write a query with a full outer join in ms sql server?

1076

How do I connect to a sybase database?

975

What do you understand by user-defined function in the sql server?

951

How to change the ownership of a schema in ms sql server?

1193

What is innodb_buffer_pool_size?

980

Can a parameter be passed to a cursor?

1126

For More Un-Answered { Databases } Questions Click Here