Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 3786

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

1799

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

2003

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,

1903

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 2760

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

1 3098

What is inverted file ?

1462

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

1 2923

How is the statistics in PostgreSQL updated?

1 3713

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

1327

What is the Maximum size for a table in PostgreSQL?

1577

PostgreSql Disadvantages

AFDD,

1979

What are the character types that are available in postgresql?

1451

What does GEQO stands for in PostgreSQL?

1442

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

1507

Un-Answered Questions { Databases }

What is the sid in oracle?

1032

How many ways to create table-valued functions?

1057

Explain how ms access is better than ms sql server?

919

what is a deadlock? : Sql server database administration

1150

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2288

How to convert string to objectid in mongoose?

What is transaction server explicit transaction?

1089

What is an access?

868

Is it important for a database administrator to understand the operating system and file access?

1043

How do I run a sql trace?

1003

How many replicas are maintained for each SQL Azure database?

144

What are crud methods?

1086

Why do we use bulk collect in oracle?

1108

How do I move tempdb off of the master device?

910

What are magic tables in sql server?

1202

For More Un-Answered { Databases } Questions Click Here