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

How to convert numeric values to integers in ms sql server?

1166

What are the advantages of passing name-value pairs as parameters?

1226

How to create a local temporary stored procedure?

1050

What happens if null values are involved in datetime operations?

1029

What is a subquery in a select query statement in ms sql server?

1193

How to see the event list of an existing trigger using sys.trigger_events?

1139

How to provide default values to stored procedure parameters?

1112

How to defragment indexes with alter index ... Reorganize?

1146

What is the default schema of your login session in ms sql server?

1099

Where to find ntwdblib.dll version 2000.80.194.0?

1017

What happens if ntwdblib.dll is missing on your machine?

1193

How to disconnect from a sql server using mssql_close()?

1177

How to turn on the mssql api module in php?

1127

Can select statements be used on views in ms sql server?

1120

How to create a ddl trigger using "create trigger" statements?

1191

Un-Answered Questions { Databases }

How do use Having,Group by,Group function in SQL?

1794

What is innodb mysql?

1165

How many cores do I need for sql server 2016?

957

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1943

How do you run ms_batch file in forms?

How can we monitor the space allocations in a database?

What is a junior dba?

679

What is a trigger word?

1083

What happens to a statement batch if there is a compilation error?

1016

How can you find out how many rows returned in a cursor?

1090

What are the consideration at tehe migration of Oracle 9i to 10G.

3122

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2147

What is an index in sql?

1074

How to execute a stored program unit?

1128

How to use "while" statements in oracle?

1381

For More Un-Answered { Databases } Questions Click Here