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,

1 2632

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

2 6850

Alternative way to DetDate() function?

5 10106

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 11962

when MSQL8.0 is in market

1 2165

what is meant by magic query

1 2264

What is Stored procedure ?

IBM, iGate, Inspira Technologies,

4 11040

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 61889

How to delete an attribute from the emp table

4 9796

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

2 11393

What is autonomous transaction?

6 12566

What is Tab Query Whats its advantage over Sql-Query

TELUS, Unisys,

1 4698

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 4687

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 5233

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

HCL,

1 2070

Un-Answered Questions { Databases }

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2211

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1954

Can we shrink data file in sql server?

1124

How do I remove duplicates in two columns?

1180

Have you created fact table and dimension tables?

710

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2293

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2178

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

Can we rollback truncate?

1072

What is temporary table in sql server? Why we use temp table?

1017

Does view occupy space?

1012

define sql insert statement ? : Sql dba

1097

How to enter binary string literals in ms sql server?

1237

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8227

Is microsoft getting rid of access?

885

For More Un-Answered { Databases } Questions Click Here