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

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

EDC,

2559

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 6729

Alternative way to DetDate() function?

5 9842

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

TCS,

7 11603

when MSQL8.0 is in market

2083

what is meant by magic query

2191

What is Stored procedure ?

IBM, iGate, Inspira Technologies,

4 10833

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

Oracle, Scend, TechInfini,

35 60282

How to delete an attribute from the emp table

4 9561

Define the terms primary key foreign key and also the difference between primary and the unique key

2 11212

What is autonomous transaction?

6 12241

What is Tab Query Whats its advantage over Sql-Query

TELUS, Unisys,

4593

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 4549

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 5081

How we create SQL Server 2005 Reporting Services ? Give me Sample

HCL,

1998

Un-Answered Questions { Databases }

How to create function without parameter in sql server?

1063

What is pl/sql table? Why it is used?

1042

Define data, entity, domain and referential integrity?

1112

Which command is used for user defined error messages?

1067

How to create a new table from existing table in postgresql?

862

How to pad with leading zeros an int or smallint in sybase?

855

explain what is mysql? : Sql dba

1088

Explain a checkpoint?

1043

what is the stuff function and how does it differ from the replace function? : Sql dba

1062

Give the various rollback segment states.

1055

What is the difference between sql and psql?

911

What does a dba stand for?

585

What is degree of Relationship type?

853

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1161

How many types of index are there?

1045

For More Un-Answered { Databases } Questions Click Here