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

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 3584

how to delete all duplicate records from a table using subquery?

ABC, Cap Gemini,

7 24129

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9703

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 9020

what is advantages in sql 2005 over sql 2000?

4 8177

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1 2859

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 10723

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

Wipro,

1 2359

Differnce between sel server 2000 and 2005

3 6519

a __________ is a virtual table made up of subset of actual table

2 5086

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 5283

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 4148

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

TCS,

1 2232

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 11253

How to make a replica of existing oracle server to another server?

3 7179

Un-Answered Questions { Databases }

What is sql server query analyzer?

1123

How do I find query history in sql server?

1018

Design database draw er diagram for a certain scenario ?

4647

Can we use distinct and group by together?

1131

Can delete statement be rollbacked?

1050

Do we need to rebuild index after truncate?

1129

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1896

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

1950

Why should you use or avoid select * statements?

1106

What are the source of constraints?

1006

Were you involved in any data conversion, which one?

Is there some bulk load or other way to import a lot of data fast?

931

define sql insert statement ? : Sql dba

1094

Who proposed the relational model?

1027

What is a scheduled job or what is a scheduled task?

1033

For More Un-Answered { Databases } Questions Click Here