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 retrieve daily sal from emp table in oracle 10g

Infosys,

2 6968

What is SQL Profiler and the use of it?

247Customer,

2 5058

What are SQL Jobs, please mention the use of it and how to create them.

247Customer,

1 4722

What are steps required to ENTER DATA INTO DWH?

2 7852

define primary key & secondary key?

2 17441

Write a query to find second highest salary of an employee.

27 28201

which language is used to develop the oracle........?

Infosys,

4 13347

What are the different types of joins and explain them briefly.

3 11836

what is the output of this query selet * from employee where 1=2 ??

11 18604

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 8910

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 13993

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 7419

What is the order in which the SQL query is executed? list them in order.

CarrizalSoft Technologies, CTS, Oracle,

5 11854

Can Having clause be used without Group by clause?

CarrizalSoft Technologies, CSC, CTS,

6 43382

difference between truncate and delete ,drop?

3 7361

Un-Answered Questions { Databases }

Explain encryption of entire databases without the need for application changes in sql server 2008?

1054

What is the difference between procedure and function in mysql?

1031

What is relational database in mysql?

928

What is storage encryption?

What is repeatable read?

1030

Can a primary key be a foreign key?

1037

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1979

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1990

How do I set up postgresql?

884

What is a degree of relation?

1027

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2069

what is scan listener.

2235

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?

1857

User wants only to display only pdf as export option in report manager. How to achieve this?

265

What is the use of extent in informix?

For More Un-Answered { Databases } Questions Click Here