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

What are the advantages of using stored procedures in sql server?

1025

How many types of database relationship in sql server?

1072

What is the difference between having clause and where clause in sql server?

1132

What is cdc in sql server?

1017

What is collation sensitivity?

1094

What are the encryption mechanisms in sql server?

1045

What is check constraint in sql server?

1017

What is the use of floor function in sql server?

1101

Define the one-to-one relationship while designing tables.

915

Which is the main third-party tool used in sql server?

959

What is the boxing and unboxing concept in .net?

947

What is the log shipping?

1029

Is there any difference between primary key and unique with the not null condition?

970

In which tcp/ip port does sql server run? Can it be changed?

1006

What is "scheduled jobs" or "scheduled tasks"?

1001

Un-Answered Questions { Databases }

How to use count function in mysql?

939

In DBMS, what are the two integrity rules used?

961

how to check server status with 'mysqladmin'? : Sql dba

1100

How do you create a schema?

965

How will you decide the active and passive nodes?

1153

How do I view a sql database?

1028

Which two can be implemented as a centrally located logical architecture?

938

Is natural join and equi join same?

994

How to use linked server?

1215

What is database white box testing?

1140

How will you monitor replication latency in transactional replication? : sql server replication

1168

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

2046

What is rdbms with example?

997

How do I check if log truncation is blocked in sybase?

837

What is policy based management (pbm)? : sql server database administration

1001

For More Un-Answered { Databases } Questions Click Here