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 is the command used to recompile the stored procedure at run time?

1095

What are the methods used to protect against sql injection attack?

1083

Can sql servers linked to other servers?

1062

What is an identity column in insert statements?

1043

Where are sql server user names and passwords stored in sql server?

1112

What is the difference between substr and charindex in the sql server?

1122

What is the difference between getdate and sysdatetime?

1026

What is the use of for clause?

1133

What are scheduled tasks in sql server?

1105

What is bulkcopy in sql?

958

Which command is used for user defined error messages?

1075

What is the use of sign function?

1145

What is the difference between varchar and nvarchar types?

1 1606

What will be query used to get the list of triggers in a database?

1019

What are the two authentication modes in sql server?

1142

Un-Answered Questions { Databases }

how to fetch alternate records from a table? : Sql dba

1129

What is a mysql server?

998

How to rename an existing table?

1154

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1011

What is foreign key in java?

849

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

1002

What is aws aurora postgres?

818

What is a covered index?

951

What is out parameter used for eventhough return statement can also be used in pl/sql?

1093

what are the critical issues you have resloved in your company

1982

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1822

What happens if null values are involved in bitwise operations?

1049

What is tuple with example?

946

Is ms sql traffic encrypted?

939

What is meant by referential integrity?

1024

For More Un-Answered { Databases } Questions Click Here