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 change sql*plus system settings?

1054

What is output spooling in sql*plus?

1033

What is oracle sql developer?

1047

How to place comments in pl/sql?

1157

How to install oracle sql developer?

1042

What are sql*plus environment variables?

1093

What operating systems are supported by oracle sql developer?

963

What are the parameter modes supported by pl/sql?

1108

How to connect a sql*plus session to an oracle server?

1126

How to run sql statements through the web interface?

1040

How to run sql commands in sql*plus?

1180

What is null in pl/sql?

1070

How to look at the current sql*plus system settings?

1149

How to run pl/sql statements in sql*plus?

1079

How many scalar data types are supported in pl/sql?

1056

Un-Answered Questions { Databases }

You need to multiply all values of a single column. How would you do that?

886

What is the command dbcc checkdb used for?

1010

List some popular graph databases?

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1077

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

Is inner join faster than left join?

1190

What are the concurrency problems a database faces?

1039

What is database schema name?

1052

Explain about extended stored procedure?

939

How do I download postgresql on windows?

831

How to find the source of a table in sql server?

997

What are the advantages of a procedure?

915

Can a table be created inside a trigger?

967

You need to manipulate varbinary columns in sybase. How would you do that?

957

How to view existing indexes on an given table using sys.indexes?

1091

For More Un-Answered { Databases } Questions Click Here