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

Explain the steps needed to create a scheduled job?

958

What are the types of joins in sql?

1147

What are orphan records?

960

What have included columns when we talk about sql server indexing?

1058

List all the types of user-defined functions?

1127

Why use “nolock” in sql server?

1081

Explain primary key in sql server?

1039

What is the filtered index?

1078

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

925

How will you go about resolving deadlocks?

992

What is the difference between osql and query analyzer?

1017

What is a join in sql?

1118

Why use update_statistics command in sql server?

1072

List out the difference between union and union all in sql server?

1011

What are locks in sql?

996

Un-Answered Questions { Databases }

What is dbms_output put_line?

932

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1069

What are the four objects in a database?

1083

How many types of synonyms in Oracle?

1150

What is mysqli_select_db?

984

Explain what are the characteristics of data files?

1109

Mention the different types of dbms.

1047

What is auditing in sql server?

936

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1996

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2669

How do I connect to postgresql database using pgadmin?

855

What is the difference between mysql and sql server?

1041

Which version of sql do I have?

1081

Explain go command in sql server?

1058

Can views update documents or databases?

For More Un-Answered { Databases } Questions Click Here