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 write character string constants or literals in ms sql server?

1041

How to test a dml trigger in ms sql server?

1064

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

976

How to create a new table in a given schema?

1202

How to change the ownership of a schema in ms sql server?

1208

How adventureworkslt tables are related?

940

How to download and install microsoft .net framework version 2.0?

1147

What are binary string data types in ms sql server?

1314

What are security principals used in sql server 2005?

1003

How to get the definition of a view out of the sql server?

995

How to get a list of columns in a view using "sys.columns" in ms sql server?

1004

How to receive output values from stored procedures?

1161

How to run queries with sql server management studio express?

1109

What are logical/boolean operations in ms sql server?

1055

How to modify an existing user defined function?

1123

Un-Answered Questions { Databases }

How to load data from multiple files to single target?

572

What is the difference between truncate & delete command?

1196

Explain the difference in execution of triggers and stored procedures?

1030

What is page in sql server?

960

What are the two virtual tables available at the time of database trigger execution?

1235

Explain about system database?

1076

What is difference between function and trigger?

1061

What are the differences between stored procedure and view in sql server?

1259

Explain relationships?

822

How do I start mysql database?

982

What is a concurrency problem in dbms?

988

How to change the password of a login name in ms sql server?

1027

how to start mysql server? : Sql dba

1212

What is table partitioning in sybase?

911

List the different types of joins?

1027

For More Un-Answered { Databases } Questions Click Here