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,

8015

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

1931

How to retrieve first and last records from a table?

DELL, QSmart,

7 12282

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

College School Exams Tests, DELL,

5 10908

How do u count no of rows in a table?

CTS,

8 16192

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

HCL,

2 6537

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

3 5425

what is the advantage of left outer join?

2 14109

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 12128

what is the maximum size of sql row in mssql?

1 5820

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

Google,

2347

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 4152

difference between procedures and function?

IBM,

7 10641

wirte the syntax of update query?

IBM,

3 5636

what is sql.

Ericsson, Hewitt,

7 11749

Un-Answered Questions { Databases }

What is multi-version control?

863

What is the use of sign function?

1204

What is a sql*loader control file?

1350

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3626

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2746

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1112

Are dml statements autocommit?

1098

How do you stop an access query?

972

Define outer join in sql server joins?

994

Define entity set.

970

What is having clause in sql?

1018

What is localhost in mysql?

1064

Please explain oracle left join with an example?

1098

List some case manipulation functions in sql?

1094

How do you bind variables in oracle?

1026

For More Un-Answered { Databases } Questions Click Here