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

Is the primary key column of a table an index in ms sql server?

976

How to generate create procedure script on an existing stored procedure?

1025

How to write a query with a full outer join in ms sql server?

1097

How to concatenate two character strings together?

1133

How to create a new login name in ms sql server?

1076

How to create a view with data from multiple tables?

1023

How to retrieve field values using mssql_result()?

1335

How to convert a numeric expression from one data type to another?

1031

How to join two tables in a single query in ms sql server?

1007

How to count groups returned with the group by clause in ms sql server?

1077

How to access the deleted record of an event?

1047

How to locate and take substrings with charindex() and substring() functions?

1025

How to list all tables in the database using odbc_tables()?

1059

What are approximate numeric data types in ms sql server?

1072

What are null values in ms sql server?

1101

Un-Answered Questions { Databases }

Difference between connected and disconnected database in .net with sql server?

1111

What are indexes in postgresql?

866

What is recordset in ms access?

845

What is the latest version of neo4j?

What does create schema do?

802

can you tell how can you display the maximum salary in sql? : Mysql dba

874

What are the components of logical database structure in oracle database?

1099

How many joins in sql server?

975

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1127

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

2160

How do I change directories in mysql?

918

What is view explain with example?

943

Write a sql query to display the current date?

1107

Mention what are the main components of an oracle rac system?

How to view all columns in an existing table?

952

For More Un-Answered { Databases } Questions Click Here