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

Which four data types cannot be used as a return type from a user-defined function?

1035

How can you log an error to the server event log from a stored procedure?

1127

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

1021

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1082

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

984

How can I detect whether a given connection is blocked?

1082

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1007

Explain the rollup operator?

1090

How many types of stored procedures are there in sql server?

1033

What is the purpose of linked server configuration in sql server?

1064

In how many ways you can invoke ssrs reports?

145

Explain the advantages and disadvantages of stored procedure?

1168

What are stand-alone procedures?

965

Mention how can you determine what protocol is being used for interconnect traffic?

Mention what are the benefits of oracle rac?

Un-Answered Questions { Databases }

what happens if null values are involved in expressions? : Sql dba

1060

What is pl sql quora?

1190

What is the distinction amongst delete and truncate?

1086

What is actional flow mapping?

955

Which profile required to access Models in Designer tool?

719

What is SDL (Storage Definition Language)?

821

Name the different triggers supported by oracle reports and their firing order.

1109

What is a Garbage Collection? and what is full recursive Garbage collection?

2917

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2164

what is a table in a database ? : Sql dba

1057

How do I uninstall oracle 11g?

1141

What is CDC and explain complete CDC process flow?

603

What is mysqli_connect_error ()?

1043

How is postgresql different from oracle?

786

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1067

For More Un-Answered { Databases } Questions Click Here