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

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

Oracle,

12 20534

what is difference between procedure and function, procedure and trigger?

iFlex,

8 30579

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 17276

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

iFlex,

8 17471

what are the advantages of package?

iFlex,

7 40489

in materialized view the structure will create immediately or not?

iFlex,

2 9107

which sql command we can use to get a print out from oracle?

iFlex, INDUS,

2 11454

How will we see framework of a table?

Accenture,

2 11966

what is index?

4 8213

what is a view?

7 10266

what is primary key?

9 13357

what is foreign key?

5 8733

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 27496

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 140027

write a query to delete similar records in same table

TCS,

13 25699

Un-Answered Questions { Databases }

Which statement is used in a select query for partial matching?

1239

What is oracle latest version?

1171

How to provide default values to function parameters?

1250

What is self contained sub query?

1138

How can you append an identity column to a temporary table?

1066

do you know how to configure db2 side of the application? : Sql server database administration

1118

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

How to convert character strings into numeric values?

1186

define sql insert statement ? : Sql dba

1094

What is an indexed view?

1018

How to Change a users password from unix shell.

1213

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

What are the properties of the transaction?

1069

What is subquery? Explain the properties of a subquery?

1056

Who proposed the relational model?

1027

For More Un-Answered { Databases } Questions Click Here