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

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

EDC,

2609

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

2 6830

Alternative way to DetDate() function?

5 10037

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 11875

when MSQL8.0 is in market

2149

what is meant by magic query

2242

What is Stored procedure ?

IBM, iGate, Inspira Technologies,

4 10974

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 61503

How to delete an attribute from the emp table

4 9732

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

2 11339

What is autonomous transaction?

6 12468

What is Tab Query Whats its advantage over Sql-Query

TELUS, Unisys,

4668

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 4651

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 5192

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

HCL,

2051

Un-Answered Questions { Databases }

Tell me what are cursors and when they are useful?

1009

How is the pattern matching done in the sql?

1216

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

973

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1109

What are mysql functions?

999

What is the maximum size of an access database?

920

Explain sub-query?

1020

what is a trigger in mysql? Define different types of trigger. : Sql dba

1130

What is difference between cte and view?

982

What is database development process?

946

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

123

Explain cdc and sql injection?

1049

What are the advantages of partitioning?

1189

What are the Advantages of using CTE in sql server?

1176

How to display a past time in days, hours and minutes?

1070

For More Un-Answered { Databases } Questions Click Here