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 test odbc dsn connection settings?

1050

How to find out what is the default collation in a database?

1139

How to add a new dsn with the odbc driver for sql server?

1072

How to delete all rows with truncate table statement in ms sql server?

1011

How to write an inner join with the where clause in ms sql server?

1100

What are the differences between user defined functions and stored procedures?

1085

What is index fragmentation in ms sql server?

1096

How to turn off warning messages during php execution?

1063

What are the differences between char and nchar in ms sql server?

1098

How to generate create function script on an existing function?

1126

What is a collation in ms sql server?

1100

What do you need to connect php to sql server?

1119

What is sql language?

1163

Can another user execute your local temporary stored procedures?

1006

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1024

Un-Answered Questions { Databases }

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

990

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?

2091

How you improve the performance of sql*loader? : aql loader

1024

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

926

What is a rollup clause?

984

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

960

What is a composite primary key?

1106

How to connect to oracle using service name instead of sid?

1034

How do I find the transaction log size in sql server?

975

What is a join in sql? What are the types of joins?

1122

Can I use mysql for free?

916

How to join two tables in a single query using oracle?

1009

What is the difference between nested table and varray?

1021

Compare in and exists?

921

What is authorization and integrity manager?

990

For More Un-Answered { Databases } Questions Click Here