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

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

Punjab National Bank,

1 8028

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1 1938

How to retrieve first and last records from a table?

DELL, QSmart,

7 12360

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

College School Exams Tests, DELL,

5 10969

How do u count no of rows in a table?

CTS,

8 16256

how can we store space between two strings in database i.e oracle

HCL,

2 6551

what programming language which is used for testing and developement in sql?

3 5467

what is the advantage of left outer join?

2 14130

What is Stored Procedure? What is Views in sql server? Difference between a User Defined Function and a Stored Procedure Difference between a primary key and a unique key? What is a join and explain different types of joins. Difference between temp table and table variable Difference between Triggers and Stored Procedures Difference between UNION ALL Statement and UNION What is COALESCE / Why do we use COALESCE? Why we use SET ROWCOUNT in Sql How many clustered index can have a table How many types of local tables in SQL SERVER Difference between DELETE and TRUNCATE What is Aggregate Functions? What is Row_Number()? What are Ranking Functions? What is NOLOCK? What is CTE? What are the Advantages of using CTE? What is the STUFF function and how does it differ from the REPLACE function? What are the difference between clustered and a non-clustered index? What are the different index configurations a table can have? Difference between a HAVING CLAUSE and a WHERE CLAUSE? Difference between SET and SELECT Provide all the built in string function of SQL SERVER Difference between char and varchar data types Define candidate key, alternate key, composite key. What are constraints? Explain different types of constraints. What is a self join? Explain it with an example. How will you convert table row to a column comma separated value

ACS,

4 12171

what is the maximum size of sql row in mssql?

1 5841

What is integrity and what is constraint??Explain with example

Google,

1 2361

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 4171

difference between procedures and function?

IBM,

7 10699

wirte the syntax of update query?

IBM,

3 5664

what is sql.

Ericsson, Hewitt,

7 11852

Un-Answered Questions { Databases }

how to start mysql server? : Sql dba

1257

What are the steps in creating a database?

995

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

Disadvantages of the indexes?

1215

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

2174

How to provide default values to function parameters?

1242

What are wait types?

1228

What is standby servers? Explain types of standby servers.

1067

What is sql or structured query language?

1210

Have you created fact table and dimension tables?

696

How to select all columns of all rows from a table in oracle?

1114

How do I start sql server 2017?

1005

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How can I check that whether automatic statistic update is enabled or not?

1108

What kind of problems occurs if we do not implement proper locking strategy?

1489

For More Un-Answered { Databases } Questions Click Here