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

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 3473

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

ABC, Cap Gemini,

7 23822

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9465

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 8808

what is advantages in sql 2005 over sql 2000?

4 8008

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

2768

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 10526

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,

2305

Differnce between sel server 2000 and 2005

3 6337

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

2 4974

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 5166

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 4049

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,

2178

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

8 10904

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

3 7030

Un-Answered Questions { Databases }

How can you perform pattern matching in sql?

1009

What is the need of merge statement?

1052

What are the importance of partitioning in dbms?

978

what is a trigger? : Sql dba

1047

Explain the different types of database keys?

990

What are operators in oracle?

1073

How to use go command in "sqlcmd"?

1219

What is environment of openedge?

936

What is a query in mysql?

1005

How do you create a module in microsoft access?

971

What is a deterministic function?

1084

How oracle flex asm works?

What are the two types of indexes and explain them in detail?

949

What is microsoft access point?

791

Which Model uses the SET concept

999

For More Un-Answered { Databases } Questions Click Here