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,

2572

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

2 6750

Alternative way to DetDate() function?

5 9877

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 11657

when MSQL8.0 is in market

2096

what is meant by magic query

2202

What is Stored procedure ?

IBM, iGate, Inspira Technologies,

4 10863

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 60537

How to delete an attribute from the emp table

4 9586

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

2 11235

What is autonomous transaction?

6 12281

What is Tab Query Whats its advantage over Sql-Query

TELUS, Unisys,

4610

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 4570

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 5104

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

HCL,

2011

Un-Answered Questions { Databases }

Define database system.

978

Is mysql workbench a dbms?

1019

How do I view stored procedures?

988

How do I setup a database connection?

1026

Do you know query execution plan?

1201

what is isolation level at dead lock?

2169

What is oracle partial backup?

595

Is not equal in sql?

1023

What is an anonymous block?

1275

What is the data type of time?

978

What is DCL?

1067

Can group functions be mixed with non-group selection fields?

1033

Difference between lexical and bind varible.

Explain the primary key?

823

where the dff data will be stored

2469

For More Un-Answered { Databases } Questions Click Here